ETL Data Integration Engineer

Cognizant; 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 (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.). Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 1000, and the Fortune 500 and we are among the top performing and fastest growing companies in the world.

Job Description

Data Integration Engineer

• The Data Integration Engineer is a technical professional role responsible for designing, developing, and maintaining modern data pipelines on the Informatica Data Management Cloud (IDMC) platform. This role plays a critical part in enabling data ingestion, transformation, and integration in support of the company’s cloud-first data architecture and enterprise data warehouse.
• The engineer is accountable for implementing scalable and maintainable data workflows using IDMC's full suite of tools, including Mass Ingestion, Application Ingestion, Data Integration, and API Integration. The role supports both project-based and operational data movement requirements and ensures high-quality, well-documented, and reliable data flows across environments.
• Success in this role requires hands‑on IDMC expertise, strong SQL and Redshift familiarity, and a DevOps mindset for managing change and deployment across non-production and production environments. This role partners closely with the broader data services team and requires strong collaboration skills.

The essential responsibilities performed within this position include:

• Implement complex, reusable IDMC integration pipelines using modules such as Mass Ingestion, Application Ingestion, Taskflows, and REST APIs.
• Develop high quality and defect free ETL pipelines that source, transform, and deliver data into AWS Redshift and other targets.
• Write and manage reusable, version‑controlled integration components aligned with architectural and development standards.
• Perform root cause analysis on failed jobs and recommend long‑term remediation to improve resiliency.
• Act as an expert resource on the IDMC application, repositories, dependencies and scheduling mechanism within Andover’s solution architecture.
• Optimize and refactor mappings and workflows for performance, scalability, and operational efficiency.
• Create and maintain source‑to‑target mappings, low‑level technical specifications, integration documentation, and other relevant documentation as assigned.
• Support QA processes by contributing to test case design, data validation, and defect resolution.
• Provide production support including monitoring, issue resolution, job reruns, and incident tracking.
• Participate in code reviews, technical design discussions, and the establishment of integration best practices.
• Profile data and conduct data exploration to support integration design decisions.
• Evaluate and implement new IDMC releases, features, agents, and connectors in coordination with other members of the Data Services team.
• Participate in the evolution of integration best practices, reusable design patterns, and component standards.
• Support deployment pipelines and participate in data lifecycle management and change control processes, ensuring high quality and low risk deployments across all environment promotion processes.
• Collaborate with other members of the Data Services team to ensure integrated and reliable data solutions.
• Work proactively and independently to address project requirements and articulate appropriately issues and challenges to reduce project delivery risks.
• Other duties as assigned.

Expertise in IDMC Data Integration components including Mass Ingestion, Application Ingestion, Taskflows, and API‑based integration.

Expert understanding of cloud architecture.

Expertise in engineering, optimizing and troubleshooting ETL solutions at scale.

Advanced proficiency in translating business requirements into scalable technical solutions.

Strong problem‑solving and debugging skills for resolving data pipeline and performance issues.

Proficiency with Redshift and PostgreSQL, including hands‑on experience with DDL/DML, table creation, and stored procedures.

Proficiency with DevOps practices for data (e.g., version control, deployment pipelines).

Excellent verbal and written communication skills for interacting with both technical teams and business stakeholders.

Excellent time management.

Experience

• 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 working in the property & casualty insurance industry or other regulated industries with compliance requirements (e.g., SOX, audit readiness).

Education

• Bachelor's degree in management information systems, computer information systems, computer science, engineering, a related field, or equivalent work experience.

#LI-AV1#CB#Ind123

Jobs. Application Accepted: 11/05/2026

The annual salary for this position is between $100,000 - $135,000 depending on experience and other qualifications of the successful candidate.

Benefits

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long‑term/Short‑term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable language

Our strength is built on our ability to work together. Our diverse backgrounds offer different perspectives and new ways of thinking. It encourages lively discussions, creativity, productivity, and helps us build better solutions for our clients. We want someone who thrives in this setting and is inspired to craft meaningful solutions through true collaboration.

If you are content with ambiguity, excited by change, and excel through autonomy, we’d love to hear from you!