Datastage​/Data Quality

We have immediate need for a Data Quality & Data Profiling technical full-time consultant who is business and technology savvy to become an integral part of our team.

• Analyze business requirement for Data Quality rules.
• Perform data profiling, evaluate the quality of the data, identify, and interpret trends or patterns in data sets.
• Work with SMEs and business representatives to understand current data and define the appropriate mapping, resolving discrepancies during data definition as well as providing testing support.
• Data mapping exercise to map KDE elements to data base table and columns.
• Understand ETL Transformation logic when moved to different hops.
• Design and Develop ETL extract job to source to DQ rules.
• Develop DQ validation logic.
• Develop rules in IBM Information analyzer, Collibra OwlDQ
• Integrate IA rules to Data Stage job.
• Generate exception files and load exceptions to table.
• Develop process to load to DQ control tables.
• MQ job creation
• TWS job creation and dependency set-up.
• Resolve any inconsistency with the exceptions.
• Strong SQL skills
• IBM info sphere

• Must be onsite in Jersey City 1x week.
• Onsite 1x week in Jersey city - no exceptions
• Must be hands on with data mapping, data profiling, Data quality , ETL extract, transfer, and load exp.,
• Must have exp developing Data Quality Validation logic.
• Analyzing gaps
• Open to industry; prefers out of banking but not a must.
• Must have other data quality tools experience like OWLDQ or Information Analyzer
• 2 rounds of interviews: one with the hiring manager and the second round will be with the team