MDM ETL Technical Lead - Remote

Myticas Consulting Inc.; Springfield (IL); Remote; USD 83,000 - 99,000; Full time

Job summary

Clover Consulting is seeking an experienced MDM ETL Expert/Technical Lead for a 12+ month contract, remote with occasional travel to Illinois. You will provide technical leadership, hands-on delivery, and guide MDM/ETL teams on Informatica MDM/PowerCenter, data quality, governance, and analytics for HHSi2 project.

Your role includes developing SQL/Python automation, supporting QA, and maintaining reliable MDM operations across state programs.

Qualifications

• 8+ years of experience in MDM, ETL, data integration, enterprise data platforms.
• 5+ years of hands-on experience with Informatica MDM and Informatica PowerCenter.
• Strong experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs.
• Strong SQL experience with large MDM and DBMS enterprise relational platforms.
• Experience with data quality, matching, unique client/member identifier, standardization, reconciliation, and data governance concepts.
• Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery.
• Experience with Python programming for scripting, automation, testing, or data processing support.
• Bachelor’s degree in computer science, Data Analytics, Information Systems, Engineering, or equivalent experience.

Responsibilities

• Own MDM technical solution delivery, including review of technical documentation to design MDM solutions that meet business needs.
• Design MDM solution with security and privacy by design, aligned with CISO guidelines.
• Provide leadership and coordinate or lead work for Informatica MDM and related ETL delivery activities.
• Automate staging of data by scheduling scripts to run at optimal times.
• Implement MDM jobs by creating mappings, mapplets, sessions, and workflows.
• Schedule and monitoring ETL/Informatica jobs in development, testing, and production environments.
• Document workflows and technical specifications.
• Develop proactive processes for monitoring capacity and performance tuning.
• Troubleshoot production support issues post-release deployment and coordinate with State IT.

Skills

MDM

ETL

Data integration

SQL

Python

Data governance

Healthcare data

Informatica MDM

Informatica PowerCenter

Education

Bachelor’s degree in CS/IS/Engineering

Tools

Informatica MDM

Informatica PowerCenter

Job description

Clover Consulting is seeking an experienced MDM ETL Expert/Technical Lead for a 12+ month contract, remote with occasional travel to Illinois. You will provide technical leadership, hands-on delivery, and guide MDM/ETL teams on Informatica MDM/PowerCenter, data quality, governance, and analytics for HHSi2 project.

Your role includes developing SQL/Python automation, supporting QA, and maintaining reliable MDM operations across state programs.