Informatica MDM Technical Lead / Architect Job at MSR Technology Group, Springfield, IL

  • MSR Technology Group
  • Springfield, IL

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

Similar Jobs

Citizens Financial Group, Inc.

Mortgage Loan Officer-NY Std Job at Citizens Financial Group, Inc.

 ...our customers.Citizens is honored to be a top Lender in the Mortgage sector and is passionate about growing our market share in the...  ...currently operate. We are currently hiring dedicated Mortgage Loan Officers who proactively identify, build and maintain a quality... 

SteelStone

Industrial Designer Job at SteelStone

 ...Industrial Designer Gourmia stands as a trusted name in the world of kitchen appliances, focusing on innovative, quality-driven products that cater to modern culinary needs. Our diverse product range of air fryers, smokeless grills, and other kitchen innovations are... 

Foundation Partners Group

Funeral Home Manager Job at Foundation Partners Group

 ...Funeral Home ManagerRevolutionizing the funeral industry means blazing new trails, creating new ideas, developing...  ...are currently seeking a highly talented Funeral Home Manager at Advent Funeral & Cremation Services with locations in Lanham, MD and Falls Church, VA. The... 

RSM International

Workday Security Sr. Analyst Job at RSM International

 ...no one like you and thats why theres nowhere like RSM.This role supports the design, configuration, and maintenance of Workday security, ensuring secure, compliant, and scalable access across HCM modules, reporting, and integrations. The individual partners with HR,... 

Hand & Stone - 649 US-206 - Hillsborough Township, NJ

Spa Manager Job at Hand & Stone - 649 US-206 - Hillsborough Township, NJ

 ...off ~ Vision insurance ~ Wellness resources ~401(k)~401(k) matching ~ Bonus based on performance ~ Dental insurance Spa Manager Hand & Stone Massage and Facial Spa Hillsborough, NJ We're hiring a full-time Spa Manager to lead our full-service Hand...