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
Build human task workflow scenarios and IDQ scorecards to support data remediation
Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and other ETL tools
Serve as the primary resource to team members and data stewards for training, problem resolution, data profiling etc.
Analyze and provide data metrics to management in order to help prioritize areas for data quality improvement
Participate in improvement of master data management process and support transactional systems and processes
Good knowledge on writing shell-scripts to invoke mappings or workflows
Proficient at writing SQL queries and verifying the results