Informatica MDM Technical Lead / Architect

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

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