Informatica MDM Technical Lead / Architect

Job Description

Job Description

Informatica MDM Technical Lead / Architect

Location: Remote, Continental U.S.
Work Arrangement: 100% Remote
Employment Type: Contract
Schedule: Full-Time

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.

• 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
  • Expression
  • Filter
  • Router
  • Sequence Generator
  • Update Strategy
  • Joiner
  • Rank
  • Source Qualifier
  • Lookup
  • Sorter
• Schedule, 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.

• 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
  • Mapplets
  • Sessions
  • Workflows
  • ETL 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.

• 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:
  • X12
  • EDI
  • XML
  • JSON
  • APIs
  • HL7/FHIR
• Exposure to cloud data platforms and modernization initiatives involving:
  • Azure
  • Azure Data Factory
  • Databricks
  • Snowflake
  • Data 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.

• 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.