Olympics Data Warehouse & ETL Project

Designed and implemented an end-to-end ETL pipeline using Informatica PowerCenter and Oracle Database to process 271,116 historical Olympic records (1896–2016).

Built a Star Schema with 5 dimension tables and 1 fact table, applying data cleansing, standardization, and surrogate key generation.

Implemented ETL auditing, data quality checks, and recovery mechanisms to ensure reliable data loading and prevent duplicates.

Achieved a 100% successful load rate with zero rejected rows, delivering clean, structured data ready for business intelligence and analytical reporting.