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 setting.

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 Microsoft Fabric and SSIS (Toronto)
🏢 S.i. Systems
📍 Toronto