Sembra che questo servizio sia in sospeso

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

Alcune informazioni sono riportate in lingua inglese.
Mukesh Singh

India

Parlo Hindi, Inglese

Data Engineering and Analytics Expert

A technically astute and seasoned IT professional with over 10 years of experience specializing in Data Engineering, Analytics, and Reporting. Expertise in building and optimizing complex data solutio...
Continua a leggere
Informazioni su questo servizio

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
Continua a leggere
design and build a data warehouse using ssis and azure sql
Schermo intero
design and build a data warehouse using ssis and azure sql

Destination Platform:

Server Microsoft SQL

Strumenti e piattaforme:

Microsoft SSIS

•

Azure data factory

Il mio portfolio