software developer – etl

2 days ago


Toronto, Ontario, Canada SOFTLINE TECHNOLOGY Full time

%

Core Technical Skills

  • Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
  • Experience with the Amazon Web Services (AWS) suite of technology including: Amazon Aurora, Amazon Relational Database Search, Glue, OpenSearch, etc.
  • Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
  • Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
  • Experience with data integration, data cleansing, and data analytics
  • Experience with data modeling and design principles for data marts and data warehouses
  • Experience in database management and administration
  • Experience in constructing complex SQL queries and performance tuning
  • Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.

50%

Other Technical Skills

  • Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)
  • Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.
  • Experience writing scripts with PowerShell and other scripting languages
  • Experience with Git and knowledge of source control strategies
  • Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery

35%

Communications Skills

  • Experience in eliciting, documenting, and validating business requirements
  • Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.

10%

Standards and Best Practices

  • Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

5%

Supplier Comments

Closing Date – , 11:00 a.m.

Maximum Number of Submissions – one (1)

Assignment Type – 5 days Onsite

MUST HAVES:

  • Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI

  • Experience with Databricks Platform

  • Experience with the Amazon Web Services (AWS) suite of technology including: Amazon Aurora, Amazon Relational Database Search, Glue, OpenSearch, etc.

  • Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)

  • Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts

  • Experience with data integration, data cleansing, and data analytics

  • Experience with data modeling and design principles for data marts and data warehouses

Experience with designing modern analytics architectures (e.g., data warehouses, data lakes, lakehouses).



  • Toronto, Ontario, Canada S M Software Solutions Inc Full time

    Client:Ministry of Treasury Board SecretariatWork Location:222 Jarvis St, Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:279.00Extension:130.00Hours per day or Week:7.25 hours per daySecurity Level:CRJMCMust HavesExperience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data...


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


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


  • Toronto, Ontario, Canada Russell Tobin Full time

    Job Title: Software Developer - ETL (Senior)Location: Toronto, ON (Onsite)Duration: 61 Days with extension to 250 DaysClient: Public SectorPay Rate: C$80-C$90/hrRole Summary:The Senior Software Developer - ETL will be responsible for designing, developing, and maintaining secure, scalable ETL/ELT solutions using Microsoft Azure and Databricks technologies....


  • Toronto, Ontario, Canada emergiTEL Full time

    Job Title: Software Developer – ETLWork Arrangement: OnsiteHours: 7.25 hours/day (Monday–Friday, 8:00 AM – 5:00 PM, excluding lunch)Role OverviewThe Software Developer – ETL is responsible for designing, building, and supporting scalable data pipelines and data platforms that power enterprise analytics and reporting. This role focuses on ELT/ETL...

  • QE - ETL Testing

    8 hours ago


    Toronto, Ontario, Canada Iris Software Inc. Full time

    Iris's Fortune 100 direct client is looking forQE - ETL Testing. Please find below Job description and share me your updated resume atPosition: QE - ETL TestingLocation: Toronto ONResponsibilitiesDesign, develop, and execute test plans, test cases, and test scripts for ETL processes and data transformations.Perform data validation, data reconciliation, and...


  • Toronto, Ontario, Canada Maarut Inc Full time

    Responsibilities/Assignment Deliverables – Senior ETL DeveloperDesigns, develops, and maintains database back end and ETL applications for Data Warehouse and Business Intelligence solutions. ...


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

  • ETL Developer

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

  • BI & ETL Tester

    8 hours ago


    Toronto, Ontario, Canada Software International Full time

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.We currently have a multiple, re-extendable, long term contract roles as a BI & ETL Tester - Hybrid with our global SAP consulting client, working onsite at large...