Senior ETL Developer

2 days ago

Toronto, Ontario, Canada Teckhorizon Inc Full time

Overview
The Business Intelligence Specialist – Senior (ETL Developer) will support the Ministry of Children and Community Services (MCCSS) by reviewing, redesigning, and developing scalable data ingestion and reporting solutions. The role focuses on modernizing the existing reporting environment by migrating data from Oracle systems to Azure Data Lake and Databricks, supporting analytical and operational reporting needs across multiple ministry programs.

Key Responsibilities

  • Design, develop, and implement end-to-end ETL pipelines from Oracle sources to Azure Data Lake and Databricks.
  • Build and maintain ingestion frameworks for initial loads and incremental (CDC) loads using Azure Data Factory and Oracle GoldenGate.
  • Develop data transformations using Azure Databricks (PySpark, Python, SQL) to move data from raw to curated zones and into datamarts.
  • Review existing reporting models, identify gaps, inefficiencies, and recommend improvements.
  • Design physical data models and source-to-target mappings for reporting and analytics.
  • Reverse engineer and document existing SQL logic to support redesign efforts.
  • Develop and maintain dynamic ETL pipelines to onboard new tables and data elements.
  • Perform unit testing, performance tuning, data validation, and consistency checks.
  • Troubleshoot ETL, performance, and data quality issues across environments.
  • Prepare design artifacts including low-level design documents, test cases, and release documentation.
  • Support deployment activities including Go-Live planning, production deployment, and post-Go-Live support.
  • Proactively communicate with business, IT partners, and stakeholders regarding changes, risks, dependencies, and timelines.
  • Conduct knowledge transfer sessions and provide detailed documentation to Ministry staff.

Must-Have Requirements

  • 7+ years of experience in ETL and database development using SQL Server, T-SQL, Oracle, PL/SQL.
  • 2+ years of hands-on experience with Azure Data Factory, Azure Data Lake, Databricks.
  • Strong experience with Python and PySpark for data transformation.
  • Proven experience building data warehouses and dimensional data marts, including full and incremental loads.
  • Strong knowledge of dimensional modeling and slowly changing dimensions (SCD).
  • Experience with ETL tools such as SSIS and strong SQL scripting skills.
  • Understanding of Delta Lake architecture and modern data warehouse design.
  • Experience analyzing requirements, designing ETL solutions, testing, and documenting pipelines.
  • Strong database performance tuning and optimization skills.
  • Experience working in Agile environments.
  • Ability to work onsite 5 days per week in Toronto.

Nice-to-Have

  • Experience with Oracle GoldenGate for change data capture (CDC).
  • Experience using data modeling tools such as SAP PowerDesigner, Visio, or similar.
  • Experience working with Azure DevOps for CI/CD and pipeline management.
  • Experience supporting reporting and analytics platforms post-production.
  • Strong stakeholder communication and presentation skills.
  • Prior experience conducting knowledge transfer and training sessions.

  • ETL Developer

    1 week ago

    Toronto, Ontario, Canada Bevertec Full time

    Title:Software Developer - ETL - SeniorLocation:Toronto, ON.Pay Rate:$85 - $90/ hr (based on experience)On-site.1 year contract.MUST HAVES:Demonstrates years of experience designing, developing, and implementing ETL solutions using Azure Data Factory.Demonstrates development and solution design experience in an environment where Azure Data Factory, and...

  • Senior Java/ ETL Software Developer

    2 weeks ago

    Toronto, Ontario, Canada Source Code Full time

    Senior Java/ ETL Software Developer (Java, Informatica, ETL, SQL, PL/SQL,and Power BI)Toronto, Ontario - Hybrid, 3 days onsite - 87 Sir William Hearst Ave Toronto, ON M3M 0B4Contract, 9 months (with possibly of extension) Employment Ontario is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training,...

  • Software Developer-ETL

    1 week ago

    Toronto, Ontario, Canada Teckhorizon Inc Full time

    Job OverviewWe are seeking a Senior Software Developer ETL to design, develop, and maintain enterprise-level ETL solutions for the Community Services Cluster (CSC) under the Ministry of Public and Business Service Delivery and Procurement.This role involves building scalable data pipelines, supporting data warehouse and business intelligence initiatives, and...

  • Software Developer-ETL Senior

    1 week ago

    Toronto, Ontario, Canada Bevertec Full time

    26652BEV123Software Developer-ETL Senior(IDMC Designs mappings, transformations, parameterization)Toronto, ONContract RoleDuration: The resource is required to be onsite 4 days per week and work remotely 1 day per week.Note:Must haveIDMC Designs robust mappings, uses reusable transformations, parameterization, environment configuration experience.Must...

  • Senior ETL Developer

    7 days ago

    Toronto, Ontario, Canada BuzzClan Full time

    Description· Informatica IDMC ETL Development: Build ETL processes including mappings, workflows, sessions, reusable components. Apply parameterization, environment configs, scheduling, failure handling, and restartability in IDMC.· AWS/Redshift Ingestion & Transform: design S3 landing/staging areas for data integration. Implement UPSERT/MERGE logic for...

  • Senior ETL Developer

    2 weeks ago

    Toronto, Ontario, Canada Global Applications Solutions LLC Full time

    Hope you doing well,ETL DeveloperOnsite / 21 College Street, TorontoContract RoleCustomer is government of CanadaA Note on Assignment Type:This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday...

  • ETL Developer

    1 week ago

    Toronto, Ontario, Canada Source Code Full time

    ETL Developer (ETL Azure Data Factory, Databricks, Logic App and Function App, IBM Cognos and Microsoft PowerBI, SQL Server Stored Procedure, Oracle PL/SQL)1 year contract (with possibility of renewal)Toronto (hybrid)Deliverables section:Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the...

  • RQ10127 - ETL Software Developer

    2 days ago

    Toronto, Ontario, Canada emergiTEL Full time

    Job Title: Software Developer – ETL (Senior)Work ArrangementOnsite (5 days per week)Role SummaryThe Senior ETL Software Developer is responsible for designing, developing, and maintaining scalable data pipelines and analytics solutions across cloud-based and enterprise data platforms. The role focuses on ETL development, data integration, data modeling,...

  • Senior Software Developer – ETL

    2 weeks ago

    Toronto, Ontario, Canada JSG (Johnson Service Group, Inc.) Full time

    Role OverviewWe are seeking a Senior Software Developer (ETL) to lead data and file migration activities from legacy systems to a modernized solution. The successful candidate will ensure best-practice migration approaches, perform detailed analysis, build conversion strategies, and support all stages of data migration through to post-deployment...

  • ETL Talend Developer

    7 days ago

    Toronto, Ontario, Canada Galent Full time

    Role Overview:We are seeking a highly skilled Talend Developer to design, implement, and optimize ETL workflows that support our enterprise data integration needs. The ideal candidate will lead data engineering initiatives, ensure data quality, and collaborate with cross-functional teams to deliver scalable and reliable solutions.Key ResponsibilitiesETL...