ETL/Datastage Developer

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

Job summary

A boutique consulting firm is seeking an ETL Developer with 5-7 years of experience for a project with a large Telco company in Toronto. The role involves building ETL processes using DataStage, extracting data from Oracle databases, and transforming data for loading into Web Services. Excellent communication skills are required. This is a 10-week engagement with a potential for extension.

Qualifications

• 5-7 years of experience as an ETL Developer.
• Intermediate to advanced skills in DataStage.
• Experience in extracting data from Oracle databases.

Responsibilities

• Work with the project team to build an ETL process.
• Extract data from an Oracle database.
• Transform data for the load process into Web Service.

Skills

DataStage Developer

Oracle database

Unix Scripts

Communication Skills

Tools

DataStage

Oracle

BEA Web Logic

Tivoli

Job description

Opportunity Details

Our client is a boutique consulting firm that is currently working on a project with a large Telco company. They are looking to an ETL Developer with 5-7 years experience. This is a 10 week engagement that has a great possibility of being extended.

Opportunity Details:

• Work with the project team to build an ETL (DataStage) process
• Extract data from an Oracle database
• Follow business rules to transform the data for load process into Web Service (BEA Weblogic) – no change to web services will need to support the wrapping of ETL process in Tivoli job stream

Skills and Experience

• DataStage Developer — Intermediate to advanced (2-5 years)
• Oracle database — Same as above
• Unix Scripts — Same as above
• Tivoli — Nice to have
• BEA WebLogic — Nice to have – not needed
• Communication Skills — Written and Oral

Technical Environment

• Client-Server, Web or Mainframe: Client Server
• Front-end (GUI), back-end or 3-tier development: Back-end - batch
• Hardware: N/A
• Software: Oracle, DataStage, BEA Web Logic
• O/S: Unix
• Database: Oracle
• ETL: DataStage
• Reporting: N/A
• Communication/Middleware: DataStage for ETL
• Methodology: Proprietary Rapid Application Development