Associate Director, Data Engineering

Merck; Hyderabad; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Merck in Hyderabad, India is seeking a senior data engineering leader to drive enterprise data initiatives. You will architect and implement end-to-end data pipelines using IDMC, Databricks, and AWS, while aligning with enterprise standards and security requirements.

The role involves collaborating with architecture teams to deliver scalable, compliant solutions that power global healthcare analytics. You will mentor engineering squads, advance data governance, and explore innovative topics like

Qualifications

• Must have strong programming skills and advanced SQL with deep understanding of distributed systems.
• Expertise in IDMC architecture, including API management, performance tuning, and Secure Agent patterns.
• Proficiency in Databricks Lakehouse concepts, Unity Catalog, and Delta Lake optimization.
• Strong AWS Cloud Engineering skills including serverless design, IaC, S3, Lambda, IAM, Step Functions.
• Experience architecting data flows from Salesforce/Veeva CRM to data warehouses while preserving integrity.
• Lead enterprise data modeling including dimensional modeling and slowly changing dimensions.
• Solid understanding of data privacy, compliance standards, and SDLC validation.

Responsibilities

• Serve as senior technical leader for data engineering and co-create technical vision with Enterprise Architecture.
• Lead design and implementation of complex, end-to-end data pipelines using IDMC, Databricks, and AWS.
• Set platform strategy for Databricks Lakehouses and secure AWS infrastructures.
• Architect data replication and synchronization between Salesforce/Veeva CRM and analytics platforms.
• Own enterprise architecture for IDMC with secure agent patterns and hybrid cloud integration.
• Collaborate with principal architects, product owners, and business leads to deliver scalable solutions.
• Ensure data quality, security, and regulatory compliance across assets and SDLC.

Skills

Principal-Level Programming

Enterprise IDMC Architecture

Databricks Lakehouse Mastery

AWS Cloud Engineering

Salesforce & Commercial Analytics

Enterprise Data Modeling

Compliance & Validation Governance

Job description

Job Description

The Opportunity

Based in Hyderabad, join a global healthcare biopharma company and be part of a 130- year legacy of success backed by ethical integrity, forward momentum, and an inspiring mission to achieve new milestones in global healthcare.

Be part of an organisation driven by digital technology and data-backed approaches that support a diversified portfolio of prescription medicines, vaccines, and animal health products.

Drive innovation and execution excellence. Be a part of a team with passion for using data, analytics, and insights to drive decision-making, and which creates custom software, allowing us to tackle some of the world's greatest health threats.

Our Technology Centers

Our Technology Centers focus on creating a space where teams can come together to deliver business solutions that save and improve lives. An integral part of our company's IT operating model, Tech Centers are globally distributed locations where each IT division has employees to enable our digital transformation journey and drive business outcomes. These locations, in addition to the other sites, are essential to supporting our business and strategy.

A focused group of leaders in each Tech Center helps to ensure we can manage and improve each location, from investing in growth, success, and well-being of our people, to making sure colleagues from each IT division feel a sense of belonging to managing critical emergencies. And together, we must leverage the strength of our team to collaborate globally to optimize connections and share best practices across the Tech Centers.

What will you do in this role:

• Enterprise Technical Leadership: Serves as a senior technical leader and key advisor for data engineering, partnering with Enterprise Architecture to co-create technical vision, data blueprints, and engineering standards across the organization.
• Complex Pipeline Architecture: Leads the design and implementation of highly complex, end-to-end data pipeline architectures utilizing IDMC (Informatica Intelligent Data Management Cloud), Databricks, and AWS to support global commercial and manufacturing analytics.
• Enterprise Platform Strategy: Establishes best-practice architectures for Databricks Lakehouses (Unity Catalog, Delta Lake optimization) and highly secure AWS infrastructures.
• Salesforce & Veeva Ecosystem Mastery: Champions the architectural strategy for massive data replication, migration, and synchronization between Salesforce (e.g., Salesforce Life Sciences Cloud, Veeva CRM) and downstream analytical platforms.
• Data Integration & ETL Governance: Owns the enterprise architecture for IDMC, defining patterns for secure agents, high-throughput mappings, reusable taskflows, and hybrid cloud integration strategies.
• Cross-Functional Architecture Alignment: Collaborates intensively with principal architects, product owners, and commercial business leads to translate corporate objectives into robust, compliant, and scalable technical solutions.
• Compliance & Quality Standards: Holds ultimate accountability for the technical compliance, data quality, and security of delivered assets, ensuring strict adherence to SDLC software validation, privacy laws, and security protocols.
• Innovation & Advanced Technology R&D: Spearheads technical exploration, prototyping, and proof-of-concept initiatives for emerging trends such as real-time streaming, generative AI pipeline components, and automated data quality monitoring.
• Mentorship & Talent Cultivation: Mentors senior engineering talent and guides engineering squads, raising the collective technical capability and establishing a strong "community of practice."

Primary skills (must-have)

• Principal-Level Programming: Mastery of programing languages and advanced SQL; deep understanding of memory management, cluster configuration, and query tuning in distributed systems.
• Enterprise IDMC Architecture: Demonstrated expertise in designing large-scale integration solutions using Informatica Intelligent Data Management Cloud (IDMC), including API management, performance tuning, and Secure Agent architecture.
• Databricks Lakehouse Mastery: Advanced experience structuring enterprise Lakehouses, managing global schema permissions via Unity Catalog, and optimizing read/write speeds using Delta Lake configurations.
• AWS Cloud Engineering: Mastery in building serverless cloud architectures on AWS using Infrastructure as Code and orchestrating services like S3, Lambda, IAM, and Step Functions.
• Salesforce & Commercial Analytics Integration: Proven track record of architecting high-volume synchronization processes from Salesforce/Veeva CRM to central warehouses while preserving performance and data integrity.
• Enterprise Data Modeling: Industry-leading expertise in dimensional modeling, data lake design patterns, Slowly Changing Dimensions (SCD), and semantic layer architecture.
• Compliance & Validation Governance: Solid understanding of data privacy frameworks, commercial compliance standards, and SDLC validatio