IDMC ETL Engineer – Cloud Data Pipelines & Redshift

Cognizant Technology Solutions Corporation; Boston (MA); On-site; USD 100,000 - 135,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

Paid holidays plus PTO

401(k) plan and contributions

Long-term/Short-term Disability

Paid Parental Leave

Employee Stock Purchase Plan

Job summary

Cognizant Technology Solutions Corporation is seeking a Data Integration Engineer in Boston to design, develop, and maintain modern data pipelines on the IDMC platform. You will implement scalable data workflows, support production deployments, and collaborate with the Data Services team to ensure reliable data integration across environments.

The role requires hands-on IDMC expertise, strong SQL and Redshift familiarity, and a DevOps mindset for managing changes and deployments.

Qualifications

• 7+ years of experience in ETL development.
• 3+ years of experience in ETL development using Informatica PowerCenter or Informatica Data Management Cloud (IDMC).
• 2+ years of direct experience with AWS products, preferably Redshift.
• 2+ years of direct experience with DevOps tools and practices (e.g., Git, CI/CD, automated deployments).
• Experience with RESTful services, JMS messaging, or other integration patterns (SOA, EDA).
• Experience with regulated industries (e.g., SOX, audit readiness).

Responsibilities

• Implement complex, reusable IDMC integration pipelines using Mass Ingestion, Application Ingestion, Taskflows, and REST APIs.
• Develop high-quality ETL pipelines that source, transform, and deliver data into AWS Redshift and other targets.
• Write and manage reusable, version-controlled integration components aligned with standards.
• Perform root cause analysis on failed jobs and recommend remediation to improve resiliency.
• Profile data and conduct data exploration to support integration design decisions.
• Collaborate with Data Services team to ensure integrated data solutions and best practices.

Skills

ETL development

IDMC expertise

SQL

Redshift

DevOps

REST API

Data integration design

Troubleshooting

Education

Bachelor's degree in MIS/CS/Engineering

Tools

IDMC

PowerCenter

AWS Redshift

Git

CI/CD

Job description

Cognizant Technology Solutions Corporation is seeking a Data Integration Engineer in Boston to design, develop, and maintain modern data pipelines on the IDMC platform. You will implement scalable data workflows, support production deployments, and collaborate with the Data Services team to ensure reliable data integration across environments.

The role requires hands-on IDMC expertise, strong SQL and Redshift familiarity, and a DevOps mindset for managing changes and deployments.