Gourav Kumar Burnwal profile photo 1 on Tal

Gourav Kumar Burnwal

Redshift / Snowflake | Datawarehouse |Hive| Sqoop| Sql Server | Kafka | Airflow| Power BI/Azure/AWS

Greater Bengaluru Area

7+ years of work experience

BMO
Jun 20232 yrs 7 mosDec 2025

Bengaluru, Karnataka, India

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.
Atos
Apr 20221 yr 1 moApr 2023

Bangalore Urban, Karnataka, India

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.
BYJU'S (Think & Learn Pvt. Ltd.)
Jan 20202 yrs 3 mosMar 2022

Bengaluru, Karnataka, India

• 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.
BYJU'S (Think & Learn Pvt. Ltd.)
Jan 20202 yrs 3 mosMar 2022

Greater Bengaluru Area

• 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
Jul 20181 yr 4 mosOct 2019

Greater Bengaluru Area

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 .
Chromozome Network Private Limited (Chromozomes.com)
Mar 20184 mosJun 2018

Greater Bengaluru Area

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.

Gourav’s AI Stack

claude code
claude code
claude
claude
openai
openai
ChatGPT
ChatGPT
Guardrails AI
Guardrails AI
PydanticAI
PydanticAI

Education

Bachelor’s Degree, Computer Science

Asansol Enginnering College

20124 yrs2016
college

Bachelor’s Degree, Computer Science

college

20124 yrs2016

Join Gourav and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Gourav Kumar Burnwal on Tal

Headline

Redshift / Snowflake | Datawarehouse |Hive| Sqoop| Sql Server | Kafka | Airflow| Power BI/Azure/AWS

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.

Location

Greater Bengaluru Area

AI stack

claude code

claude

openai

ChatGPT

Guardrails AI

PydanticAI

Work experience

Data Engineer at BMO, Jun 2023 - Dec 2025 · 2 yrs 7 mos, Bengaluru, Karnataka, India, 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.

Associate Consultant(GCM Level 3) at Atos, Apr 2022 - Apr 2023 · 1 yr 1 mo, Bangalore Urban, Karnataka, India, 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.

Sales Operations Analyst at BYJU'S (Think & Learn Pvt. Ltd.), Jan 2020 - Mar 2022 · 2 yrs 3 mos, Bengaluru, Karnataka, India, • 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.

Web Data analytics at BYJU'S (Think & Learn Pvt. Ltd.), Jan 2020 - Mar 2022 · 2 yrs 3 mos, Greater Bengaluru Area, • 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

Social media marketing and SEO Analyst at siliconindia, Jul 2018 - Oct 2019 · 1 yr 4 mos, Greater Bengaluru Area, 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 .

SEO Analyst at Chromozome Network Private Limited (Chromozomes.com), Mar 2018 - Jun 2018 · 4 mos, Greater Bengaluru Area, 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.

Education

Bachelor’s Degree, Computer Science, Asansol Enginnering College

Bachelor’s Degree, Computer Science, college