Hi! I am Gagan

I am a Data Engineer with 3 years of experience designing ETL pipelines, managing scalable workflows, and driving data-driven decisions at Wonderbrands.

Gagan Shergill
About Gagan

About Me

A few interesting things about me. I love to do outdoor activities like rock-climbing and soccer. I am also a data engineer, experienced in building and maintaining data pipelines, designing ETL/ELT workflows, implementing distributed data processing with Spark, and ensuring data quality and scalability.

Lastly, I love learning. Every day I push myself to learn something new, whether that is about intricacies of data pipelines, or miscellaneous facts about the world around me.

Do you want to work together? Please reach out to me by email.

Skills

Data Engineering & Programming

Python, PySpark, SQL, Azure Data Factory, ETL/ELT pipelines, VBA

Data Modeling & Analytics

Star/Snowflake schema, DBT, Power Query (M), SSAS, Data pre-processing

Cloud & Storage

Azure Data Lake, Delta Lake, Delta Live Tables, S3, Azure Synapse Analytics

Business Intelligence & Visualization

Power BI, Tableau, Matplotlib, Seaborn, Advanced DAX, Reporting & Dashboards

Tools & Orchestration

Airflow, Git, Power Automate, Power Apps, Jupyter Notebook, Databricks

Web Development

Django, Flask, HTML/CSS, JavaScript, ReactJS

Projects

A sample of my personal and academic projects

Real-Time Stream Processing

Real-Time Stream Processing

Automated Data Pipeline

Automated Data Pipeline

Exploratory Analysis of Geolocation Data

Exploratory Analysis of Geolocation Data

House Price Prediction

House Price Prediction

Face Recognition Attendance System

Face recognition based Attendance System

Social Bubble Website

Social Bubble Website

Power BI Reports

Power BI Reports

Get In Touch

Leave me a message

Toronto, Ontario, Canada