MDM ETL Specialist, Developer

Job not on LinkedIn

🔥 0 minutes ago

🌽 Illinois – Remote

🌽 Illinois – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🖥 Software Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CSpring

WebsiteLinkedInAll Job Openings

51 - 200 employees

🤝 B2B

💼 Consulting

☁️ SaaS

B2B • Consulting • SaaS

CSpring is a consulting firm that specializes in unlocking the power and potential of data to achieve technology-enabled business goals. Founded in 1996, the company focuses on data-driven solutions that align with clients' business objectives, offering services such as data architecture, management, analytics, and reporting. With a team of full-time consultants, CSpring collaborates with both public and private sector clients to develop technology strategies, architect data solutions, build software, and create visualizations tailored to meet unique client needs. CSpring is also recognized as a certified Woman-owned Business Enterprise (WBE) and has been named a Best Place to Work in Indiana.

📋 Description

• Use Informatica MDM to combine agency source data, apply transformations and corrections, and add fields through the change request process • Support Informatica MDM development and operational activities • Automate data staging by scheduling scripts for optimal system performance • Create MDM mappings, mapplets, sessions, and workflows • Apply ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank, Source Qualifier, Lookup, and Sorter • Schedule and monitor ETL/Informatica jobs across development, system testing, and production environments • Troubleshoot post-release production support issues and develop solutions • Develop, maintain, and analyze complex SQL queries and scripts for Teradata data marts • Work with QA on defect resolution, validation, and testing of MDM processes • Document and recommend alternative technical solutions or requirements • Participate in unit, integration, and system testing

🎯 Requirements

• 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 Informatica ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting • SQL experience with large MDM and enterprise relational DBMS platforms • Knowledge of data quality, matching, unique client/member identifiers, 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 • Experience with other MDM tools, including cloud-native MDM solutions • Experience 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 X12, EDI, XML, JSON, APIs, or HL7/FHIR • Exposure to Azure, ADF, Databricks, Snowflake, or Data Lake platforms • Experience with on-prem-to-cloud migration, MDM modernization, or EDW/ETL modernization • Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering • Ability to operate in a telecommute environment and matrix organization with minimal direction

🏖️ Benefits

• Purposeful projects • People-first culture with support, autonomy, and community • Strategic, hands-on work • Collaborative client partnerships • Career growth opportunities