Introduction: The client is a well-established global leader in the technical marketplace. It provides more than one hundred thousand (100,000) futuristic products.
Challenges: The ERD (Entity Relationship Diagram) model, which helps to understand the structure of the warehouse was missing and there was no proper data dictionary.
Solution: An ERD model was designed after studying the entire data sources and created optimized SSIS packages for the ETL processes, aiding the integration of new data into the warehouse.