Informatica MDM Developer ETL / SQL
•Today
| Estimated Pay info | Based on similar jobs in your market$41 per hour |
|---|---|
| Hours | Full-time |
| Location | Springfield, IL Springfield, Illinois open_in_new |
About this job
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 Contract Opportunity (not open to third parties)
Central U.S. / Illinois / Midwest candidates preferred
Occasional travel may be required
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.
- 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.
- 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.
- 100% remote within the continental U.S.
- Central U.S., Illinois, or Midwest location preferred.
- Occasional travel may be required.
Nearby locations
Nearby Job Titles
Driver Jobs Fast Food Preparation Worker Jobs Insurance Sales Agent Jobs Truck Driver Jobs Services Sales Representative JobsNearby Locations
Springfield, IL Jobs Chatham, IL Jobs Petersburg, IL Jobs Williamsville, IL Jobs Illinois JobsNearby Companies
DoorDash Jobs Oracle Jobs U.S. Navy Jobs Platinum Supplemental Insurance Jobs HMG Careers JobsNearby Categories
Full-time Jobs Part-time Jobs Gig Jobs Posting ID: 1306135312 Posted: 2026-10-25 Job Title: Developer Etl Sql