MDM ETL Specialist: Data Quality & Integration Lead

Myticas Consulting Inc.; Illinois; Remote; USD 77,000 - 91,000; Full time

Job summary

Clover Consulting is seeking an experienced MDM ETL Specialist/Developer for a 12+ month contract. Remote work with occasional travel to Illinois.

The role centers on Informatica MDM, PowerCenter, data integration, quality, and governance to provide a unified client view across state programs. The candidate will develop and support MDM solutions, automate data processes, troubleshoot production issues, and collaborate with QA to ensure reliable MDM operations.

Qualifications

• 5+ years of MDM, ETL, data engineering, or data integration experience.
• 3+ years of hands-on Informatica MDM implementation experience.
• SQL experience with large enterprise relational platforms.
• Experience with Python for scripting and automation.
• Experience with data quality, governance, matching and reconciliation.

Responsibilities

• Use Informatica MDM to combine source data with transformations and new fields.
• Support MDM development and operational activities.
• Automate data staging by scheduling scripts.
• Develop mappings, mapplets, sessions, workflows for MDM jobs.
• Create and monitor ETL transformations and Informatica jobs.
• Develop and analyze complex SQL queries for data marts.

Skills

MDM/ETL Experience

Informatica MDM

SQL

Python scripting

Data governance concepts

SDLC delivery

Education

Bachelor’s degree

Tools

Informatica MDM

Informatica PowerCenter

Job description

Clover Consulting is seeking an experienced MDM ETL Specialist/Developer for a 12+ month contract. Remote work with occasional travel to Illinois.

The role centers on Informatica MDM, PowerCenter, data integration, quality, and governance to provide a unified client view across state programs. The candidate will develop and support MDM solutions, automate data processes, troubleshoot production issues, and collaborate with QA to ensure reliable MDM operations.