Saurabh Mehrotra

Software Engineer

London, England, United Kingdom7 yrs 4 mos experience

Most Likely To Switch

Key Highlights

7+ years of experience in data engineering.
Expert in Azure Cloud data solutions.
Proven leadership in team management.

Stackforce AI infers this person is a Data Engineering expert in Healthcare and Enterprise Consulting sectors.

Contact

Skills

Core Skills

Azure Data FactoryData EngineeringData VisualizationDatabase ManagementData IntegrationData Reporting

Other Skills

Azure DatabricksETLData Pipeline DevelopmentAzure DevOpsDatabricksAzure Logic AppsSynapsePower BITableauOracle DatabaseAzure SynapseSQL Server Integration Services (SSIS)DAXSQL Server Reporting Services (SSRS)Information Management

About

Results-driven Data Engineer with 7+ years of expertise architecting and delivering enterprise-scale data solutions across Azure Cloud and on-premises environments. Microsoft Certified Azure Data Engineer with a proven track record of leading teams and transforming complex data challenges into actionable business intelligence. 🔹 Core Expertise: Azure Data Factory | Databricks | Snowflake | Azure Synapse | Delta Lake | Power BI | Tableau 🔹 Leadership: Currently leading a team of 6 engineers at Tech Mahindra, driving end-to-end data engineering solutions from architecture to deployment. 🔹 Impact: Designed robust ETL/ELT frameworks with comprehensive logging and alerting mechanisms. Successfully migrated legacy Oracle databases to Azure Synapse, optimizing costs and performance. 🔹 Industries: Healthcare (Bon Secours Mercy Health) | Insurance (Willis Towers Watson) | Enterprise Consulting Passionate about leveraging cutting-edge technologies to build scalable, reliable data pipelines that empower data-driven decision making. Open to connecting with fellow data professionals and exploring opportunities in innovative data engineering roles.

Experience

Tech mahindra

2 roles

Senior Data Engineer

Promoted

May 2025 – Present · 10 mos · On-site

🔹 Team Leadership & Coordination
Lead and mentor a team of Azure Data Engineers, providing technical guidance and performance feedback.
Allocate tasks, review deliverables, and ensure timely completion of project and support activities.
Conduct daily stand-ups, coordinate sprint planning, and manage work prioritization in line with SLAs.
Collaborate with project managers, architects, and business stakeholders to align deliverables with business goals.
🔹 Data Pipeline Development & Maintenance
Oversee the design, development, and deployment of data pipelines using Azure Data Factory (ADF) and Azure Databricks.
Monitor and optimize data ingestion, transformation, and loading (ETL) workflows.
Validate and troubleshoot pipeline failures, ensuring data accuracy and process reliability.
Manage version control, testing, and deployment of ADF and Databricks artifacts through CI/CD pipelines (Azure DevOps).
Monitor daily job executions through Control-M and address job delays or failures proactively.
Perform root cause analysis (RCA) for recurring issues and implement preventive measures.
Maintain incident, change, and problem management documentation according to ITIL standards.
Coordinate with cloud and infrastructure teams for environment maintenance and scaling.
🔹 Process Improvement & Optimization
Analyze existing data workflows to identify opportunities for automation and performance tuning.
Migrate legacy data pipelines from Azure Synapse to Databricks, improving scalability and efficiency.
Implement best practices for error handling, logging, monitoring, and alerting.
Document standards, reusable frameworks, and operational procedures for the data engineering team.
🔹 Stakeholder Communication & Reporting
Report daily/weekly production health and key metrics to management.
Collaborate with business users to understand data requirements and deliver actionable insights.
Communicate effectively across development, QA, and operations teams to ensure smooth releases.

Azure Data FactoryAzure DatabricksETLData Pipeline DevelopmentAzure DevOpsData Engineering

Data Engineer

Jun 2023 – May 2025 · 1 yr 11 mos · On-site

Roles and Responsibilities:
Leading and mentoring the team of 6 for developing data engineering solutions.
Creating ADF pipelines,preprocessing in Databricks and created automated workflows using Azure Logic Apps.
Regularly collaborate with stakeholders for requirement gathering,updating status of user stories.
Manage Databricks notebooks, Delta Lake with Python and Spark SQL for data extraction, transformation,and aggregation.

Azure Data FactoryDatabricksAzure Logic AppsData Engineering

Cognizant

Associate projects

Jul 2021 – May 2023 · 1 yr 10 mos · Gurugram, Haryana, India

Roles and Responsibilities :
Created ADF pipelines by applying various activities such copy, lookup, metadata, filter, stored procedure,notebook activities, mapping data flow.
Created and optimized various scripts in Synapse dedicated pool.
Built Objects, dimensions, and facts procedures in Synapse dedicated pool.
Implemented logging framework for ADF pipelines using stored procedures.
Interacted with Business Stakeholders for Requirement Gathering and other ad hoc activities.
Gained experience in all phases of Project Lifecycle Including Requirement gathering, Data transformation,Data Modelling, Data Visualization, Report deployment in Tableau and Power BI.
Developed various types of charts like Bars, Lines, Maps, Gantt charts, Bubbles, Histograms, Bullets, Heat,maps and Highlight tables.

Azure Data FactorySynapsePower BITableauData EngineeringData Visualization

Kpmg india

Associate Consultant

Feb 2021 – Jul 2021 · 5 mos · Gurugram, Haryana, India

Oracle DatabaseAzure SynapseDatabase Management

Capgemini

3 roles

Associate Consultant

Oct 2020 – Feb 2021 · 4 mos

1)Responsible for maintaining the SSIS Packages and performing enhancement to the existing SSIS Packages.
2)Adding Email Notification activities in SSIS Packages.
3)Hands on Experience in developing Dashboards using Power BI Desktop and Power BI service.
4)Created relationship between two different Data Sources by using Data Modelling and manage relationships in Power BI Desktop.
5)Proficient in creating Bookmarks, Hierarchies, Edit Interactions behavior in Power BI Desktop.
6)Knowledge on Star Schema & Snowflake Schema, Fact & Dimension Tables.
7)Experience in creating Filters, quick filters, table calculations and parameters.
8)Merge and Append Queries in Power BI.

SQL Server Integration Services (SSIS)Power BIData Integration

Senior Software Engineer

Promoted

Sep 2019 – Sep 2020 · 1 yr

Developed Projects in Power bi to automate the current manual workflow process to produce Marvin reports and introduce more reliability into it. The reports were developed in Power BI which contains various test release information.
 Developed reports and visualization using DAX functions.
 Integrated custom visuals based on business requirement using power BI desktop.
 Created Dax Queries to generate columns in Power BI.
 Publishing and deploying the Report in Power Bi Service.
 Perform Schedule Refresh.
 Row Level Security in Power BI

Power BIDAXData Visualization

Software Engineer

Aug 2018 – Aug 2019 · 1 yr

1)Worked on application development and existing application maintenance.
2)Worked with database objects such as creating Stored Procedures, Functions, Indexes, Cursors, Tables, Synonyms and Linked Server.
3)Worked on various components in SSIS like Execute SQL Task, Conditional Split, SCD (Slowly changing dimension).
4)Creating DFT (Data Flow Task) and Control flow task in SSIS. Applying exceptional handling at the Database level as well as SSIS Packages.
5)Developed reports using SSRS.

SQL Server Reporting Services (SSRS)SQL Server Integration Services (SSIS)Data Reporting