Senior Informatica Engineer Lead

Volto Consulting; Quincy (MA); On-site; USD 150,000 - 190,000; Full time

Benefits offered by this job

Competitive Compensation

Long-Term Contract Opportunity

Enterprise Digital Transformation

Job summary

Volto Consulting is seeking an experienced Senior Informatica Engineer Lead to drive enterprise data integration initiatives using Informatica IDMC, MDM, and IDQ. The role emphasizes hands‑on ETL development, production support, and CI/CD deployments in a fast‑paced enterprise environment.

The ideal candidate will lead design, development, and optimization of IDMC pipelines, MDM workflows, IDQ rules, and SQL queries.

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.

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.

Skills

ETL development

Informatica development

Problem solving

Tools

Informatica IDMC

Informatica MDM

Informatica IDQ

Oracle

PostgreSQL

Redshift

Unix/Linux

Shell scripting

AutoSys

Git

Bitbucket

Jenkins

CI/CD

Job description

• AutoSys scheduling experience.
• PostgreSQL

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