Specialist , Data Engineering

MSD; Pune District; On-site; INR 1,200,000 - 1,900,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

MSD is seeking a Specialist: Data Engineering to design and maintain robust data pipelines across hybrid teams. You will own end-to-end data integration, cleansing and validation, and work with Python, shell scripting and cloud-native tools to ensure scalable, reliable data delivery.

You will collaborate with data scientists and analysts, implementing CI/CD practices and scheduling with Autosys/Airflow while following Agile methods.

Qualifications

• Bachelor’s degree in information technology, Computer Science or tech field.
• 5+ years of experience with enterprise data integration technologies – Informatica PowerCenter & CDI/CAI/Mass Ingest.
• Experience with REST and Custom API integration.
• Experience with relational databases and cloud stores (AWS/GCP/Azure).
• Knowledge of AWS Well-Architected Framework, deployment and integration for data engineering.
• CI/CD experience with Terraform, GitHub Actions, Artifactory.
• Proficient in Python and shell scripting for data integration/workflows.
• Experience in reusable integration patterns using cloud-native tech.
• Experience with Autosys and Airflow for scheduling.
• Experience in Agile development and release management.
• Strong analytical and problem-solving skills; good data modeling understanding.

Responsibilities

• Design, build and maintain data pipelines and infrastructure.
• Own data integration and ingestion solutions through project lifecycles.
• Perform data cleansing, processing and validation for quality data.
• Define test strategies and plans for middleware testing and evidence.
• Collaborate with architecture and business analysts to prototype integration methods.
• Contribute hands-on coding, debugging and delivery of scalable data products.
• Coordinate across distributed teams to drive complex initiatives.
• Align data architecture with integration roadmaps across platforms.
• Design ETL/ELT solutions and outline standards/toolkits.
• Develop and maintain ETL workflows with robust error handling.
• Monitor ETL processes to ensure timely data delivery.
• Collaborate with data analysts to ensure alignment of data architecture.
• Document data mappings and ETL workflows for knowledge transfer.

Skills

IDMC experience

Informatica PowerCenter

Shell scripting

SQL/Database queries

Python

Cloud data stores

Autosys/Airflow

Education

Bachelor's degree in IT/CS

Tools

Informatica CDI / Mass Ingest

Terraform

GitHub Actions

Artifactory

Job description

Job Description

Specialist: Data Engineering

The Opportunity:

Join a global biopharma company with a 130-year legacy and mission to achieve new milestones in healthcare. Be part of a technology-driven, data-led organization supporting a diversified portfolio of medicines, vaccines, and animal health products. Work alongside passionate teams that use data, analytics, and insights to drive decisions and tackle some of the world’s greatest health threats.

Our Technology Centers are globally distributed hubs that enable our digital transformation and business outcomes across IT. They bring together diverse teams to collaborate, share best practices, and deliver solutions that save and improve lives.

This role is based at our Hyderabad Tech Center and follows a hybrid working model (3 days onsite, 2 days remote). Candidates are expected to reside within commuting distance of the Hyderabad office.

Role Overview:

A Data Engineer is responsible for designing, building, and maintaining robust data pipelines and infrastructure that facilitate the collection, storage, and processing of large datasets. They collaborate with data scientists and analysts to ensure data is accessible, reliable, and optimized for analysis. Key tasks include data integration, ETL (Extract, Transform, Load) processes, and managing databases and cloud-based systems. Data engineers play a crucial role in enabling data-driven decision-making and ensuring data quality across organizations.

What will you do in this role

• Develop comprehensive High-Level Technical Design and Data Mapping documents to meet specific business integration requirements.

• Own the data integration and ingestion solutions throughout the project lifecycle, delivering key artifacts such as data flow diagrams and source system inventories.

• Provide end-to-end delivery ownership for assigned data pipelines, performing cleansing, processing, and validation on the data to ensure its quality.

