Etl informatica developer Jobs in Toronto, ON

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.

Location: Toronto, ON (Hybrid – 3 days in office)

Duration: 7-month contract.



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



Summary
If you're interested in the "Senior Software Developer - ETL" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!



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. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.