I will design and build a data warehouse using ssis and azure sql

Enterprise-Ready Data Warehouse in Azure SSIS, Azure SQL, and ADF

Looking to build or modernize your data warehouse using SSIS and Azure SQL? I offer a complete ELT framework powered by SSIS for ingestion, Azure SQL for transformation, and ADF for orchestration built with scalability, maintainability, and business readiness in mind.

Whether you're integrating multiple data sources or applying complex transformation logic, Ill deliver a robust architecture with:

Key Features:

Staging Layer with Raw Ingestion (ELT)

• SSIS packages to pull data as-is into the staging layer
• Support for flat files, on-prem SQL, APIs, Oracle, Excel, and more

Transformation Layer with SQL Stored Procedures

• Apply business rules, cleansing, and modeling
• Modular, reusable SPs with controlled logic

Load Patterns Supported

• Full Load
• Delta/Incremental Load using Change Tracking or audit columns
• Slowly Changing Dimensions (SCD Type 1 & 2)
• UPSERT logic using MERGE statements

Logging & Audit Framework

• Package-level and row-level logging
• Logging tables for success/failure, execution time, row counts

Orchestration Using Azure Data Factory (ADF)

• ADF pipelines to trigger SSIS packages on schedule