Remote MDM ETL Specialist/Developer — Informatica Expert

Myticas Consulting Inc.; Illinois; Remote; USD 77.000 - 91.000; Vollzeit

Zusammenfassung

Clover Consulting has a direct client in Springfield, IL in need of an MDM ETL Specialist/Developer for a 12+ months contract. The role focuses on Informatica MDM, PowerCenter, data integration and governance to support Illinois HHSi2.

You will work remotely with occasional travel to Illinois; rate $56–$66 per hour on W2/C2C. Relevant experience in MDM/ETL, SQL and Python required; bachelor’s degree preferred.

Qualifikationen

• 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development.
• 3+ years of hands-on Informatica MDM implementation experience.
• Experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs.
• SQL experience with large MDM and DBMS enterprise relational platforms.
• Experience with data quality, matching, unique client/member identifiers, standardization, reconciliation, and data governance.

Aufgaben

• Use Informatica MDM to combine source data from agency sources and create data changes.
• Support MDM development and operational activities.
• Automate data staging by scheduling ETL scripts for performance gains.
• Create mappings, mapplets, sessions, and workflows for MDM jobs.
• Work with various ETL transformations and monitor jobs in all environments.
• Troubleshoot post-release production issues and resolve defects.
• Develop and analyze complex SQL queries to create data marts in Teradata.
• Collaborate with QA to validate MDM processes and support testing.
• Participate in design discussions to suggest alternatives or requirements.
• Participate in unit, integration, and system testing.

Kenntnisse

Informatica MDM

Informatica PowerCenter

SQL

Data quality

Python

ETL/ELT

Ausbildung

Bachelor's degree in CS/IS or equivalent

Tools

Informatica MDM

Teradata

Jobbeschreibung

Clover Consulting has a direct client in Springfield, IL in need of an MDM ETL Specialist/Developer for a 12+ months contract. The role focuses on Informatica MDM, PowerCenter, data integration and governance to support Illinois HHSi2.

You will work remotely with occasional travel to Illinois; rate $56–$66 per hour on W2/C2C. Relevant experience in MDM/ETL, SQL and Python required; bachelor’s degree preferred.