Senior ETL Developer

3 days ago


Toronto Ontario CA, Ontario Teckhorizon Inc Full time

Overview

We are looking for a highly skilled Senior ETL Developer to design, implement, and optimize ETL pipelines. The role requires expertise in Azure Data Factory, data warehouse design, and integration with reporting tools like Power BI. The successful candidate will work closely with cross-functional teams to ensure scalable and high-performing data solutions.

Key Responsibilities

  • Design and develop ETL pipelines using Azure Data Factory.
  • Integrate ETL processes with reporting tools, such as Power BI.
  • Create and manage data warehouses and marts for platforms including SQL Server, Azure SQL Database, and Oracle.
  • Debug and enhance complex SQL queries and transformations.
  • Collaborate with teams to implement CI/CD pipelines using Azure DevOps.
  • Conduct unit testing, system integration testing, and user acceptance testing.
  • Document technical designs, code changes, and deployment processes.
  • Ensure scalable, high-quality data architecture that meets business needs.

Qualifications

  • 7+ years of experience in ETL development with expertise in Azure Data Factory.
  • Strong experience in data modeling and designing star schema.
  • Proficiency in SQL Server (2016+), Unix shell scripting, and debugging ETL processes.
  • Familiarity with tools like Informatica PowerCenter and Power Designer is a plus.
  • Experience in Agile and Waterfall development methodologies.
  • Strong analytical, communication, and problem-solving skills.

