Data Engineering
Enterprise Data Warehouse
End-to-end data warehouse solution with ETL pipelines, star schema design, and PostgreSQL optimization.
#SQL#ETL#Python#PostgreSQL
Chinook Data Warehouse with ODI
University project transforming the Chinook database (11 tables) into a star schema data warehouse (reduced to 7 tables) using Oracle Data Integrator (ODI) to analyze music sales.
Key Technical Steps
- ETL Automation: Development of an automated ETL pipeline to extract, transform, and load data from 11 source tables to 7 tables in the DWH.
- Star Schema: Design of an optimized star schema (dimensions + facts) for fast and efficient business intelligence queries.
- Centralization: Setup of a centralized data warehouse enabling clear analyses on sales.
- Tool Mastery: Professional use of Oracle Data Integrator (ODI) for data modeling and complete project management.