ETL for Northwind Traders Database\

Developed an ETL (Extract, Transform, Load) project using SQL Server Integration Services (SSIS) to extract data from diverse sources (CSV, SQL) and load it into a staging area.

•

Implemented Slowly Changing Dimension (SCD) handling for historical data changes and utilized lookup transformations, derived column creation, and data conversion components for data enrichment and cleansing.