~~ Technical Recruiters Network ~~ Urgent Need: DataStage Architect, IL

Hi Friends,

Warm Greetings!

Let me know if you have someone for the below position.

 

Position: DataStage Architect

Location: Chicago, IL

Duration: 3-6 Months

Rate: DOE

Interview: Immediate

 

Healthcare experience is a huge plus

Data warehouse ETL Developer

 

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

• Minimum of 12-9 years of IT work experience focused in Data Acquisition and Data Integration using DataStage 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

 

Deliverable:

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.

 

Preferred Qualifications:

- Working experience in a Healthcare industry.

Java, J2EE background experience is good to have. Deliverable:• 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 Dress Codes:

 

 

 

Regards,

 

Anju

Palette IT Solutions Inc.

Email Id: anju@paletteitsolutions.com

--
You received this message because you are subscribed to the Google
Groups "Tech_Recruiters" group.
To post to this group, send email to tech_recruiters@googlegroups.com
To unsubscribe from this group, send email to
tech_recruiters+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tech_recruiters?hl=en
 
Get Paid To Read Emails. Free To Join Now!
http://www.emailcashpro.com/?r=antonynj