ETL/Datastage Developer

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

Job summary

Join a dynamic consulting firm as an ETL Developer, where you'll leverage your expertise in DataStage and Oracle databases. This exciting 10-week engagement involves working closely with a project team to build robust ETL processes, ensuring seamless data transformation and integration with web services. Your skills in Unix scripting and communication will be essential in supporting the ETL process. This role promises a collaborative environment and the potential for extension, making it a fantastic opportunity for professionals eager to make a significant impact in the tech landscape.

Qualifications

• 5-7 years of experience as an ETL Developer, focusing on DataStage.
• Proficient in Oracle databases and Unix scripting.

Responsibilities

• Build ETL processes using DataStage, extracting data from Oracle databases.
• Transform data for load processes into Web Services with business rules.

Skills

DataStage Developer

Oracle database

Unix Scripts

Tivoli

BEA WebLogic

Communication Skills

Tools

DataStage

Oracle

Unix

BEA WebLogic

Job description

Our client is a boutique consulting firm that is currently working on a project with a large Telco company. They are looking for an ETL Developer with 5-7 years of 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:

1. Extract data from an Oracle database.
2. 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 Required:

Skill	Level of Proficiency
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's: Oracle

ETL: DataStage

Reporting: N/A

Communication/Middleware: DataStage for ETL

Methodology: Proprietary Rapid Application Development