MDM ETL Specialist / Developer
Work Location & Model
Work Arrangement: 100% Remote
Location Requirements:
Must reside within the Continental United States.
Candidates located in the Central U.S., Illinois, or Midwest region are preferred.
Travel:
Occasional travel may be required based on project needs.

Position Summary
We are seeking an experienced MDM ETL Specialist / Developer to provide hands-on technical development, support, and delivery for Master Data Management (MDM) services supporting a large-scale Health and Human Services innovation initiative.
This role focuses on Informatica MDM, Informatica PowerCenter, data integration, ETL development, data quality, data governance, and analytics supporting a unified cross-agency client/member view across State programs.
The selected candidate will work under the guidance of the MDM Technical Lead to:
Develop and support MDM technical solutions
Build and maintain Informatica workflows and data loads
Develop and optimize SQL queries and ETL processes
Leverage Python automation where appropriate
Troubleshoot production issues
Support QA, testing, and validation activities
Ensure stable and reliable MDM operations
Program Overview
The MDM team supports a statewide initiative designed to:
Integrate data from multiple State agencies to create a unified client/member view.
Improve service delivery across State programs through consolidated and trusted data.
Support advanced analytics, reporting, and business intelligence initiatives.
Develop custom dashboards and reporting solutions.
Leverage Informatica MDM and related integration technologies.
Support enterprise-wide data quality and governance initiatives.
Improve consistency, integrity, and stewardship of critical enterprise data.
Enable policy development and program evaluation through trusted data assets.
Identify opportunities to improve operational efficiency and program outcomes through data-driven insights.
Key Responsibilities
Informatica MDM & ETL Development
Utilize Informatica MDM to combine and transform data from multiple source systems.
Apply data transformations, corrections, and enhancement requests through established change management processes.
Develop, maintain, and support MDM solutions and operational processes.
Create and maintain Informatica:
Mappings
Mapplets
Sessions
Workflows
Implement and support MDM jobs and data integration processes.
ETL Design & Support
Work with ETL transformations including:
Aggregator
Expression
Filter
Router
Sequence Generator
Update Strategy
Joiner
Rank
Source Qualifier
Lookup
Sorter
Schedule and monitor ETL/Informatica jobs across:
Development
Testing
Production environments
Automate data staging activities through scripting and scheduling.
SQL Development
Develop, maintain, and optimize complex SQL queries and scripts.
Support data marts and enterprise data solutions in large-scale relational database environments.
Perform data validation, reconciliation, and troubleshooting activities.
Production Support
Troubleshoot and resolve post-release production issues.
Perform root cause analysis and implement corrective actions.
Support operational stability and performance tuning activities.
Testing & Quality Assurance
Collaborate with QA teams to:
Resolve defects
Support validation efforts
Test MDM processes
Participate in:
Unit Testing
Integration Testing
System Testing
Technical Collaboration
Participate in project discussions and architecture reviews.
Document technical solutions and recommend alternative approaches when appropriate.
Work closely with technical leads, analysts, developers, QA teams, and business stakeholders.
Required Qualifications
Experience
5+ years of experience in:
Master Data Management (MDM)
ETL/ELT Development
Data Engineering
Data Integration Development
Informatica Expertise
3+ years of hands-on experience implementing and supporting Informatica MDM.
Strong experience with Informatica:
Mappings
Mapplets
Sessions
Workflows
Scheduling
Monitoring
Job Troubleshooting
Technical Skills
Strong SQL experience in large enterprise database environments.
Experience working with large MDM platforms and relational database systems.
Python experience for:
Automation
Scripting
Testing
Data processing support
Data Management Experience
Data Quality
Data Matching
Record Standardization
Unique Client/Member Identifier Management
Data Reconciliation
Data Governance
Operations & Delivery
Experience supporting:
MDM Operations
Performance Tuning
Production Support
Issue Resolution
SDLC Delivery
Education
Bachelor’s Degree in:
Computer Science
Information Systems
Data Analytics
Engineering
Or equivalent professional experience
Preferred Qualifications
MDM & Data Management
Experience with additional MDM platforms and cloud-native MDM solutions.
Experience supporting MDM modernization initiatives.
Industry Experience
Experience supporting:
State Government
Public Sector Organizations
Regulated Environments
Healthcare
Medicaid
Claims Data
Eligibility Data
Provider Data
Health & Human Services Programs
Agile Delivery
Agile/Scrum experience
Sprint-based development experience
Iterative and incremental delivery methodologies
Integration Technologies
Experience or exposure to:
X12
EDI
XML
JSON
REST APIs
HL7/FHIR
Cloud & Modern Data Platforms
Experience with:
Azure
Azure Data Factory (ADF)
Databricks
Snowflake
Data Lakes
Cloud Data Platforms
Modernization Initiatives
Experience supporting:
On-Premises to Cloud Migrations
MDM Modernization Programs
EDW Modernization
ETL Modernization Projects
Emerging Technologies
Exposure to:
AI/ML
Generative AI (GenAI)
LLM-Assisted Engineering
Test Automation
Data Quality Automation
Additional Skills
Ability to work independently in a remote and matrixed environment.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent communication and collaboration abilities.

Ideal Candidate Profile
The ideal candidate will possess:
✅ Hands-on Informatica MDM experience
✅ Strong Informatica PowerCenter and ETL development expertise
✅ Advanced SQL skills
✅ Python scripting and automation experience
✅ MDM data quality and governance knowledge
✅ Production support and troubleshooting experience
✅ Healthcare, Medicaid, or Public Sector experience
✅ Cloud platform exposure (Azure, Databricks, Snowflake, ADF)
✅ Strong SDLC, testing, and Agile delivery experience

ETL Specialist

Similar Other Jobs

Sr. Manager, Business Development & Commercial Analytics

Vice President, Business Intelligence

Director, Brand Insights & Analytics

Project Manager Healthcare Analytics - SHP Finance - Day Shift - Full Time

Unstructured Data & Knowledge Team - Analytics Solutions Manager

Senior Product Associate, Data & Analytics-Intelligent Payments