Data Dev Lead

Compunnel Inc.

Toronto

On-site

CAD 90,000 - 120,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

The Data Dev Lead will be responsible for leading data development activities, with a strong focus on hands‑on work using IBM DataStage.

This role involves designing, developing, and optimizing data workflows, working across SQL Server, PL/SQL, and mainframe environments.

The ideal candidate will ensure seamless data processing, job scheduling, and integration across multiple systems.

Key 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 write, optimize, and troubleshoot SQL queries.
  • Develop PL/SQL scripts and stored procedures for data transformation and processing.
  • Utilize Mainframe JCL for job management and batch processing activities.
  • Coordinate job scheduling and workflow management using scheduling tools.
  • Collaborate with cross‑functional teams to ensure data accuracy, performance, and reliability.
  • Troubleshoot issues across ETL, database, and mainframe processes.
  • Provide guidance and leadership to junior data developers as needed.
Required 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.
  • Experience working with schedulers and operational job orchestration.
  • Strong analytical, problem‑solving, and debugging skills.
  • Excellent communication and collaboration skills.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DataStage ETL Lead: Hands-On Data Integration
DataStage ETL Lead: Hands-On Data Integration

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
ETL DataStage Developer
ETL DataStage Developer

Apptoza Inc. • Toronto

On-site
CAD 80,000 - 100,000
DataStage Developer
DataStage Developer

Cognizant Technology Solutions Corporation • Canada

On-site
CAD 90,000 - 130,000
DataStage Developer - Contract Opportunity
DataStage Developer - Contract Opportunity

ROSS • Toronto

On-site
CAD 80,000 - 100,000
Senior ETL Datastage Developer
Senior ETL Datastage Developer

Lorven Technologies, Inc. • Vancouver

On-site
CAD 90,000 - 130,000
ETL/Datastage Developer
ETL/Datastage Developer

ROSS • Toronto

On-site
CAD 80,000 - 100,000
DataStage Developer
DataStage Developer

Cognizant Technology Solutions Corporation • Mississauga

On-site
CAD 129,000 - 142,000
Medical/Dental/Vision/Life Insurance
401(k) plan and contributions
Long-term/Short-term Disability
+2
Senior DataStage ETL Developer
Senior DataStage ETL Developer

Cognizant Technology Solutions Corporation • Mississauga

On-site
CAD 129,000 - 142,000
Medical/Dental/Vision/Life Insurance
401(k) plan and contributions
Long-term/Short-term Disability
+2
Datastage developer
Datastage developer

Tata Consultancy Services Limited • Toronto

On-site
CAD 100,000 - 120,000
Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)
Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 130,000