Job Description
Job Description
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
- 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.
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
- 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.
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.
Job Tags
Full time, Contract work, Remote work