POSITION SUMMARY:

The Informatica Data Quality and ETL developer III is responsible for facilitating enterprise data quality and data integration design, development and implementation for healthcare data warehouses/marts/lakes and models. This includes an understanding of Data Quality and integration Architecture, methodology, design, coding, implementation, monitoring, and support standards through the ETL toolsets. Will be involved in strategic planning activities and researches emerging technology and tools, and Data Quality best & emerging practices.

The role will contribute to MDM and Data Quality flows within the Data Management and Analytics team at CHRISTUS Health's Information Management.

Individual must have a strong working knowledge of designing and developing data quality flows. The ETL Developer III must have proven advanced applied knowledge in the following areas:

• Designing & developing complex ETL packages using Informatica' s developer (DQ) and Power Center
• Writing and debugging complex SQL queries & performance tuning
• Implementing error handling, performance tuning and accepted industry best practices.
• Implementation of Data quality models and processes using Informatica Developer/ DT toolset.

Individual may work alone or as a development project lead

The Developer III is expected to lead projects in the agile methodology and present results in determined 'sprint' timelines to the VP of Data Management and Analytics.

POSITION QUALIFICATIONS:

A. Education/Skills:

• Bachelor degree in Computer Science, Engineering, Math or related field or equivalent experience -- ten years required
• Strong technical knowledge of Enterprise Warehouses, Data Quality and incremental development of ETL packages, data quality models, operating systems and data quality/cleansing processes.
• Extensive development experience in the Informatica DQ and PowerCenter toolsets.
• Master Data management, governance and Teradata/ SQL Server experience preferred
• Healthcare industry experience is strongly preferred
• Strong Analytical and PLSQL skills
• Expected to resolve complex problems with little or no direction
• Ability to interact effectively and patiently with customers especially while under pressure and maintain positive working relationships with other employees.
• Ability to work on multiple projects/tasks simultaneously to meet project deadlines as required without losing velocity.
• Understanding of Message Queue or other real-time systems and overall optimization techniques

B. Experience

• A total of ten (10) years of related experience in corporate systems environments required.
• Experience with a variety successful Data Quality implementations utilizing Informatica
• Minimum of five (5) years' experience with Informatica Data Quality development in designing and implementing rules and cleansing techniques
• Minimum of ten (10) years' experience with Informatica Power Center in designing and developing complex ETL packages
• Minimum of seven (7) years' experience with writing and debugging complex SQL queries and analysis work.
• Minimum of ten (10) years of experience in designing and loading data models using incremental dimensional modeling
• Experience with configuring human task validations, content management and management of library subscriptions
• Analyst, Metadata Manager experience required
• DVO and 360 experience preferred
• Minimal XML development required and Big Data integration strongly preferred
• Exposure to real/near time data load using Informatica
• HL7 and EDI experience highly preferred