Senior Software Developer - ETL

Teckhorizon Inc; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

A leading company is seeking a Senior ETL Developer to design, develop, and maintain backend database and ETL applications for enterprise Data Warehouse solutions. The role includes translating system specifications into well-documented ETL code and collaborating with teams to ensure scalable data flows. Candidates should have expertise in SQL, data integration, and a robust understanding of ETL processes. This full-time position offers a hybrid work environment in Toronto.

Qualifications

• Proven experience with Oracle DB, ETL programs, and SQL.
• Strong understanding of ETL architecture and business requirement gathering.
• Excellent communication and collaboration skills.

Responsibilities

• Design and implement ETL pipelines using Microsoft technologies.
• Translate technical specifications into fully tested functional code.
• Investigate and resolve issues in data flows.

Skills

SQL

Data Warehousing

ETL Development

Data Modeling

Oracle

Power BI

Tools

Power BI

SSIS

Informatica

Pentaho

Teradata

Job description

Client : Ministry of Treasury Board Secretariat Central Agencies Cluster

Location : 222 Jarvis Street Toronto ON

Work Type : Hybrid (3 days onsite 2 days remote)

Role Summary

The Senior ETL Developer will design develop and maintain backend database and ETL applications for enterprise Data Warehouse and Business Intelligence solutions. The role involves translating system specifications into functional well-documented ETL code and collaborating with cross-functional teams to ensure scalable and reliable data flows.

Responsibilities

• Design and implement robust ETL pipelines using Microsoft technologies (Azure SQL Power BI).
• Translate technical specs into fully tested functional code.
• Develop and maintain ETL scripts with schedule / dependency logic.
• Investigate and resolve issues in data flows; provide post-implementation support.
• Collaborate on solution design documentation and walkthrough sessions.
• Ensure applications meet performance scalability and compliance standards.

Mandatory Skills and Experience

• Proven experience with :
• Oracle DB and structured / semi-structured data sources
• Developing daily and initial load ETL programs
• Constructing complex SQL queries and performance tuning
• Data integration cleansing analytics and modeling for data marts / warehouses
• Source control tools (e.g. Git ) and documentation (ETL mappings data models etc.)
• Strong understanding of :

ETL architecture and schedule / dependency logic

• Full SDLC (Development Testing QA Delivery)
• Business requirement gathering and validation
• Excellent communication and collaboration skills
• Knowledge of :

Designing dashboards / KPIs and generating reports

• C# APIs Functions scripting languages (e.g. PowerShell )
• SaaS implementations and RAD methodologies
• Middleware gateways and software installation scripts

Key Skills

SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1

Create a job alert for this search

Senior Software Developer • Toronto, Ontario, Canada