Remote MDM ETL Lead (Informatica) – Data Quality & Governance

eSense Incorporated

United States

On-site

USD 130,000 - 180,000

Full time

11 days ago

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

eSense Incorporated seeks an experienced MDM ETL Expert / Technical Lead to provide hands-on delivery and technical leadership for Master Data Management services supporting a Health and Human Services Innovation Incubator project. Focus areas include Informatica MDM, PowerCenter, data integration, data quality, and governance to create a unified cross-agency client view.

The role leads MDM technical delivery, guides ETL specialists, supports workflows, optimizes SQL/Python automation,

Qualifications

8+ years of experience in MDM, ETL, data integration, enterprise data platforms.
5+ years hands-on 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 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.

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 the CISO guidelines.
Provide leadership and coordinate or lead work for Informatica Master Data Management and related MDM ETL delivery activities.
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.
Provide project direction and assign work to MDM ETL Specialists.
Ability to provide expertise and guidance with MDM and the Informatica MDM tool.
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.
Working with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
Scheduling and monitoring ETL/Informatica jobs in development, system testing, and production environment.
Developing proactive processes for monitoring capacity and performance tuning.
Supporting and advising the development teams on technical issues.
Troubleshoot production support issues post‑release deployment and produce solutions.
Developing, maintaining, and analyzing complex SQL queries and scripts used to create data marts in Teradata.
Work directly with the Quality Assurance and business team to support validation, defect resolution, and testing of MDM-related data processes.
Participating in project discussions to document and recommend alternative technical solutions or requirements.
Participating in unit, integration, and system testing.
Maintaining effective communication and relationships with all individuals involved with the project.
Learning new technologies as needed to be able to perform job duties effectively.
Provide status updates and meet deliverables to Client’s leadership and the State Project Managers.