Informatica MDM Technical Lead / Architect
hace 1 día
Springfield
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.