ETL Lead Developer : Toronto, ON : FTE

Job Description – ETL Lead Developer

Location: Toronto, ON

Work Mode: Onsite

Experience: 10+ Years

Role Overview

We are seeking an experienced ETL Lead Developer with 10+ years of IT experience and strong expertise in data warehousing, ETL development, and database technologies. The ideal candidate will have hands-on experience developing and maintaining Microsoft SSIS packages, managing end-to-end data warehouse solutions, and working within the banking and financial services domain.

The candidate will be responsible for leading ETL development activities, translating business requirements into technical solutions, ensuring data quality and performance, and mentoring development teams.

Key Responsibilities

•

Design, develop, enhance, and maintain ETL processes and data warehouse solutions.

•

Develop and manage ETL packages using Microsoft SQL Server Integration Services (SSIS).

•

Work with Microsoft SQL Server, Sybase, IBM Netezza, and AWS Redshift databases for data extraction, transformation, loading, and reporting.

•

Analyze business and technical requirements and translate them into scalable data integration solutions.

•

Lead and coordinate ETL development activities, review code, troubleshoot issues, and mentor team members.

•

Manage end-to-end data warehouse processes, including data ingestion, transformation, reconciliation, and data quality validation.

•

Optimize ETL workflows, SQL queries, and database performance to ensure reliable and efficient processing.

•

Collaborate with business analysts, architects, QA teams, and other stakeholders to deliver data solutions aligned with business needs.

•

Support data integration and processing requirements across banking and financial services applications.

Must-Have Skills and Experience

1.

ETL and Data Warehousing: 10+ years of overall IT experience, with strong hands-on expertise in ETL development, enterprise data warehousing, and end-to-end data integration processes.

2.

Microsoft SSIS/SSRS: Strong experience developing, maintaining, and troubleshooting SSIS packages, with knowledge of SSRS for reporting and data delivery.

3.

Database Technologies: Hands-on experience with Microsoft SQL Server and exposure to IBM Netezza and/or Sybase databases, including SQL development, query optimization, and performance tuning.

4.

Banking and Financial Services Domain: Strong understanding of banking data, financial services processes, and data warehouse requirements in a banking environment.

5.

Technical Leadership and Delivery: Proven ability to lead ETL development teams, mentor developers, understand business requirements, resolve technical issues, and manage end-to-end data warehouse delivery.

Nice-to-Have Skills

•

AWS Data Services: Experience with AWS Glue, Amazon Redshift, EMR, Spark, and other AWS cloud data services.

•

Lending Systems: Functional knowledge of retail or commercial lending systems and associated data processing workflows.

•

Master Data Management (MDM): Experience with MDM solutions, particularly customer demographic data processing and integration.

•

Core Banking and Deposit Systems: Knowledge of retail and commercial deposit processing and core banking systems, preferably within the Canadian banking domain.

•

Advanced Cloud ETL and Data Integration: Experience designing cloud-based ETL solutions, including Kafka-based message processing, batch data ingestion, and business-layer data integration.

Ideal Candidate Profile

•

Strong hands-on technical expertise combined with team leadership capabilities.

•

Excellent analytical, problem-solving, and troubleshooting skills.

•

Ability to communicate effectively with technical teams and business stakeholders.

•

Experience delivering reliable, scalable, and high-quality data warehouse solutions in complex enterprise environments.

•

Comfortable working onsite in Toronto, Ontario.