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

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