Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Sourav Lohia

New Delhi

Summary

Dynamic data engineering professional with a proven track record at Genpact, leading teams to optimize data processes and enhance decision-making. Expert in Azure and PySpark, achieving a 60% reduction in processing time. Strong analytical problem-solving skills drive impactful results in fast-paced environments. Passionate about leveraging data for strategic insights.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Lead Consultant - Data & AI

Genpact
Delhi
03.2025 - Current
  • Led a team of seven developers to migrate from Greenplum and Talend to Databricks for GE Vernova.
  • Achieved recognition for timely completion of project deliverables.
  • Migrated 200 SOTs to the Gold layer, and ingested data from over 10 sources.
  • Reduced processing time by more than 10 hours per day, increasing overall efficiency.

Data Engineer Assistant Manager

Bira91
New Delhi
12.2024 - 03.2025
  • Directing Data Engineering and Data Architecture at Bira 91, extracting insights to facilitate data-driven decision-making.

Data Engineer (Assistant Manager)

Mankind Pharma
New Delhi
01.2024 - 09.2024
  • Developed analytics products enhancing business decision-making processes by integrating structured and unstructured data into insightful dashboards and reports.
  • Designed WhatsApp-based nudges for 20,000+ field force members, driving behavior change and improving operational metrics.
  • Optimized legacy SQL queries developed by multiple vendors, resulting in significant improvements in performance and maintainability.
  • Achieved a 60% reduction in processing time by transitioning a traditional SQL data warehouse to a scalable Azure Databricks architecture using PySpark and ADLS.
  • Implemented OCR-based automation for contract and agreement digitization, improving turnaround time and data accessibility for downstream systems.
  • Directed workflow for a 10+ member team, facilitating task prioritization, performance optimization, and timely delivery.

Data Engineering Analyst

Accenture Technology Centres India-Cloud first/Data & Al
Gurugram
04.2021 - 01.2024
  • Multi-Module Data Engineering at Unilever Markets:
  • Worked on various modules, including Finance, Media, and DSR, designing and implementing end-to-end data pipelines—from ingesting large volumes of data to generating insightful frontend reports on Power BI.
  • Leveraged Azure Cloud services, ADLS, ADF, and Azure Databricks (ADB) to build scalable, high-performance solutions.
  • Developed robust data transformations using a blend of SQL and Scala on ADB, ensuring data quality and precise time calculations from diverse market sources.
  • Created logic for multiple KPIs to enhance market efficiency, directly contributing to financial decision-making that saved millions.
  • Successfully led migration projects, including transitioning from SQL Data Warehouse to Azure Databricks and ADLS Gen1 to Gen2.

Education

B.Tech - Engineering Physics Major Electronics

Delhi Technological University
07.2020

XII -

Kendriya Vidyalaya Arjangarh Delhi
07.2016

X -

Kendriya Vidyalaya Arrjangarh Delhi
05.2014

Skills

  • Cloud computing expertise ( Azure)
  • Data processing frameworks (Spark, PySpark)
  • Database management (SQL, BigQuery, Snowflake)
  • Machine learning techniques
  • Statistical analysis skills
  • Data visualization (Power BI)
  • ETL pipeline development
  • Data quality assurance
  • Programming proficiency (Python)
  • Data engineering methodologies
  • Analytical problem solving
  • Leadership in team settings

Certification

  • Azure AZ-900
  • DP-900
  • Databricks Data Engineer Associate certification, DE professional and Gen AI associate

Accomplishments

  • Employee of the month for the month of April 2024 at Mankind Pharma.
  • Awarded star performer for timely delivery at Genpact.

Timeline

Lead Consultant - Data & AI

Genpact
03.2025 - Current

Data Engineer Assistant Manager

Bira91
12.2024 - 03.2025

Data Engineer (Assistant Manager)

Mankind Pharma
01.2024 - 09.2024

Data Engineering Analyst

Accenture Technology Centres India-Cloud first/Data & Al
04.2021 - 01.2024

B.Tech - Engineering Physics Major Electronics

Delhi Technological University

XII -

Kendriya Vidyalaya Arjangarh Delhi

X -

Kendriya Vidyalaya Arrjangarh Delhi

Similar Profiles

CREATE PROFILE
Sourav Lohia