ETL Developer – Data Warehouse & AWS

Astra North Infoteck Inc.; Toronto; On-site; CAD 95,000 - 130,000; Part time

Benefits offered by this job

Hybrid work model

Job summary

Randstad Canada is seeking an experienced Senior Software Developer - ETL to lead design and optimization of enterprise data pipelines and data warehousing solutions in a hybrid Toronto setting. You will extract, transform, and load complex datasets across Azure and on-premise systems to support analytics and reporting.

Responsibilities include end-to-end pipeline ownership, schema modeling (star/snowflake), and performance tuning, with hands-on PL/SQL, T-SQL, Python, and shell scripting.

Qualifications

• Experience designing and building data warehouses with star/snowflake models.
• Proficiency in PL/SQL and T-SQL for data transformation.
• Hands-on Azure Data Factory pipelines and Azure SQL Server.
• Expertise in relational DBMS (Oracle, PostgreSQL, SQL Server) and performance tuning.
• Scripting with Python or Unix shell; Elasticsearch tuning.
• Git for version control; Jira or Azure DevOps for backlog management.

Responsibilities

• Design, build, automate, and optimize complex ETL/ELT pipelines across multi-platform environments.
• Construct scalable star and snowflake schemas, building denormalized data assets for analytics.
• Develop PL/SQL, T-SQL, Python, and Shell scripts for procedures, packages, views, and triggers.
• Build, configure, and manage Azure Data Factory pipelines and Azure SQL Server data solutions.
• Tune queries and Elasticsearch performance; manage data migrations and migrations.

Skills

ETL & Data Warehousing Seniority

Advanced Database Programming

Scripting & Data Tools

Git & DevOps Practices

Elasticsearch

Python

Unix shell scripting

Jira

Azure DevOps

Tools

Azure Data Factory

Azure SQL Server

Oracle PL/SQL

PostgreSQL

SQL Server

Elasticsearch

Git

Jira

Job description

We are seeking an experienced Senior Software Developer - ETL to lead the design, development, and optimization of enterprise-grade data pipelines and data warehousing solutions. In this role, you will extract, transform, and load complex datasets from diverse sources into relational and dimensional schemas (star/snowflake). Working across relational database platforms and cloud ecosystems, you will construct automated ETL/ELT workflows, build denormalized data assets, optimize query performance, and ensure scalable, high-quality data delivery for end-user analytics and reporting.

Advantages

Location: Toronto, ON (Hybrid - 3 days in office)
Duration: 7-month contract.
Multi-Database & Cloud Scope: Work across Azure SQL, Azure Data Factory, Oracle PL/SQL, and Elasticsearch.
End-to-End Pipeline Ownership: Lead design, migration, performance tuning, and schema modeling.
Modern Integration Focus: Transform normalized legacy databases into high-performance cloud data assets.
Flexible Hybrid Setup: Enjoy schedule balance with a hybrid model of 3 days in office.

Responsibilities

Data Pipeline & ETL Development: Design, build, automate, and optimize complex ETL/ELT pipelines to extract, cleanse, transform, and load large datasets across multi-platform environments.
Data Warehousing & Modeling: Construct scalable star and snowflake schemas, building denormalized data assets from normalized databases to support analytical reporting.
Database Programming & Scripting: Write advanced PL/SQL, T-SQL, Python, and Shell scripts to develop stored procedures, packages, views, and automated database triggers.
Cloud Integration & Orchestration: Build, configure, and manage Azure Data Factory pipelines, copy activities, and Azure SQL Server data solutions.
Performance Tuning & Optimization: Troubleshoot database bottlenecks, tune complex queries, manage failover/recovery, and optimize Elasticsearch for search and reporting performance.
Platform Data Migration: Execute end-to-end data migrations and integrations across heterogeneous platforms and database systems (Oracle, Azure SQL, PostgreSQL, MySQL).
Lifecycle Support & Version Control: Use Git and version control for database objects and data models, managing delivery tasks and issue resolution through Azure DevOps or Jira.
Documentation & Technical Collaboration: Collaborate with cross-functional technical teams to translate system specifications into tested code while maintaining detailed technical pipeline documentation.

Qualifications

ETL & Data Warehousing Seniority: Proven experience designing and building data warehouses, dimensional models (star/snowflake schemas), and automated ETL/ELT pipelines (Strictly Required).
Advanced Database Programming: Advanced proficiency in PL/SQL and T-SQL to write complex procedures, packages, views, and scripts for data transformation and denormalization (Strictly Required).
Azure Cloud Data Services: Extensive hands-on experience building Azure Data Factory pipelines and working with Azure SQL Server (Strictly Required).
Multi-DBMS & Modeling Expertise: Deep expertise in relational database platforms (Oracle, PostgreSQL, SQL Server), advanced data modeling, and query performance tuning (Strictly Required).
Scripting & Search Technologies: Practical experience using Python or Unix shell scripting for automation, alongside hands-on tuning with Elasticsearch (Strictly Required).
Version Control & DevOps Tools: Working knowledge of Git for version control alongside Jira or Azure DevOps for backlog and issue management.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle.