Sign in

Sr ETL/IDQ developer (Informatica) Dallas TX himanshu

ESR Healthcare
Dallas, TX
November 06, 2019

Posted By Premium Recruiter


Sr ETL/IDQ developer (Informatica) Dallas TX himanshu

Location :: Dallas TX

Job Description::

(8yr of EXP ) “Informatica Developer” who can 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

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 the 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