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:
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.