6+yrs experience working on Ab Initio development and 2+yrs on Metahub in importing datasets and creating data lineage. This is a MUST!!!.
2+yrs experience working on ACE and BRE and working closely with business in creating rule sets and application config templates. This is a MUST!!
Experience implementing and setting up Ab Initio MHub, importing data sources, identifying required data sets to create data lineage.
Strong understanding or hands-on experience with data quality, data profiling and metadata management procedures.
Industry experience in one or more of the following industries highly preferred (Banking/Securities experience preferred)
Acquire data from internal or external data sources and maintain mapping documents of the files, databases/data systems.
Perform data analysis and data modeling to create source to target mappings.
Evaluate risk from statistical information to determine risk to operations or non-compliance.
Create systems models, specifications, diagrams, and charts to provide direction to business and other IT teams.
Interpret data, analyze results and work closely with Data Stewards to gather good understanding of the Data and perform data profiling to create Data cleansing rules.
Knowledge of Data processing in Hadoop architecture is nice to have.
Profile & Analyze Source Data (Mainframe Extracts, Oracle tables & UNIX flat files) usage using Ab Initio Data Quality Environment (DQE).
Identify data migration themes and quality patterns represented in the data analysis results and provide guidance to the ETL designers regarding data quality of source data.