ETL Developer

Tekshapers; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Tekshapers is seeking a data warehouse leader to design, develop, and support enterprise data warehouse solutions in a Toronto context. You will drive ETL development using SSIS/SSRS, manage data integration across platforms, and mentor teams while aligning with business requirements.

The role spans migration projects on AWS platforms, emphasizing data quality, governance, and operational stability. Collaboration with cross-functional teams is essential to deliver scalable data solutions.

Qualifications

• Experience delivering data warehouse and ETL solutions.
• Proficient in SSIS/SSRS and SQL development.
• Leading teams and managing stakeholders across multiple projects.
• Familiarity with cloud data platforms (AWS) and data migration.

Responsibilities

• Lead design, development, and support of enterprise data warehouse solutions.
• Develop and maintain ETL processes using SSIS and related technologies.
• Manage data integration, transformation, and migration across platforms.
• Collaborate with business and technical teams to gather requirements and deliver scalable data solutions.
• Provide technical guidance and mentorship to development teams.

Skills

Data Warehousing & ETL Development

SSIS / SSRS

SQL Development

Team Leadership & Stakeholder Mgmt

Other ETL Tools

Tools

AWS Redshift

AWS Glue

Job description

Lead the design, development, and support of enterprise data warehouse solutions.

Develop and maintain ETL processes using SSIS and related technologies.

Manage data integration, transformation, and migration activities across multiple platforms.

Collaborate with business and technical teams to gather requirements and deliver scalable data solutions.

Provide technical guidance and mentorship to development teams.

Support data warehouse migration and modernization initiatives involving Netezza and AWS platforms.

Ensure data quality, performance, governance, and operational stability.

Participate in solution design, testing, deployment, and production support activities.

Mandatory Skills

• Data Warehousing & ETL Development
• Microsoft SSIS / SSRS
• AWS Redshift
• AWS Glue
• SQL Development
• Team Leadership & Stakeholder Management

Preferred Skills

• Kafka Message Processing
• Master Data Management (MDM)
• Retail & Commercial Banking Systems
• Core Banking Domain Experience