Senior Informatica Engineer Lead (IDMC, MDM, Data Quality)
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).
Recommended Jobs
Crew Scheduler
Job Description Job Description SUMMARY: This position organizes schedules for pilots, ensuring that they are utilized efficiently and comply with FAA Regulations and the Pilot Contract. Addit…
Home Health Physical Therapist Assistant (PTA)
Physical Therapist Assistant (PTA) - Home Health Lexington, MA Please apply if you are within 25miles General Purpose: Physical therapist assistants provide services for treating impair…
PEST MANAGEMENT PROFESSIONAL- PART TIME
Job Description Job Description ELITE PEST SOLUTIONS is looking to hire full-time AND part-time Apprentices to learn and provide uncompromised service to our customers (including food processing …
Car Wash Team Member
Start Your New Career Today — Prestige Car Wash Is Hiring! Looking for a great opportunity to start immediately? Prestige Car Wash is urgently hiring Car Wash Attendants across Massachusetts!…
Production Scheduler
Production Scheduler SonoSystems, a Schunk Group Company Location: Wilmington, MA | Salary: $70-80k Where Precision Meets Performance Are you a detail-driven operations profession…
Senior Finance Specialist | Philippines
Job Description Job Description Description: We are looking to bring on a Senior Finance Specialist to transition key finance operations in-house, particularly to improve accuracy, visibilit…
Senior Executive Assistant
Overview With over 50 years of proven success, ECG, ranked as a Best Midsized Firm to Work For 2025 by Consulting Magazine , is the most experienced healthcare consulting firm in the US. Worki…
Recovery Aide
Job Description Job Description OVERVIEW: Gosnold, Inc. is a nationally accredited non-profit leader in the prevention, treatment and recovery of mental health and substance use disorders. We of…
Account Executive
Job Description Job Description Description: PromptCare seeks a results-driven sales professional with respiratory therapy and/or homecare/DME background experience to join our Sales Team as an …
Equipment Associate - ROS
Great company. Great people. Great opportunities. If you’d like the chance to make your mark with the world’s largest equipment rental provider, come build your future with United Rentals! …