Skip to main content
David Careers

Informatica MDM Technical Lead / Architect

Posted yesterday

msr technology groupSpringfield (IL)
Data Warehousing SpecialistsComputer Systems Design Services

SENIORITY

Manager

Apply (opens in a new tab)

About the role

Job Description: Informatica MDM Technical Lead / Architect Location: Remote, Continental U.S.
Work Arrangement: 100% Remote Employment Type: Contract Schedule: Full-Time Position Summary We are seeking an experienced Informatica MDM Technical Lead / Architect to provide technical leadership and hands-on delivery for a large-scale Master Data Management initiative supporting a statewide Health and Human Services environment. This position requires someone who can combine strong MDM architecture and technical leadership with hands-on Informatica MDM and PowerCenter expertise. The selected candidate will lead MDM technical delivery, guide MDM/ETL specialists and developers, support Informatica workflows and data loads, develop and optimize SQL and Python-enabled automation, troubleshoot production issues, support QA/testing, and help maintain reliable MDM operations. This is not solely a data governance or MDM strategy position. The ideal candidate will have significant hands-on experience designing, developing, troubleshooting, and supporting enterprise Informatica MDM and ETL solutions.
Key Responsibilities:
  • Own MDM technical solution delivery, including reviewing technical documentation and designing solutions that meet business requirements.
  • Design MDM solutions with security and privacy principles incorporated into the architecture.
  • Provide technical leadership for Informatica MDM and related MDM/ETL delivery activities.
  • Lead and provide technical direction to MDM ETL Specialists and developers.
  • Use Informatica MDM to integrate data from multiple source systems and support enterprise master data processing.
  • Apply data transformations, corrections, standardization, and new data elements through established change processes.
  • Automate data staging processes and schedule scripts to optimize system performance and efficiency.
  • Develop MDM and ETL jobs using mappings, mapplets, sessions, and workflows.
  • Work with Informatica transformations including: Aggregator
  • ExpressionFilterRouterSequence Generator
  • Update Strategy
  • JoinerRankSource Qualifier
  • LookupSorterSchedule, monitor, and troubleshoot Informatica/ETL jobs across development, system testing, and production environments.
  • Document workflows and technical specifications.
  • Develop proactive processes for capacity monitoring and performance tuning.
  • Provide technical guidance and support to development teams. Troubleshoot production issues following releases and implement appropriate technical solutions.
  • Troubleshoot server and software issues in coordination with IT teams. Develop, maintain, and analyze complex SQL queries and scripts used to support enterprise data environments and Teradata data marts.
  • Work directly with QA and business teams on data validation, defect resolution, and testing of MDM-related processes.
  • Participate in unit, integration, and system testing.
  • Recommend alternative technical solutions when appropriate.
  • Support data quality, matching, standardization, reconciliation, and master data processes.
  • Use Python for scripting, automation, testing, or data processing where appropriate.
  • Provide technical status updates and meet established project deliverables.
Required
Qualifications:
  • 8+ years of experience across MDM, ETL, data integration, and enterprise data platforms.5+ years of hands-on experience with Informatica MDM and Informatica PowerCenter.
  • Strong hands-on experience developing: Mappings
  • MappletsSessionsWorkflowsETL transformations
  • Strong experience scheduling, monitoring, troubleshooting, and supporting Informatica jobs.
  • Strong SQL experience working with large enterprise relational database and MDM environments.
  • Experience with: Data quality
  • Data matching
  • Unique client/member identification
  • Data standardization
  • Data reconciliation
  • Data governance
  • Experience supporting production ETL and MDM operations. Experience with performance tuning and technical issue resolution.
  • Experience working throughout the SDLC.Hands-on Python programming experience for scripting, automation, testing, or data processing.
  • Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience.
Preferred Qualifications:
  • Experience with additional MDM technologies, including cloud-native MDM solutions.
  • Experience developing software or workflows using Python or other open-source technologies. State Government, public-sector, or other regulated-industry experience.
  • Healthcare, Medicaid, claims, eligibility, provider, member, or Health and Human Services data experience.
  • Experience with Agile/Scrum and iterative development environments.
  • Experience with interoperability and integration technologies such as: X12EDIXMLJSONAPIsHL7/FHIRExposure to cloud data platforms and modernization initiatives involving: AzureAzure Data Factory
  • DatabricksSnowflakeData Lakes
  • Experience with on-premises-to-cloud migration, MDM modernization, or EDW/ETL modernization initiatives.
  • Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data quality.
  • Ability to work independently in a remote, matrixed environment with minimal direction.
  • Location & Work Model 100% remote.
  • Candidates must reside within the continental United States.
  • Central U.S., Illinois, or Midwest-based candidates are preferred.
  • Occasional travel may be required based on project needs.

Before you apply

Applying takes about a minute. These four things decide how fast it moves after that.

Your profile is current

It's what we read first. Occupations, seniority and locations matter more than a long history.

Two examples you can talk through

Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.

A number in mind

What you're on now and what would make you move. We negotiate better when we know both.

Your notice period

Employers plan around it, and it's the question that stalls offers most often.

Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.

More like this