Hi,

 

Need: ETL Developer with DB2 and Data Stage and DW

Location: Chicago, IL

Duration: 3+ months

Rate: Open(competitive)

 

Note: Working experience in a Healthcare industry

 

Description:

 

Data warehouse ETL Developer

This individual should have solid understanding of the data warehouse
development lifecycle.

   Minimum of 9 years of IT work experience focused in Data Acquisition and
Data Integration using Data Stage for multi-terabyte Data warehouse in the
area of ETL design, implementation, scheduling.

In Depth Experience in DB2, write SQL, stored procedures, tuning rogue ETL
jobs.

   Experience integrating the components of the following DB2, SQL and Data
Stage (ETL).

   Experience in Designing& Implementing ELT solution for multi-terabyte
Data Warehouse and understand its impacts.

   Experience working with flat files, running ELT jobs concurrently.

   Deep experience in Data Acquisition and Data Integration

   Deep experience in ETL development using DataStage V7.5 or V8

   Experience with IBM AIX UNIX and DB2 

   Anticipate and respond to customer needs; self starter and customer
service oriented

   Works within the team to make appropriate, effective decisions related to
project responsibilities and to initiate and follow-up on assigned tasks
without supervision

 

Types of Deliverables Produced:

   Logical descriptions of the extract, transform, and load process 

   ETL Detailed Design

   Input and output record layouts 

   File/Directory naming conventions 

   File/table sizing information

   File/table volume information 

   File retention/archival information

   Documentation on how the data will be transformed

   ETL Performance Test Plan

 

Workflows

Unit Test Documentation

Accurate and efficient ETL process moved to production

 

Skills:

  Data modeling using Star Schema, snow flake schema.

  ETL (Data Stage is required)

  Unix shell scripting is required.

  Building ETL jobs and creating scheduler in Tivoli is required.

  Writing/Debugging Complex SQL, stored procedures and experience around
issues with DB2 is required.

 

 

Thanks and Regards, 

 

Amrutha 

Aim Computer Consulting 

N. Laurel Park Drive,

Suite #513, 

Livonia, MI-48152

734-591-3562 Extn.1+167

Fax: 7344182598

 <mailto:amru...@aim-cc.com> amru...@aim-cc.com

 <http://www.aim-cc.com/> www.aim-cc.com

Note: This is not an unsolicited mail. If you are not interested in
receiving our e-mails then please click "Remove"

scan0008"Arise, shine." Isaiah 60:1

"WITH GOD ALL THINGS ARE POSSIBLE" Mathew 19:26

 

-- 
You received this message because you are subscribed to the Google Groups "SAP 
Workflow" group.
To post to this group, send email to sap-workf...@googlegroups.com.
To unsubscribe from this group, send email to 
sap-workflow+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sap-workflow?hl=en.

<<image001.jpg>>

Reply via email to