Build a data warehouse from scratch, including full load, daily incremental load, design schema, SCD Type 1 and 2.

End-to-end Snowflake data pipeline for cricket analytics using JSON data from AWS S3, automated ingestion, transformation, and modelling into a scalable star schema

Design and implement a full ELT data pipeline using Snowflake and S3, featuring star schema modelling, SCD Type 1 & 2 handling, and incremental load automation

Production-style SCD Type 1 data pipeline built with Snowflake and AWS S3, featuring automated ingestion via Snowpipe, change detection with Streams, and conditional orchestration using Tasks and stored procedures. Demonstrates warehouse-native ELT and dimensional modeling best practices.