Informatica MDM Developer ETL / SQL

Job Description

Job Description

Informatica MDM Developer – ETL / SQL

Remote – Continental U.S.
Contract Opportunity (not open to third parties)
Central U.S. / Illinois / Midwest candidates preferred
Occasional travel may be required

Position Overview

We are seeking an experienced Informatica MDM Developer to support a large-scale Master Data Management environment. This is a hands-on development role focused on Informatica MDM, ETL/data integration, SQL, data quality, and Python automation.

The developer will build and support MDM solutions, Informatica workflows and data loads, troubleshoot production issues, support testing and defect resolution, and help maintain reliable MDM operations.

Key Responsibilities

• Develop and support solutions using Informatica MDM.
• Integrate data from multiple source systems to support a unified client/member view.
• Develop Informatica mappings, mapplets, sessions, workflows, and transformations.
• Work with transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank, Source Qualifier, Lookup, and Sorter.
• Schedule and monitor Informatica/ETL jobs across development, system testing, and production environments.
• Automate data staging and processing through scripting.
• Develop, maintain, and analyze complex SQL queries and scripts.
• Work with large enterprise relational databases and Teradata.
• Support data quality, matching, standardization, reconciliation, and data governance processes.
• Troubleshoot production and post-release issues and develop solutions.
• Work directly with QA teams on defect resolution, validation, and testing.
• Participate in unit, integration, and system testing.
• Participate in technical discussions and recommend solutions or requirements.
• Use Python for scripting, automation, testing, or data processing support. 

Required Qualifications

• 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development.
• 3+ years of hands-on Informatica MDM implementation experience.
• Hands-on experience developing Informatica mappings, mapplets, sessions, workflows, and transformations.
• Experience scheduling, monitoring, and troubleshooting Informatica jobs.
• Strong SQL experience working with large MDM and enterprise relational database platforms.
• Experience with data quality, matching, unique client/member identifiers, standardization, reconciliation, and data governance.
• Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery.
• Python experience supporting scripting, automation, testing, or data processing.
• Bachelor’s degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience.

Preferred Qualifications

• Experience with other MDM platforms, including cloud-native MDM solutions.
• State government, public-sector, or regulated-industry experience.
• Healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data experience.
• Agile/Scrum experience.
• Exposure to X12, EDI, XML, JSON, APIs, or HL7/FHIR.
• Exposure to Azure, ADF, Databricks, Snowflake, Data Lake, or similar cloud data platforms.
• Experience with MDM, EDW, ETL, or on-premises-to-cloud modernization initiatives.
• Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering.
• Ability to work independently in a remote, matrixed environment. 

Work Arrangement

• 100% remote within the continental U.S.
• Central U.S., Illinois, or Midwest location preferred.
• Occasional travel may be required.