LOCALC HIGHLY PREFERED
Looking for a Datastage Architect with hands on experience with development. Chicago, IL 3-6 Month contract Healthcare experience is a huge plus Will pay for experienced consultants $60/hr CTC 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: Thanks, Pavan Ling Technologies, Inc. I 9161 Liberia Ave, Suite 200 Manassas, VA 20110 Work: 703-880-2640 Extn: 4022 I Fax Toll Free 866-473-6904 I [email protected] I www.ling-tech.com <blocked::http://www.ling-tech.com/> I P Please consider the environment before printing this e-mail. Note: If you are not interested in receiving our e-mails, please reply with "REMOVE" in subject. We apologize for any inconvenience -- You received this message because you are subscribed to the Google Groups "Business Objects User Group" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/businessobjects?hl=en.
