I built an incremental ETL pipeline for a retail data warehouse using Databricks, Delta Lake, and AWS S3. It ingests retail data through Raw, Processed, and Warehouse layers, with pipeline logging and validation checks.
For the same project, I designed a star schema with customer, product, and store dimensions. I implemented SCD Type 2 customer history and published the warehouse as Parquet to S3.
I also built a retail sales warehouse in Snowflake using the TPC-DS store sales dataset. I implemented an SCD Type 2 customer dimension and developed Gold-layer sales tables with reconciliation checks.
During my internship at Military College of Electronics and Mechanical Engineering (MCEME), I contributed to a web application for registration, attendance, and leave management. I designed its PostgreSQL schema and built React interfaces, then extended the system with an order management module.