Preferred Skills

  • Experience in public sector projects or large organizations.
  • Knowledge of AODA compliance standards.
  • Familiarity with middleware technologies and rapid application development.


  • Toronto, Ontario, C6A, Ontario, Canada Newport Williams Ltd Full time

    Job Location: 87 Sir William Hearst Ave, Toronto.Hybrid: 3 days onsite, 2 days remoteOur public sector client is looking for a Senior ETL developer from 6th Jan 2025 to 31st March 2026.Here are the skillset they are looking for: Data Pipeline Design and Development Design, develop, and implement data pipelines using Azure Data Factory (ADF), stored...

  • ETL Developer

    5 days ago


    Toronto, Ontario, C6A, Ontario, Canada Delpath Full time

    ETL Developer Location: Hybrid – Scarborough – 2-3 days/weekContract Duration: 6 months with high Possibility of extension – Yes Possibility of conversion to FTE - YesSchedule Hours: 9am-5pm Monday-Friday; standard 37.5hrs/week (should be available for occasional off hours meeting) Reason: New Project Business Group: COAT - Contact center technology -...

  • ETL Developer

    5 days ago


    Toronto, Ontario, C6A, Ontario, Canada Maarut Inc Full time

    RequirementsExperience and Skill Set Requirements:Must Haves:Design, Develop and Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activitiesDevelop Azure CI/CD pipeline to automate ADF release.Extensive experience in design, development, and...

  • ETL Tester

    2 weeks ago


    Toronto, Ontario, C6A, Ontario, Canada AllianceIT Inc Full time

    Role: ETL Tester (Complex SQL Queries)Location: Toronto, ON (Onsite)Job Description:10+ years of experience in ETL QA with strong SQL Queries.ETL QA Assist with the development of QA software for our testing facility Oversee the production of all software products created by our design and programming team Monitor and review quarterly data based on suppliers...


  • Toronto, Ontario, Canada Wirehead Full time

    Job Title: Senior ETL Development SpecialistAbout the Role:We are seeking an experienced Senior ETL Development Specialist to join our team at Wirehead. As a key member of our data integration team, you will be responsible for designing, developing, and implementing complex ETL pipelines using Azure Data Factory (ADF) and other tools.Responsibilities:Design...

  • Senior ETL

    4 days ago


    Toronto, Ontario, C6A, Ontario, Canada S.i. Systems Full time

    Contract Length: 12 months + 12 months extensionMust Haves:A university degree in applied sciences such as Computer Science, Systems Design, Engineering, Business, or a combination of education, training, and experience deemed equivalent.3-5 years of experience in cloud architecture and design principles for web services within Azure Cloud and Oracle...


  • Toronto, Ontario, Canada Newport Williams Ltd Full time

    **Job Title:** Senior ETL Developer for Large Data Sets **Overview of the Role:**Newport Williams Ltd is seeking an experienced Senior ETL Developer to join our team. This role will focus on designing, developing, and implementing data pipelines using Azure Data Factory (ADF), stored procedures, and Informatica PowerCenter for extraction, transformation,...

  • ETL Tester

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Kumaran Systems Full time

    We are seeking a highly motivated and experienced Senior Test Automation Engineer to join our QA team. You will play a critical role in ensuring the quality and reliability of our mission-critical financial transaction processing system. This involves designing, developing, and executing automated tests for ETL processes, database validations, and API...


  • Toronto, Ontario, Canada S.i. Systèmes Full time

    About the Role: We are seeking a skilled Senior ETL Specialist to join our team at S.i. Systèmes. As a key member of our data integration team, you will be responsible for designing, developing, and implementing robust and scalable ETL data pipelines using cutting-edge technologies such as Azure Data Factory, Azure Synapse, and IBM InfoSphere.Key...


  • Toronto, Ontario, Canada Maarut Inc Full time

    At Maarut Inc, we are seeking a highly skilled Senior ETL Developer to join our team in designing and implementing robust data warehouses.The ideal candidate will have extensive experience in developing ETL solutions using Azure Data Factory, PowerBI, and Oracle SQL Server. They will be responsible for ensuring seamless integration with existing systems and...


  • Toronto, Ontario, Canada Scotiabank Full time

    Unlock Your Potential in a Dynamic EnvironmentAbout the Role:We are seeking an experienced Senior Datastage Developer to join our team. As a key member, you will play a vital role in designing, developing, and implementing data warehousing solutions using Datastage.About You:To be successful in this role, you should have a strong foundation in data...


  • Toronto, Ontario, Canada Wirehead Full time

    Job Title: Senior ETL Data Integration SpecialistDescription:We are seeking a highly skilled Data Transformation Expert to join our team at Wirehead. As an ETL Developer, you will play a critical role in designing, developing, and implementing data pipelines using Azure Data Factory (ADF), stored procedures, and Informatica PowerCenter.Key...


  • Toronto, Ontario, C6A, Ontario, Canada S.i. Systems Full time

    Our client is seeking an Intermediate ETL Developer to design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities in a SQL Environment.Must Haves:5+ years of experience as a ETL Developer in database and/or reporting environments incorporating Microsoft SQL Server technology.Experience in data...


  • Toronto, Ontario, Canada Teckhorizon Inc Full time

    We are seeking a seasoned Senior ETL Developer to spearhead the design, implementation, and optimization of ETL pipelines at Teckhorizon Inc.About the RoleThis pivotal position demands expertise in Azure Data Factory, data warehouse architecture, and integration with reporting tools like Power BI. As a key member of our cross-functional team, you will...


  • Toronto, Ontario, Canada Rubicon Path Full time

    **Job Summary:**We are seeking a highly skilled Senior Data Engineer with expertise in designing, developing, and implementing large-scale data pipelines using Databricks and related tools. As an ETL Specialist at Rubicon Path, you will play a critical role in ingesting, transforming, and storing large-scale datasets for our business.Key...


  • Toronto, Ontario, Canada Tata Consultancy Services Full time

    Job DescriptionWe are seeking an experienced Senior Data Engineer with expertise in Hadoop and ETL processes to join our team at Tata Consultancy Services Canada Inc.About the RoleThis is a senior-level position that requires strong technical knowledge of data warehousing, ETL processes, and big data technologies. The successful candidate will be responsible...


  • Greater Toronto Area, Canada, Ontario Messagepoint Full time

    Position: Senior Software Developer - AWS Glue and ETLType: Contract (9–12 months, with potential for extension)Location: Kitchener/Waterloo / Toronto or RemoteStart Date: ASAPAbout Us:Messagepoint is a privately-owned, PE-funded software company headquartered in Toronto, Ontario. We enable large enterprises to deliver enhanced customer experiences and...


  • Toronto, Ontario, Canada Newport Williams Ltd Full time

    About the RoleWe are seeking an experienced Senior ETL Data Engineer to join our team at Newport Williams Ltd. This is a 16-month contract position starting from January 2025, requiring expertise in designing and implementing data pipelines using Azure Data Factory (ADF), stored procedures, and Informatica PowerCenter for extraction, transformation, and...


  • Toronto, Ontario, Canada Kumaran Systems Full time

    We are seeking a highly skilled Senior Test Automation Engineer to join our QA team at Kumaran Systems. As an integral part of our mission-critical financial transaction processing system, you will play a pivotal role in ensuring the quality and reliability of our operations.Job DescriptionTest Automation Framework Development: Design, develop, and maintain...


  • Toronto, Ontario, Canada Tata Consultancy Services Full time

    About UsTata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with numerous global businesses in their transformation journeys for over five decades.Role OverviewWe are seeking a highly skilled Senior ETL Tester for Data Integrity to join our team. As a key member of our data management...