HIMANSHU TRIPATHI
Mumbai
Summary
Results-driven Data Engineering & Analytics Leader with 10+ years of experience delivering enterprise-scale data platforms and cloud transformations across global banking and financial services. Recognized for hands-on technical leadership and strategic team-building, with proven expertise in Databricks and Azure. Adept at designing and scaling data lakes/warehouses, pipelines, while embedding strong governance, compliance, and CI/CD practices.
Professional data engineering leader with strong focus on delivering impactful results. Extensive experience in designing and implementing scalable data architectures, optimizing data pipelines, and leveraging big data technologies. Known for collaborative team leadership, adaptability, and results-driven approach. Skilled in SQL, Python, Spark, and cloud platforms, with keen ability to align technical solutions with business goals.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Lead Data Engineer
Marsh McLennan (Guy Carpenter - Global Analytics Advisory)
Mumbai
04.2022 - Current
- Led a squad of data engineers to design and deploy scalable, business-critical data solutions. Fostered collaboration, skill development, and agile delivery excellence.
- Managed data engineering platforms on Azure, ensuring reliability, scalability, and cost efficiency. Oversaw end-to-end pipeline architecture, integrating diverse sources and optimizing flows.
- Provided hands-on technical direction for large-scale pipelines using Azure Data Factory, Databricks, and PySpark. Defined best practices for data modeling, performance tuning, and CI/CD automation.
- Established and enforced data governance, quality, and security standards. Championed standardized frameworks and reusable assets to enhance consistency and compliance.
- Migrated assets and workflows to Unity Catalog for enhanced data governance and security.
- Led migration of data flows from shared to GAA-specific Azure Data Factory (ADF) resources, improving isolation and efficiency.
- Spearheaded NetApp to Blob Migration for DBMS applications, optimizing storage scalability, performance, and cost.
- Tech Stack: Azure Databricks, Spark, Scala, ADF, Delta Lake, MongoDB, SQL Server, NetApp, PostgresDB
Lead Data Engineer
Union Bank of Switzerland (UBS) – Capgemini Technologies
Mumbai
02.2021 - 04.2022
- Guided engineering team on Azure Databricks platform migration and Spark performance optimization, improving pipeline efficiency by 50%.
- Led design and delivery of scalable and governed reference data pipelines.
- Migrated legacy Spark 2.4 workloads to Spark 3.0, adopting Unity Catalog and Delta Lake.
- Defined CI/CD, observability, and data quality frameworks to ensure enterprise reliability.
- Tech Stack: Azure Databricks, Spark, Scala, ADF, Delta Lake, Cosmos DB
Data Engineer
U.S. Bank – Wipro Technologies
Mumbai
09.2020 - 02.2021
- Built automation scripts to migrate on-prem data to Google Cloud (GCP), streamlining cloud adoption.
- Reduced operational risks via orchestration with AutoSys.
- Tech Stack: GCP, Shell Scripting, Oracle
Senior Data Engineer
Royal Bank of Canada (RBC) – Tata Consultancy Services
Mumbai
06.2016 - 08.2020
- Designed Generic Data Processing Framework to standardize ETL and reduce redundant engineering.
- Delivered REST endpoints for framework extensibility.
- Collaborated with business and consulting teams to deliver production-grade analytics solutions.
- Tech Stack: Spark, Scala, Hive, HDFS, Java, Spring, Drools, JBPM
Data Engineer
RBC (Insurance Data Migration) – Tata Consultancy Services
Mumbai
06.2016 - 01.2019
- Developed pipelines for insurance data lake migration, enabling analytics and reporting.
- Optimized batch ETL/ELT processes, improving reporting efficiency.
- Tech Stack: Spark, Scala, Hive, HDFS, Jethro
Software Engineer
QAD India Pvt Ltd
01.2013 - 01.2015
- Earlier Roles
Software Engineer
Wipro Technologies
01.2011 - 01.2013
- Earlier Roles
Education
Bachelor of Engineering - Electronics & Telecommunication
Nagpur University
01.2010
Skills
- Enterprise Data Platforms: Data Lakes, Warehouses, Streaming, Data APIs
- Cloud Platforms: Databricks (Spark Optimization, Delta Lake, Unity Catalog), Azure (Blob Storage, ADLS Gen2, Delta Tables, Azure Data Factory, Azure Devops), AWS
- Engineering Excellence: Python, SQL, Scala, Spark, Data Modelling, ETL/ELT, Streaming
- Governance & Compliance: Data Security, Privacy (GDPR), Lineage, Metadata, Quality (Great Expectations)
- Leadership: Building & mentoring high-performing teams, Roadmap Ownership, Stakeholder Engagement, Vendor & Budget Management
Certification
- Databricks Certified Generative AI Engineer Associate
- Azure Data Engineer Associate certification (DP-203)
- AWS Certified Solutions Architect – Associate (2019 – 2022)
Timeline
Lead Data Engineer
Marsh McLennan (Guy Carpenter - Global Analytics Advisory)
04.2022 - Current
Lead Data Engineer
Union Bank of Switzerland (UBS) – Capgemini Technologies
02.2021 - 04.2022
Data Engineer
U.S. Bank – Wipro Technologies
09.2020 - 02.2021
Senior Data Engineer
Royal Bank of Canada (RBC) – Tata Consultancy Services
06.2016 - 08.2020
Data Engineer
RBC (Insurance Data Migration) – Tata Consultancy Services
06.2016 - 01.2019
Software Engineer
QAD India Pvt Ltd
01.2013 - 01.2015
Software Engineer
Wipro Technologies
01.2011 - 01.2013
Bachelor of Engineering - Electronics & Telecommunication
Nagpur University
AWARDS & RECOGNITION
- Technowledgement – Marsh McLennan (Nov 2023), Value Creator Award – Capgemini (2021)
- Best Team Award – Tata Consultancy Services (2018)
- Star Performer Award – Tata Consultancy Services (2018)