Remote MDM & ETL Specialist — Data Champion

CSpring; Springfield (IL); Remote; USD 90,000 - 120,000; Full time

Job summary

CSpring is seeking a seasoned MDM/ETL data engineer to lead hands-on development and delivery for MDM services. You will use Informatica MDM to consolidate data from agency sources, implement mappings, and automate ETL workflows while collaborating with QA and project teams in a telecommute-friendly environment.

The role requires 5+ years in MDM/ETL/data integration, strong SQL and Python skills, and a Bachelor’s degree in CS/IS/Engineering.

Qualifications

• 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.

Responsibilities

• Provide hands-on technical development and delivery support for MDM services.
• Use the Informatica MDM tool to combine source data and apply transformations.
• Automate data staging by scheduling scripts to improve performance.
• Implement MDM jobs by creating mappings, mapplets, sessions, and workflows.
• Work with ETL transformations (Aggregator, Expression, Filter, Router, etc.).
• Schedule and monitor ETL/Informatica jobs across environments.
• Troubleshoot post-release production issues and develop solutions.
• Develop, maintain, and analyze complex SQL queries for data marts in Teradata.
• Collaborate with QA to support defect resolution and testing.
• Participate in project discussions to document and recommend technical solutions.

Skills

MDM ETL/ELT

Informatica MDM

SQL

Python scripting

SDLC delivery

Data quality governance

Education

Bachelor's degree (CS/IS/Engineering)

Tools

Informatica MDM

Teradata

Job description

CSpring is seeking a seasoned MDM/ETL data engineer to lead hands-on development and delivery for MDM services. You will use Informatica MDM to consolidate data from agency sources, implement mappings, and automate ETL workflows while collaborating with QA and project teams in a telecommute-friendly environment.

The role requires 5+ years in MDM/ETL/data integration, strong SQL and Python skills, and a Bachelor’s degree in CS/IS/Engineering.