DataStage ETL Lead: Hands-On Data Integration

Compunnel, Inc.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A data solutions provider in Toronto, Ontario is seeking a Data Dev Lead to oversee data development activities. The role focuses on hands-on work using IBM DataStage for ETL workflows, and requires proficiency in SQL Server and PL/SQL. Responsibilities include leading development projects, optimizing data processes, and working collaboratively across systems to ensure data integrity and performance. This position demands strong analytical skills and the ability to troubleshoot complex data issues.

Qualifications

• Strong hands-on experience with IBM DataStage.
• Proficiency in SQL Server and advanced SQL query development.
• Experience with PL/SQL scripting and stored procedures.
• Knowledge of Mainframe JCL and batch job scheduling.

Responsibilities

• Lead and perform hands-on development using IBM DataStage for ETL workflows.
• Develop, enhance, and maintain data integration processes across multiple environments.
• Work with SQL Server databases to optimize SQL queries.
• Develop PL/SQL scripts and stored procedures for data transformation.

Skills

Hands-on experience with IBM DataStage

Proficiency in SQL Server

Experience with PL/SQL

Knowledge of Mainframe JCL

Strong analytical skills

Excellent communication skills

Job description

A data solutions provider in Toronto, Ontario is seeking a Data Dev Lead to oversee data development activities. The role focuses on hands-on work using IBM DataStage for ETL workflows, and requires proficiency in SQL Server and PL/SQL. Responsibilities include leading development projects, optimizing data processes, and working collaboratively across systems to ensure data integrity and performance. This position demands strong analytical skills and the ability to troubleshoot complex data issues.