8+ years of experience in MDM, ETL, and data integration.
5+ years of hands-on experience with Informatica MDM and PowerCenter.
Strong SQL skills with large MDM and DBMS platforms.
Experience in data quality, matching, and data governance concepts.
Proficient in Python for scripting and automation.
Bachelor's degree in Computer Science, Data Analytics, or related field.
Responsibilities
Own MDM technical solution delivery and design solutions that meet business needs.
Design MDM solutions with security and privacy considerations.
Lead Informatica MDM and ETL delivery activities, assigning tasks to specialists.
Implement MDM jobs using various ETL transformations and tools.
Automate data staging and monitor ETL jobs across environments.
Develop processes for capacity monitoring and performance tuning.
Troubleshoot production issues and coordinate with IT for resolutions.
Collaborate with QA and business teams for testing and defect resolution.
Benefits
Opportunity to lead meaningful projects in a people-first environment.
Collaborative work culture with passionate teams.
Career growth opportunities in consulting.
Exposure to innovative technologies and methodologies.
Full Job Description
What You'll Do
As the technical lead for, you'll own design, delivery, and day-to-day operations:
Own MDM technical solution delivery, including review of technical documentation to design MDM solutions that meet business needs.
Design MDM solution with security by design and privacy by design and align with the Chief Information Security Office (CISO) guidelines.
Provide leadership and coordinate or lead work for Informatica Master Data Management and related MDM ETL delivery activities; provide project direction and assign work to MDM ETL Specialists.
Use Informatica MDM tool to combine source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process.
Implement MDM jobs by creating mappings, mapplets, sessions, and workflows, working with ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
Automate the staging of data by scheduling scripts to run at optimal times, and schedule and monitor ETL/Informatica jobs in development, system testing, and production environments.
Develop proactive processes for monitoring capacity and performance tuning, and document workflows and technical specifications.
Troubleshoot production support issues post-release deployment and produce solutions, and troubleshoot server or software issues in coordination with the State IT department.
Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata, and use other software tools such as Python as necessary to enhance MDM and data integration.
Work directly with the Quality Assurance and business team to support validation, defect resolution, and unit, integration, and system testing, and provide status updates and meet deliverables to Optum's leadership and the State Project Managers.
Requirements
What You Bring
8+ years of experience in MDM, ETL, data integration, enterprise data platforms.
5+ years of hands-on experience with Informatica MDM and Informatica PowerCenter.
Experience with Python programming for scripting, automation, testing, or data processing support.
Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience.
Bonus Experience
Experience working in other MDM tools including cloud-native MDM solutions.
Experience developing software or workflows in Python or other open-source tools.
Experience working in State government, public sector, or regulated environments.
Experience with Agile/Scrum sprint development and iterative/incremental delivery.
Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data.
Exposure to interoperability formats such as X12, EDI, XML, JSON, APIs, or HL7/FHIR.
Exposure to cloud data platforms or modernization initiatives such as Azure, ADF, Databricks, Snowflake, Data Lake, or comparable technologies.
Experience with on-prem-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 operate in a telecommute environment and matrix organization with minimal direction.
Come Build With Us
At CSpring, we unlock the potential of people and data. If you're ready to lead meaningful projects, collaborate with passionate teams, and grow your career in a people-first consulting environment-apply today!
