What You'll DoWorking under the guidance of the MDM Technical Lead, you'll provide hands-on technical development and delivery support for MDM services:
- Use the Informatica MDM tool to combine source data from agency sources, applying required transformations, applying corrections to the source files, and adding new fields via the change request process.
- Support MDM development and operational activities using working knowledge of Informatica MDM.
- Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency.
- Implement MDM jobs by creating mappings, mapplets, sessions, and workflows.
- Work with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
- Schedule and monitor ETL/Informatica jobs in development, system testing, and production environments.
- Troubleshoot post-release production support issues and develop solutions.
- Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata.
- Work directly with the QA team to support defect resolution, validation, and testing of MDM-related processes.
- Participate in project discussions to document and recommend alternative technical solutions or requirements, and in unit, integration, and system testing.
Requirements
What You Bring- 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development.
- 3+ years of hands-on Informatica MDM implementation experience.
- Experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs.
- SQL experience, with large MDM and DBMS enterprise relational platforms.
- Experience with data quality, matching, unique client/member identifier, standardization, reconciliation, and data governance concepts.
- Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery.
- 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. If your experience got you here another way, apply anyway.
Preferred Qualifications- Experience working in other MDM tools, including cloud-native MDM solutions.
- 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, or Data Lake.
- 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 UsAt 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! 
