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 strongworking 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 adevelopment 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.
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
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
CHRISTUS HEALTH is an international Catholic, faith-based, not-for-profit health system comprised of almost more than 600 services and facilities, including more than 60 hospitals and long-term care facilities, 350 clinics and outpatient centers, and dozens of other health ministries and ventures. CHRISTUS operates in 6 U.S. states, Colombia, Chile and 6 states in Mexico. To support our health care ministry, CHRISTUS Health employs approximately 45,000 Associates and has more than 15,000 physicians on medical staffs who provide care and support for patients. CHRISTUS Health is listed among the top ten largest Catholic health systems in the United States.