Send me more jobs like this

Informatica Data Quality

Keywords / Skills : Informatica

3 - 6 years
Posted: 2019-07-21

Posted On
21st Jul 2019
Job Ref code
Job Description
Job Description :
Job Description
• Profile source data and determine all source data and metadata characteristics; Design and execute a Data Quality Audit/Assessment; Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data
• Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment.
• Document all mappings, mapplets, and rules in detail and hand over documentation to the customer
• Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ
• Utilize Informatica Developer, Informatica Power Exchange, Informatica Metadata Manager , and Informatica Analyst to design and develop custom objects and rules, reference data tables and create/import/export mappings
• As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools
• Develop "matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates
• Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing
• Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and other ETL tools
• Proficient at writing SQL queries and verifying the results
• Should be familiar in migrating objects from IDQ to PowerCenter or other Informatica tools
• Should be familiar in deploying and validating objects to different environments
• 4 or more years of IT development/programming/coding professional work experience with a minimum of 3 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10. x preferred).

Key Skill(s)

Similar Jobs
View All Similar Jobs
Walkin for you