Senior Informatica Engineer Lead

Location: ONSITE- Quincy, MA **NEED candidates who are local and available to attend an in-person interview at the client location Job Summary We are seeking an experienced Senior Informatica Engineer Lead with expertise in Informatica IDMC, MDM, and IDQ to lead enterprise data integration initiatives. The ideal candidate will have strong ETL development experience, hands-on expertise in Master Data Management, Data Quality, CI/CD deployments, and production support. This role requires excellent problem-solving skills and the ability to work in a fast-paced enterprise environment.

Key Responsibilities

• Design, develop, and support Informatica IDMC ETL pipelines.
• Build mappings, taskflows, and synchronization jobs.
• Support Informatica MDM workflows and batch processing.
• Develop and maintain Informatica Data Quality (IDQ) rules.
• Create and maintain AutoSys JILs and job schedules.
• Develop complex SQL queries across Oracle, PostgreSQL, and Redshift.
• Build Unix/Linux shell scripts for automation.
• Manage Git, Bitbucket, and Jenkins CI/CD deployments.
• Troubleshoot production ETL issues and optimize performance.
• Support BAU activities and enterprise data integration solutions.

Required Qualifications

• 10+ years of Informatica development experience.
• Hands-on expertise with Informatica IDMC.
• Strong Informatica MDM experience.
• Strong Informatica Data Quality (IDQ) experience.
• Advanced SQL development skills.
• Experience with Oracle, PostgreSQL, and Amazon Redshift.
• Unix/Linux Shell scripting expertise.
• AutoSys scheduling experience.
• Experience with Git, Bitbucket, and Jenkins.

Preferred Qualifications

• Cloud Integration
• On-Prem to Cloud Migration
• Enterprise Data Warehousing
• Production Support
• ETL Performance Optimization

Technical Skills

• Informatica IDMC
• Informatica MDM
• Informatica IDQ
• ETL
• SQL
• Oracle
• PostgreSQL
• Redshift
• Unix/Linux
• Shell Scripting
• AutoSys
• Git
• Bitbucket
• Jenkins
• CI/CD

Benefits

• Competitive Compensation
• Long-Term Contract Opportunity
• Enterprise Digital Transformation Project
• Collaborative Team Environment
• Career Growth Opportunities