• Define and implement robust Test Strategies and Test Plans, ensuring end-to-end accountability for middleware testing and evidence management.

• Collaborate with the Solutions Architecture and Business analyst teams to analyze system requirements and prototype innovative integration methods.

• Exhibit a hands‑on leadership approach, ready to engage in coding, debugging, and all necessary actions to ensure the delivery of high‑quality, scalable products.

• Influence and drive cross-product teams and collaboration while coordinating the execution of complex, technology-driven initiatives within distributed and remote teams.

• Work closely with various platforms and competencies to enrich the purpose of Enterprise Integration and guide their roadmaps to address current and emerging data integration and ingestion capabilities.

• Design ETL/ELT solutions, lead comprehensive system and integration testing, and outline standards and architectural toolkits to underpin our data integration efforts.

• Analyze data requirements and translate them into technical specifications for ETL processes.

• Develop and maintain ETL workflows, ensuring optimal performance and error handling mechanisms are in place.

• Monitor and troubleshoot ETL processes to ensure timely and successful data delivery.

• Collaborate with data analysts and other stakeholders to ensure alignment between data architecture and integration strategies.

• Document integration processes, data mappings, and ETL workflows to maintain clear communication and ensure knowledge transfer.

What Should you have:

• Bachelor’s degree in information technology, Computer Science or any Technology stream

• 5+ years of working experience with enterprise data integration technologies – Informatica PowerCenter, Informatica Intelligent Data Management Cloud Services (CDI, CAI, Mass Ingest, Orchestration)

• Integration experience utilizing REST and Custom API integration

• Experiences in Relational Database technologies and Cloud Data stores from AWS, GCP & Azure

• Experience utilizing AWS cloud well architecture framework, deployment & integration and data engineering.

• Preferred experience with CI/CD processes and related tools including- Terraform, GitHub Actions, Artifactory etc.

• Proven expertise in Python and Shell scripting, with a strong focus on leveraging these languages for data integration and orchestration to optimize workflows and enhance data processing efficiency

• Extensive Experience in design of reusable integration patterns using the cloud native technologies

• Extensive Experience Process orchestration and Scheduling Integration Jobs in Autosys, Airflow.

• Experience in Agile development methodologies and release management techniques

• Excellent analytical and problem-solving skills

• Good Understanding of data modeling and data architecture principles

Primary Skills:

• IDMC experience for 2-3 years

• Informatica Power Center - 3 Years

• Shell Scripting experience

• SQL/Database query knowledge

Secondary Skills:

CI/CD processes, Terraform, GitHub Actions, Artifactory etc.

Who we are

We are known as well‑known org Inc., Rahway, New Jersey, USA in the United States and Canada and MSD everywhere else. For more than a century, bringing forward medicines and vaccines for many of the world’s most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.

What we look for

Imagine getting up in the morning for a job as important as helping to save and improve lives around the world. Here, you have that opportunity. You can put your empathy, creativity, digital mastery, or scientific genius to work in collaboration with a diverse group of colleagues who pursue and bring hope to countless people who are battling some of the most challenging diseases of our time. Our team is constantly evolving, so if you are among the intellectually curious, join us—and start making your impact today.

Required Skills:

Database Queries, Data Integration, Data Integration Technologies, Enterprise Data Integration, ETL (Informatica), Informatica Cloud, Informatica Master Data Management, Informatica PowerCenter, Shell Scripting, SQL Script

Preferred Skills:

CI/CD, GitHub Actions, Terraform (Software)

Secondary Language(s) Job Description:

#MSDHYDIT

Employee Status:

Regular

Relocation:

Domestic

VISA Sponsorship:

No

Travel Requirements:

No Travel Required

Flexible Work Arrangements:

Hybrid

Shift:

Not Indicated

Valid Driving License:

No

Hazardous Material(s):

n/a

Job Posting End Date:

08/21/2026

*A job posting is effective until 11:59:59PM on the day BEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.