Summary
Overview
Work History
Education
Skills
Certification
COURSEWORK
Work Availability
Languages
Websites
Timeline
SHUBHAM MEHTA

SHUBHAM MEHTA

Lead Data Engineer
Toronto,ON

Summary

Dynamic Lead Data Engineer with 7 years of experience in developing and deploying scalable data pipelines for industrial analytics. Known for delivering impactful solutions through collaboration and results-driven approach. Recognized for expertise in data warehousing and ETL processes, along with adaptability to evolving project needs. Seeking to leverage strong experience in data engineering to drive innovation and efficiency in dynamic data environments through advanced SQL, SSIS and cloud-based solutions.

Overview

7
7
years of professional experience
3
3
Certifications
2
2
Languages
4
4
years of post-secondary education

Work History

Lead Data Engineer in an Analytics Project for a Major US Forklifts Manufacturer

Infosys Limited
10.2024 - 05.2025
  • Led the end-to-end development and deployment of scalable data pipelines for daily telemetry data, integrating Azure Data Factory, Snowflake, and Power BI to deliver reliable industrial equipment analytics and actionable insights, supporting over 100+ operational dashboards used by cross-functional teams.
  • Enhanced ETL workflows by embedding advanced SQL-driven data cleansing and transformation logic within Azure Data Factory pipelines, reducing data latency by 30% and increasing overall data accuracy and operational efficiency.
  • Managed ingestion and processing of millions of records daily from SAP systems and Azure Data Lake Storage (ADLS) using Azure Data Factory, ensuring consistent, error-free data flow and supporting real-time analytics use cases.
  • Collaborated closely with business stakeholders and data architects to gather detailed requirements, analyze complex source data, and design solutions that aligned with evolving business objectives, improving data accuracy and user satisfaction.
  • Monitored and prioritized incoming requests via ServiceNow, strategically allocating tasks to developers, swiftly resolving technical roadblocks, and fostering seamless communication between technical teams and business stakeholders to ensure on-time project delivery.
  • Provided technical leadership and mentorship to a team of 5+ data engineers, promoting best practices in pipeline architecture, code quality, and performance tuning, resulting in improved team productivity and reduced error rates.

Data Engineer in a Data Warehousing project for Canada's largest insurance organization

Infosys Limited
02.2024 - 09.2024
  • Developed and maintained 25+ custom SSRS reports and dashboards, automating reporting processes and reducing manual effort by 35%, accelerating business decision-making by 20%.
  • Designed and implemented complex business logic in SQL stored procedures and SSIS packages, transforming raw data into standardized EDW models supporting 10+ critical KPIs.
  • Led performance tuning initiatives on 100+ stored procedures and SSIS packages, improving ETL pipeline execution time by 45%.
  • Automated 40+ daily ETL and reporting jobs using Control-M, achieving a 99.7% job success rate and increasing operational reliability.
  • Collaborated closely with business stakeholders to gather requirements and deliver scalable BI solutions, boosting report adoption by 25%.
  • Mentored junior developers and managed cross-team communication to establish SQL/SSIS best practices and technical delivery.

Data Engineer in a Data Migration project for a Fortune 500 Truck Captive Arm

Infosys Limited
12.2020 - 01.2021
  • Led the end-to-end design and development of ETL pipelines using SSIS and T-SQL, migrating over 50 million records from flat files, Excel, XML, Mainframe, and SQL Server to the new system with 95%+ data accuracy.
  • Designed the data migration architecture with built-in validation and error-handling mechanisms, reducing manual QA efforts by 40% and improving long-term maintainability.
  • Managed and mentored a cross-functional team of 6 developers and QA engineers, overseeing code reviews, development workflows, and QA coordination to ensure high delivery quality.
  • Gathered and translated Auto Finance domain requirements into detailed mapping logic in collaboration with business stakeholders, improving alignment and reducing change requests.
  • Owned Agile processes using Azure DevOps, including sprint planning, backlog grooming, and daily stand-ups, ensuring consistent on-time delivery across 30+ sprints.

Developer in an Enterprise-scale Modernization Project for a Top-tier Electronic Component OEM

Infosys Limited
08.2019 - 11.2020


  • Architected and led the modernization of scalable ETL pipelines using SQL Server and SSIS, migrating over 5TB of legacy data to Azure Cloud, resulting in a 40% improvement in data processing performance and enhanced data accessibility.
  • Managed the development of 50+ SSIS packages and 100+ stored procedures, leading a team of 4 developers to deliver a cloud migration project 2 weeks ahead of schedule with 99.9% post-migration data accuracy.
  • Implemented CI/CD pipelines using Azure DevOps, reducing deployment time by 60% and decreasing post-release incidents by 35% across multiple enterprise-grade manufacturing applications within 12 months.
  • Modernized legacy on-premises applications by redesigning them into a 3-tier architecture using ASP.NET and Web API, improving scalability, maintainability, and deployment efficiency.

Developer on an Order Management System for a Leading American Logistics Services Provider

Infosys Limited
08.2018 - 07.2019
  • Developed and maintained a Rail Optimization (RO) application using ASP.NET and C#, following the Waterfall SDLC model, ensuring timely delivery of functionality aligned with business requirements.
  • Wrote and optimized SQL queries and scripts to perform root cause analysis, resolve production issues, and implement code/data fixes—improving incident resolution time by 30%.
  • Provided L2/L3 technical support to business users across finance and operations teams, maintaining high levels of customer satisfaction through proactive communication and efficient resolution.
  • Streamlined support processes by leveraging ServiceNow to monitor and triage incidents, identify recurring issues, and implement preventative solutions—leading to a 20% reduction in repeat tickets.
  • Collaborated cross-functionally with QA, business analysts, and client stakeholders to troubleshoot application behavior and deliver accurate solutions, building a strong foundation in client-facing communication.

Education

Bachelor of Engineering - Computer Science

Chitkara University, Punjab, India
08.2014 - 07.2018

Skills

Microsoft SQL Server

undefined

Certification

Data Integration using IICS Infosys Limited - 2025

COURSEWORK

  • Introduction to Data Warehouse, Infosys Limited - 2021
  • Introduction to Cyber Security in SDLC, Infosys Limited - 2021

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Punjabi
Advanced (C1)

Timeline

Lead Data Engineer in an Analytics Project for a Major US Forklifts Manufacturer - Infosys Limited
10.2024 - 05.2025
Data Engineer in a Data Warehousing project for Canada's largest insurance organization - Infosys Limited
02.2024 - 09.2024
Data Engineer in a Data Migration project for a Fortune 500 Truck Captive Arm - Infosys Limited
12.2020 - 01.2021
Developer in an Enterprise-scale Modernization Project for a Top-tier Electronic Component OEM - Infosys Limited
08.2019 - 11.2020
Developer on an Order Management System for a Leading American Logistics Services Provider - Infosys Limited
08.2018 - 07.2019
Chitkara University - Bachelor of Engineering, Computer Science
08.2014 - 07.2018

Similar Profiles

CREATE PROFILE
SHUBHAM MEHTALead Data Engineer