12 Oct
|
S.i. Systems
|
Toronto
12 Oct
S.i. Systems
Toronto
4 Months + Extension Downtown Toronto - King street West 2 Days Onsite 37.5 hrs/ week 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 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 , One
Lake , and notebooks ETL/ELT , 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 Dev
Ops 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, 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
📌 Microsoft Fabric / SSIS Modernization Consultant (5+ years) to modernize legacy ETL workloads using Microsoft Fabric and SSIS (Toronto)
🏢 S.i. Systems
📍 Toronto