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

This is a 3-6 month contract.

You will be responsible for:

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 that will load/extract data into/from databases from/to various sources/destinations.

Performance tuning of mapping and ETL processes, as required.
Data Conversion Planning and Implementation
Prepare and execute test cases for unit and integration testing
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

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.
A working knowledge of Data Architecture

 

 

Details

Employee Type
Full-Time Regular
Location
Toronto ON