Senior Informatica Engineer Lead (IDMC, MDM, Data Quality)
purple drive technologiesQuincy, MA
Senior Informatica Engineer Lead (IDMC, MDM, Data Quality)
purple drive technologiesQuincy, MA
APPLY NOW (opens in a new tab)13 days ago
About the role
Purple DriveSenior Informatica Engineer Lead (IDMC, MDM, Data Quality) Share Quincy, MA
Overview
Job Description
Role Summary:
Responsible for designing, developing, operating, and supporting enterprise data integration and master data solutions using Informatica IDMC, MDM, and IDQ.Owns ETL pipelines, job scheduling, CI/CD deployments, and BAU support.
Core Responsibilities:
- Informatica IDMC / ETL:Design, build, and support IDMC-based data integration pipelines, including mappings, taskflows, and synchronization jobs.
- Manage on-premises to cloud and cloud-to-cloud integrations using IDMC Secure Agent.
- Perform performance tuning, debugging, and operational troubleshooting of ETL workflows.
- Master Data Management (MDM):Hands-on development and support of Informatica MDM workflows, batch jobs, and hub processes.
- Execute data loads into MDM landing tables and manage batch group processing.
- Data Quality (IDQ):Implement and maintain Informatica Data Quality (IDQ) rules and validations.
- Ensure data completeness, consistency, and integrity across systems.
- Scheduling & Automation:
- Create and maintain Autosys JILs and templates for ETL and replication jobs.
- Monitor scheduled jobs and resolve failures proactively.
- SQL, Shell & CI/CD:Develop and optimize complex SQL queries across Oracle, PostgreSQL, and Redshift.
- Build Unix/Linux shell scripts for automation and operational support.
- Manage CI/CD pipelines using Git, Bitbucket, and Jenkins for UAT and PROD deployments.
Required Skills & Experience:
Advanced hands-on experience with Informatica IDMC.Strong proficiency in Informatica MDM and Informatica Data Quality (IDQ).Strong ETL fundamentals and data pipeline design expertise.
Solid SQL and Unix/Linux Shell scripting skills.
Experience with Autosys scheduling and CI/CD tools (Git, Bitbucket, Jenkins).
Matching similar jobs
JOB OVERVIEW
Experience level
Manager
Location
Quincy, MA
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
13 days ago
Tired of running searches?
Rank the roles you'd take once, and matches like these arrive on their own.
CREATE PROFILE (opens in a new tab)