DataStage Developer - Contract Opportunity

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

Job summary

An innovative firm is looking for a skilled DataStage developer to join their dynamic team for a 3-6 month contract. In this role, you will leverage your strong analytical skills and extensive experience with Informatica to develop custom SQL scripts and design ETL processes. You will be responsible for performance tuning and data conversion planning, ensuring seamless integration with various data sources. This is a fantastic opportunity to contribute to large systems development and systems integration initiatives in a fast-paced environment. If you're passionate about data and eager to make an impact, this role is perfect for you.

Qualifications

• Minimum 3 years of experience as a DataStage developer.
• Strong analytical skills and experience in database design.

Responsibilities

• Develop custom SQL scripts and stored procedures for data transformation.
• Design and implement ETL processes using DataStage.

Skills

DataStage

Informatica

SQL

Data Architecture

Dimensional and Relational Data Modeling

Job description

Our client is seeking a DataStage developer to work in a dynamic, fast-paced environment. You will have strong analytical skills, experience in database design and implementation, and deep experience with Informatica.

This is a 3-6 month contract.

You will be responsible for:

1. Development of custom SQL scripts and stored procedures
2. Development of the ETL design document and transformation rules
3. Design, develop and implement transformation processes using Data Stage that will load/extract data into/from databases from/to various sources/destinations.
4. Performance tuning of mapping and ETL processes, as required.
5. Data Conversion Planning and Implementation
6. Prepare and execute test cases for unit and integration testing
7. Assisting in/working with the client and other consultants to map the data structure to a Cognos Business Intelligence environment (ReportNet)

Required Skills and Experience

1. Minimum 3 years experience as a DataStage developer
2. 1 year experience with DataStage version 7.5
3. Excellent experience with Informatica
4. Knowledge of dimensional and relational data modeling techniques
5. Must have experience working on large systems development or systems integration initiatives.
6. A working knowledge of Data Architecture

Click here to apply online