Senior ETL Developer

3 weeks ago


Toronto Ontario CA, Ontario Newport Williams Ltd Full time

Job Location: 87 Sir William Hearst Ave, Toronto.

Hybrid: 3 days onsite, 2 days remote

Our 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 procedures, and Informatica PowerCenter for extraction, transformation, and loading (ETL) processes.
  • Build and automate Azure CI/CD pipelines for ADF releases.
  • Expertise in ADF, Databricks, and Informatica for data movement, ETL pipeline creation, and performance tuning for large datasets.
  • Experience designing and developing SQL Server stored procedures and Oracle PL/SQL programs.
  • Proficient in relational databases, including Oracle and Microsoft SQL Server.

ETL and Data Integration

  • Gather requirements and analyze business processes to design efficient data transformations.
  • Extensive experience with Azure Data Factory, including:
  • Self-hosted Integration Runtime
  • Complex data transformations
  • Performance optimization on large data volumes
  • ADF debugging tools and Azure roles.
  • Proficiency in Informatica tools: Workflow Manager, Repository Manager, Designer, and Workflow Monitor.
  • Develop solutions using Logic App and Function App.
  • Maintain, enhance, and troubleshoot existing ETL processes.
  • Investigate data to identify and resolve ETL pipeline issues.
  • Experience with business intelligence tools like IBM Cognos and Microsoft Power BI.

Azure Technologies and DevOps

  • Extensive experience with CI/CD (DevOps) pipelines, including:
  • Azure Resource Management
  • GitHub Repo, source code version control, branching strategies, pull requests, and release management.
  • Proficiency in Azure DevOps tools: Azure Boards, Test Plans, Pipelines, Repos, and Artifacts.

Oracle PL/SQL and Database Development

  • Develop and optimize SQL Server stored procedures and Oracle PL/SQL programs.
  • Proficiency with Oracle, Microsoft SQL Server, and hierarchical database technologies.
  • Expertise in Azure SQL DB and Synapse platforms, including performance tuning for large data sets.

This role requires a strong foundation in ETL processes, Azure DevOps, database technologies, and advanced data transformation capabilities. Proficiency in Azure tools, Informatica, and database platforms is essential to succeed in this position.


  • Senior ETL Developer

    2 weeks ago


    Toronto, Ontario, C6A, Ontario, Canada 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...

  • ETL Developer

    3 weeks 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

    1 week ago


    Toronto, Ontario, C6A, Ontario, Canada Infotek Consulting Inc. Full time

    DescriptionETL Developer. ONSITE: times/week (Tuesday + Thursdays, and other ad hoc day as needed) Contract Duration: 01/27/2025 to 06/27/2025 – 6 months Program needs ETL Developer. Implementation is planned for Jun-2025. CCaaS Program – Contact centre as a service project/program – this role will be working with Campaign management team – manage...

  • ETL Developer

    3 weeks 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

    4 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

    2 weeks 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,...


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

  • Senior ETL Developer

    2 weeks ago


    Toronto, Ontario, Canada Newport Williams Ltd Full time

    About Newport Williams LtdWe are seeking an experienced Senior ETL Developer to join our team at Newport Williams Ltd. The ideal candidate will have a strong background in data transformation, Azure DevOps, and database technologies.Job SummaryWe offer a competitive salary of $110,000 - $130,000 per annum, depending on experience. This role requires a...

  • Senior ETL Specialist

    2 weeks ago


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

  • ETL Tester

    1 month 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 Newport Williams Ltd Full time

    **Job DescriptionNewport Williams Ltd is seeking a highly skilled Senior ETL Developer to design, develop, and implement data pipelines using Azure Data Factory (ADF), stored procedures, and Informatica PowerCenter.**Key Responsibilities:Design and develop efficient data transformations using ADF, Databricks, and Informatica for large datasets.Build and...


  • Toronto, Ontario, Canada Kumaran Systems Full time

    Kumaran Systems Job DescriptionOverviewWe are seeking a highly motivated and experienced Senior Test Automation Engineer to join our QA team.Key ResponsibilitiesDesign, Develop, and Execute Automated Tests: Develop and execute automated tests to validate data extraction, transformation, and loading processes for our mission-critical financial transaction...


  • Toronto, Ontario, Canada Newport Williams Ltd Full time

    **Job Title:** Data Integration Engineer - Azure ETL Developer About Us:Newport Williams Ltd is a leading provider of data integration solutions. We are seeking an experienced Senior ETL developer to join our team. Overview:This role requires a strong foundation in data integration, Azure DevOps, and database technologies. You will design, develop, and...


  • 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, Canada Apptoza Inc. Full time

    At Apptoza Inc., we are seeking a highly skilled Senior ETL Engineer with expertise in data automation to join our team.Job Description:As an ETL Test Automation Analyst, you will be responsible for designing and implementing automated testing solutions for our ETL processes. You will work closely with our development team to ensure seamless integration of...


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

  • Senior Data Engineer

    3 weeks ago


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


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