Remote MDM ETL Lead | Informatica Expert

CSpring; Oregon; Hybrid; USD 140,000 - 190,000; Full time

Job summary

CSpring is seeking a Technical Lead for MDM and data integration. You will own design, delivery, and day-to-day operations for MDM solutions, including security by design and alignment with CISO guidelines.

You will coordinate MDM ETL activities, review documentation, and guide a team of specialists across Informatica MDM. Responsibilities include building mappings, sessions, and workflows; scheduling and monitoring ETL jobs; and collaborating with QA and business teams to ensure successful

Qualifications

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

Responsibilities

• 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 CISO guidelines.
• Provide leadership and coordinate or lead work for Informatica MDM and related MDM ETL delivery activities; assign work to MDM ETL Specialists.
• Use Informatica MDM tool to combine source data from agency sources, applying transformations, corrections and new fields via change requests.
• Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata; use Python as needed to enhance MDM and data integration.

Skills

MDM

ETL

Data integration

SQL

Python

Agile/Scrum

Education

Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent

Tools

Informatica MDM

Informatica PowerCenter

Teradata

Job description

CSpring is seeking a Technical Lead for MDM and data integration. You will own design, delivery, and day-to-day operations for MDM solutions, including security by design and alignment with CISO guidelines.

You will coordinate MDM ETL activities, review documentation, and guide a team of specialists across Informatica MDM. Responsibilities include building mappings, sessions, and workflows; scheduling and monitoring ETL jobs; and collaborating with QA and business teams to ensure successful