Sourabh Kumawat
Data Engineer @Wipro
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @Wipro
Pune, IN
Data Engineering & Cloud Data Platform WorkMigrated 12+ tables from Azure Synapse to ADLS & Hive Metastore, improving scalability and query performance by 30%.Designed and implemented Star Schema and Data Foundation models, enabling efficient analytical reporting.Built, enhanced, and optimized ADF pipelines and Databricks notebooks (PySpark & SQL) for incremental, monthly, and 67+ months of historical data loads, including advanced transformations and Delta Lake ETL.Developed stage, dimension, and fact tables, adding 14 new attributes across Account Engagement modules, helper tables, and aggregate views.Added and backfilled 6+ new attributes (e.g, AGE_BUCKET, ADULT_FL, GENRTNL_BAND) with historical data from 2019–2025, ensuring accurate longitudinal reporting.Implemented automated daily pipelines for Data Foundation tables (dim_date, analytics_calendar) at 00:00 UTC for timely refresh.Applied SCD Type 2 logic for tracking historical changes and performed data cleaning, normalization, and aggregation using PySpark Delta ETL scripts.Resolved data type mismatches, re-ran failed jobs, fixed duplicates, and validated data quality via row counts, consistency checks, and business rule validation.Conducted root-cause analysis on Tableau dashboards fed by cloud-source tables, identifying future-dated account values and collaborating with upstream teams to correct source data.Migrated final datasets to Azure Synapse and ADLS, maintaining consistency across downstream systems.Documentation & CommunicationCreated mapping documents, data dictionaries, and comparison sheets for ADLS, Synapse, and Hive to ensure audit-ready, production-ready documentation.Collaborated cross-functionally with business and engineering teams to document schema, pipeline, and scheduling changes, supporting seamless production releases.
EDUCATION
Prince academy sikar
11-12th, Mathematics
Sophia Public Senior Secondary School ,Bawa (Kankroli) Rajsamnd Rajasthan
Nursery - 10 Th
SKIT Jaipur
Bachelor of Technology - BTech, electrical engineering
ABOUT SOURABH KUMAWAT
Currently contributing as a Data Engineer at Wipro, specializing in data engineering and cloud data platforms. Key responsibilities include migrating tables from Azure Synapse to ADLS, developing efficient ETL pipelines, and implementing advanced transformations on large datasets using PySpark, SQL, and Azure Databricks. Recent achievements include significantly improving query performance and scalability while optimizing data pipelines for historical and incremental loads. A graduate of SKIT Jaipur with a Bachelor of Technology in Electrical Engineering, equipped with certifications in Microsoft Azure Fundamentals, Power BI, and SQL. Proficient in leveraging Azure Data Lake, PySpark, and Databricks to build and optimize robust cloud-based data solutions that streamline analytics and support business intelligence, ensuring accurate and actionable insights.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.