Microsoft Fabric / SSIS Modernization Consultant (5+ years) to modernize legacy ETL workloads using Microsoft Fabric and SSIS
Join a modernization initiative focused on migrating legacy SSIS packages and enterprise data integration processes into Microsoft Fabric. This role supports the analysis, reverse engineering, and rebuild of ETL workflows using Microsoft Fabric Data Factory, Dataflows, Lakehouse, Warehouse, OneLake, and notebooks. The consultant will work alongside a team of Fabric specialists delivering prioritized modernization workloads in a hands‑on technical environment.

Must Haves

5+ years in data integration , ETL development , and modernization initiatives

3+ years with SSIS , SQL Server , and T‑SQL

Microsoft Fabric including Data Factory , Dataflows , Lakehouse , Warehouse , OneLake , and notebooks

ETL/ELT architecture , enterprise data integration , dependency management , and error handling

At least one significant ETL modernization or migration project

Nice to Have

Microsoft Fabric and/or Azure Data Platform migration experience

Python/PySpark

Delta Lake and Lakehouse architecture

Responsibilities

Analyze and reverse engineer SSIS packages, SQL transformations, stored procedures, schedules, and dependencies

Translate legacy ETL processes into Microsoft Fabric Data Factory pipelines, Dataflows, Lakehouse, Warehouse, OneLake, and notebooks

Develop and optimize data ingestion, transformation, orchestration, scheduling, and monitoring processes

Identify source‑to‑target mappings, operational dependencies, and undocumented business logic

Validate migrated workloads through testing, reconciliation, and defect resolution

Create technical documentation, implementation notes, data mappings, runbooks, and knowledge transfer materials

Participate in technical reviews, backlog refinement sessions, deployments, and handovers

3 Months + Extension

Downtown Toronto





2 Days Onsite

Join a modernization initiative focused on migrating legacy SSIS packages and enterprise data integration processes into Microsoft Fabric. This role supports the analysis, reverse engineering, and rebuild of ETL workflows using Microsoft Fabric Data Factory, Dataflows, Lakehouse, Warehouse, OneLake, and notebooks. The consultant will work alongside a team of Fabric specialists delivering prioritized modernization workloads in a hands‑on technical workplace.

Must Haves

5+ years in data integration , ETL development , and modernization initiatives

3+ years with SSIS , SQL Server , and T‑SQL

Microsoft Fabric including Data Factory , Dataflows , Lakehouse , Warehouse , OneLake , and notebooks

ETL/ELT architecture , enterprise data integration , dependency management , and error handling

At least one significant ETL modernization or migration project

Nice to Have

Microsoft Fabric and/or Azure Data Platform migration experience

Azure Data Factory

Python/PySpark

Delta Lake and Lakehouse architecture

Git / Azure DevOps

Responsibilities

Analyze and reverse engineer SSIS packages, SQL transformations, stored procedures, schedules, and dependencies

Translate legacy ETL processes into Microsoft Fabric Data Factory pipelines, Dataflows, Lakehouse, Warehouse, OneLake, and notebooks

Develop and optimize data ingestion, transformation, orchestration, scheduling, and monitoring processes

Identify source‑to‑target mappings, operational dependencies, and undocumented business logic

Validate migrated workloads through testing, reconciliation, and defect resolution

Create technical documentation, implementation notes, data mappings, runbooks, and knowledge transfer materials

Participate in technical reviews, backlog refinement sessions, deployments, and handovers

Disclaimer:

AI may be used in evaluating candidates.

This posting is for an existing vacancy.

#J-18808-Ljbffr

📌 Microsoft Fabric / SSIS Modernization Consultant (5+ years) to modernize legacy ETL workloads using (Ontario)
🏢 S.i. Systems
📍 Ontario