CSpring
MDM ETL Expert
Springfield, IL
hirly Pro
Get in front of the people hiring at CSpring
- Reach the hiring manager at CSpring on LinkedIn, from your own account
- hirly applies to this job for you, with unlimited applications
- A resume and cover letter written for this job, unlimited
- The hiring manager and recruiter at CSpring, with contact details
$49 a month · ₹1,999 for 30 days in India · cancel any time
Get past the screening software and onto a recruiter's desk
hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.
- Keywords matched to this posting
- Fit score before you apply
- Cover letter included
Matched against 2.8M live jobs from 220,000+ employers in 200+ countries.
Tailor my resume for this job →Apply from your AI assistant
Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.
Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.
hirly's read of this role
- Seniority
- Mid level
- Country
- US
- Work mode
- Remote-friendly
- First seen by hirly
- 16 Oct 2026
Derived automatically from the posting. Upload your resume above to see how the role scores against it.
the posting
Description
At CSpring, we believe in the power of data to drive decisions and real-world impact. We’re a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results.
We're seeking talented professionals who are collaborative, curious, and committed to making a difference that thrive at the intersection of data, technology, and business strategy. Whether you're passionate about transforming public programs, enabling executive decision-making, or modernizing legacy systems, you'll find meaningful work and purpose here.
Why You’ll Love Working Here
- Purposeful Projects – Improve systems that serve real people by delivering smarter data, streamlined processes, and strategic insight.
- People-First Culture – We’re as committed to your growth as we are to delivering high-impact solutions. You’ll find support, autonomy, and community here.
- Strategic, Hands-On Work – From data architecture and documentation to client workshops and solution delivery, you’ll influence every step of the process.
- Collaborative Trust – Our clients rely on us to listen carefully, deliver consistently, and guide wisely. We partner with integrity, curiosity, and heart.
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.
- Strong experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs.
- Strong 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.
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!
Listed on hirly, a job board. hirly is not the employer: CSpring is hiring for this role.
Browse similar roles
Want this one?
Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.
Tailor my resume for this job