Gourav Kumar Burnwal

Operations Associate

Bengaluru, Karnataka, India7 yrs 5 mos experience

Most Likely To SwitchAI ML Practitioner

Key Highlights

5+ years of experience in data engineering.
Expert in building scalable ETL pipelines.
Proven track record in data accuracy and insights.

Stackforce AI infers this person is a Data Engineer specializing in Fintech and Healthcare data solutions.

Contact

gourav.burnwal@genpact.com LinkedIn

Skills

Core Skills

Data EngineeringEtl DevelopmentData VisualizationBusiness IntelligenceDigital MarketingData Analysis

Other Skills

ADLS Gen2AWS GlueAWS LambdaAmazon RedshiftAmazon Relational Database Service (RDS)Amazon S3Apache KafkaApache SqoopAzure Data FactoryAzure Data LakeAzure DatabricksAzure SQL DBBusiness RequirementsCassandraCustomer Relationship Management (CRM)

About

Data Engineer with 5+ years of experience designing and delivering scalable, high-performance data solutions across AWS, Azure, and Big Data ecosystems. Proven track record in building end-to-end ETL pipelines using PySpark, Azure Databricks, AWS Glue, and Hive for large-scale datasets in domains like credit risk, healthcare, sales analytics, and digital marketing. Skilled in implementing Medallion architecture, SCD Type 2 data modeling, Delta Lake, and automated data orchestration with Azure Data Factory and AWS Lambda. Adept at optimizing Spark jobs, ensuring 99.9% data accuracy in migrations, and enabling actionable insights through interactive Power BI dashboards. Passionate about transforming raw data into reliable, business-driven intelligence while ensuring compliance and performance at scale.

Experience

7 yrs 5 mos

Total Experience

1 yr 10 mos

Average Tenure

3 yrs

Current Experience

Genpact

Assistant Manager

Jun 2023 – Present · 3 yrs · Bengaluru, Karnataka, India · Hybrid

Designed and optimized PySpark-based credit benchmarking pipelines to process large-scale credit risk data from Amazon S3 and Hadoop.
Migrated legacy SAS models to PySpark, reducing runtime by 40% and cutting licensing costs.
Implemented robust data quality and validation checks, ensuring 99.9% accuracy in outputs.
Delivered processed data to Hive external tables for seamless integration with Power BI.
Leveraged tools including Amazon S3, Hadoop, PySpark, Hive, Power BI, SQL, Amazon Redshift, AWS Lambda, and AWS Glue.

PySparkAmazon S3HadoopData QualityPower BISQL+5

Atos

Associate Consultant(GCM Level 3)

Apr 2022 – Apr 2023 · 1 yr · Bangalore Urban, Karnataka, India · Remote

Developed and optimized PySpark-based ETL pipelines on Azure Databricks to process large datasets from Azure SQL DB and flat files into ADLS Gen2 following the Medallion architecture (bronze, silver, gold).
Built Delta Lake tables with SCD Type 2 logic to maintain patient, provider, and transaction history across multiple hospitals using a common data model.
Automated and orchestrated full and incremental data loads via Azure Data Factory, implementing watermarking and audit logs to ensure data freshness.
Implemented parameterized pipelines and reusable configurations to handle schema differences and ensure schema consistency across hospitals.
Connected Power BI to the gold layer in ADLS Gen2 and created interactive dashboards for business stakeholders.

PySparkAzure DatabricksAzure SQL DBADLS Gen2Delta LakeAzure Data Factory+3

Byju's (think & learn pvt. ltd.)

2 roles

Sales Operations Analyst

Jan 2020 – Mar 2022 · 2 yrs 2 mos

Developed interactive Power BI dashboards for sales and finance teams to visualize key performance indicators (KPIs).
Designed star schema data models by integrating dimension and fact tables from SQL Server.
Optimized report performance using DAX measures, calculated columns, and techniques like summary tables and query folding.
Utilized Power Query for data shaping and transformation before loading data into models.
Published and managed reports in the Power BI Service with scheduled refresh via on-premises data gateway.
Collaborated closely with business analysts to gather requirements and deliver insightful, data-driven reports for strategic decision-making.

Power BISQL ServerDAXPower QueryData VisualizationBusiness Intelligence

Web Data analytics

Jan 2020 – Mar 2022 · 2 yrs 2 mos

Forecasted the online user behavior, conversion data, user journey, funnel analysis.
Report on 10+ key metrics provide actionable insights based on available web analytics and internal data.
Preparing detailed report and dashboard to provide 100 % better insights to the decision-makers and majority stakeholders of the organization

Siliconindia

Social media marketing and SEO Analyst

Jul 2018 – Oct 2019 · 1 yr 3 mos · Bengaluru Area, India

Part of the team responsible for extracting data for 2+ websites banking and finance domain and analyze different metrices and designed the reports for clients.
Devised the most powerful keywords to drive the valuable monthly traffic.
Collecting and analyzing 100% genuine web traffic using different sources like Facebook, Quora, Medium, Twitter, Linkedin, Reddit.
Analyzing 50+ powerful Keywords ,SEO techniques and more than 45 backlinks used by competitors to increase the page view and monthly traffic.
Partnering and collaborate with content writing team and researched the content to ensure it to be 100% unique.
Prepared detail strategy reports regarding the SEO metrices and deliver it to key stakeholders
.

SEOWeb AnalyticsKeyword AnalysisDigital MarketingData Analysis

Chromozome network private limited (chromozomes.com)

SEO Analyst

Mar 2018 – Jun 2018 · 3 mos · Bengaluru Area, India

worked as SEO Analyst and Social media marketing .
Lead generation for Chromozomes.
Responsible for On Page SEO and Off Page SEO for 2Clients.
Social media sharing, social media book markings, discussion forums, creating backlinks.
Optimizing websites, modifying websites according to SEO requirements.
blog commenting, blog posting, classified submission, article submission, social bookmarking, image sharing, audio sharing, business listing, event listing.
Use of Quora to promote content.

SEOSocial Media MarketingDigital Marketing