ETL Lead Developer : Toronto, ON : FTE

Toronto, ON
On-site
Posted Oct 29, 2026
1 position

$110–$120 / year

Opens LinkedIn

Employment type: Full-time
Experience level: Lead · 10+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Lead the design, development, maintenance, and optimization of ETL processes and end-to-end data warehouse solutions using SSIS and multiple database platforms. Coordinate and mentor ETL developers, translate business requirements into scalable data solutions, and ensure data quality, reconciliation, and reliable delivery for banking and financial services applications.

Job details

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.

What you’ll do

Requirements

Requires 10+ years of IT experience with strong hands-on expertise in ETL development, enterprise data warehousing, SSIS, and SQL Server, plus exposure to Sybase and/or IBM Netezza. Candidates should understand banking and financial services data and have proven technical leadership, team mentoring, troubleshooting, and end-to-end delivery capabilities.