Develop, schedule, monitor, and troubleshoot MDM and ETL processes using Informatica MDM. Create mappings, workflows, and scripts; build and tune SQL for Teradata data marts; support production issues, testing, and data governance. Collaborate with QA and stakeholders to validate, optimize, and document MDM solutions.
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
Working 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 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!
Similar Jobs
Cloud • Information Technology • Security • Software • Cybersecurity
Lead Cloudflare’s AI-first Revenue Operations technology roadmap. Assess workflows, systems, integrations, and user needs; design and prototype scalable automation and AI solutions; guide build, buy, blend, and retirement decisions; establish governance, security, privacy, and change controls; and partner with IT, Engineering, Procurement, Finance, vendors, and GTM stakeholders to deliver a secure, efficient seller technology ecosystem.
Top Skills:
Ai AgentsAPIsArtificial IntelligenceAutomationClariClayCloudflare OsCRMCustom GptsData IntegrationsForecasting SystemsGongHeadless ArchitectureHighspotLinkedin NavigatorMcpsOutreachRevenue OrchestrationSales Engagement PlatformsSalesforceZoominfo
.png)
Hardware • Other • Appliances
Directs manufacturing operations across production lines during a rotating shift, ensuring volume, quality, cost, safety, and delivery goals. Leads and coaches production teams, troubleshoots operational issues, prioritizes schedules, supports maintenance coordination, evaluates process improvements, advises project teams, manages expenses, and ensures compliance with manufacturing standards and procedures.
Top Skills:
Database SystemsPresentation SoftwareSpreadsheet SoftwareWord Processing Software
Financial Services
Leads data architecture strategy and execution for Commercial Card and B2B Commerce. Designs scalable Data Lake, Data Mesh, Data Federation, and Data Product solutions using Databricks, Spark, AWS Glue, APIs, streaming, and diverse databases. Establishes standards for modeling, metadata, lineage, quality, governance, security, and compliance. Drives modern SDLC, spec-driven development, and agentic engineering practices while providing technical leadership, architecture governance, stakeholder collaboration, and technology evaluation across multiple delivery teams.
Top Skills:
Agentic EngineeringAi/MlSparkAPIsAWSAws GlueCloud-Native DatabasesContinuous DeliveryData FederationData LakeData MeshDatabricksDistributed DatabasesEvent-Driven ArchitectureNoSQLRelational DatabasesSpec-Driven DevelopmentStreaming
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
