Contract DataStage ETL Developer — Informatica Expert

ROSS; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology services company is seeking a Data Stage developer to work in Toronto. This role involves developing custom SQL scripts, designing ETL processes, and assisting with data structure mapping to Cognos BI. The ideal candidate will have a minimum of 3 years of Datastage experience, knowledge of Informatica, and strong data architecture skills. This position is a contract lasting 3-6 months.

Qualifications

• Minimum 3 years experience as a Datastage developer.
• 1 year experience with Datastage version 7.5.
• Excellent experience with Informatica.
• Knowledge of dimensional and relational data modeling techniques.
• Must have experience working on large systems development or systems integration initiatives.

Responsibilities

• Development of custom SQL scripts and stored procedures.
• Development of the ETL design document and transformation rules.
• Design, develop and implement transformation processes using Data Stage.
• Performance tuning of mapping and ETL processes.
• Data Conversion Planning and Implementation.
• Prepare and execute test cases for unit and integration testing.
• Assisting in mapping the data structure to Cognos Business Intelligence.

Skills

SQL scripting

ETL design

Informatica

Data Stage

Data Architecture

Tools

Cognos

Data Stage version 7.5

Job description

A technology services company is seeking a Data Stage developer to work in Toronto. This role involves developing custom SQL scripts, designing ETL processes, and assisting with data structure mapping to Cognos BI. The ideal candidate will have a minimum of 3 years of Datastage experience, knowledge of Informatica, and strong data architecture skills. This position is a contract lasting 3-6 months.