msr technology groupSpringfield, IL
Informatica MDM Technical Lead / Architect
Informatica MDM Technical Lead / Architect
Informatica MDM Technical Lead / Architect
msr technology groupSpringfield, IL
Apply for this role (opens in a new tab)yesterday
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.
Also on the board Same function, level within a rung
Level
Manager
Location
Springfield, IL
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
yesterday