Now Hiring: Are you a driven and Motivated Software Engineer?

Banking Data Lineage

Banking Data Lineage (Financial company in US)

Overview

Banking Data Lineage (Financial company in US)

Share

Requirements

Our solution

Business terms were not standardized, could not be identified without a corresponding physical asset and cannot be linked to multiple assets
Created program to read inputs based on the target repository format and loaded using REST API
Current DB2 z/OS based business glossary was not intuitive, tool and project specific, not user friendly
Integrated Metadata for data lineage for INFA, Cognos, SQL scripts UDB, SSAS cubes. Assigned business terms to technical metadata
Data lineage- no integrated capabilities, multiple silos, lack of documentation specs, not trusted, difficult to track, lacking for SSAS cubes, UDB, INFA & Cognos
Created automated metadata extraction and integration for lineage and documentation

Results:

Enabled better data governance by providing data lineage across multiple BI and ETL applications running on different platforms (INFA, Cognos, Mainframe DB2, DataStage, etc.)

Accelerated business decision making by providing efficient business glossary, standards and accuracy.

Reduce cost of data integration processes by identifying redundancy in processes and streamlined ETL process by reducing redundant processes

Testimonials

Why do people love our service?