Microsoft Fabric ​/ SSIS Modernization Consultant (5+ years) to modernize legacy ETL workloads using Microsoft Fabric

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, One Lake, and notebooks. The consultant will work alongside a team of Fabric specialists delivering prioritized modernization workloads in a hands‑on technical environment.

• 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
  , One Lake
  , and notebooks
• ETL/ELT architecture
  , enterprise data integration
  , dependency management
  , and error handling
• At least one significant ETL modernization or migration project

• Microsoft Fabric and/or Azure Data Platform migration experience
• Python/Py Spark
• Delta Lake and Lakehouse architecture

• 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, One Lake, 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, One Lake, and notebooks. The consultant will work alongside a team of Fabric specialists delivering prioritized modernization workloads in a hands‑on technical environment.

• 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
  , One Lake
  , and notebooks
• ETL/ELT architecture
  , enterprise data integration
  , dependency management
  , and error handling
• At least one significant ETL modernization or migration project

• Microsoft Fabric and/or Azure Data Platform migration experience
• Azure Data Factory
• Python/Py Spark
• Delta Lake and Lakehouse architecture
• Git / Azure Dev Ops

• 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, One Lake, 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.