Hi ,
Position: IBM Sr. Datastage Developer Location: Downers Grove, IL Length: 4-months w/option for additional time Start Date: ASAP *Overview:* Consultant will be responsible for providing design and development ETL Code utilizing the IBM Information Server Datastage V8.0. The Sr. Developer in addition, the Lead needs to be able to assist in leading and managing the developers and also help the PM in orchestrating the ETL work in concert with the other development activities that occurring on this effort. *Role/Responsibilities: * *1. **Must have 7-10+ yrs of Data Mapping of data sources using Data Stage 8.x with parallel processing to develop ETL code including:* *a. **Must have strong SQL understand join, groups, function, partition ( preferably with DB2 UDB 9.6 or 9.7)* b. Test and fix code per Unit, System Integration, Performance * i. **Experience in creating Technical Design & Implementing ELT solution for multi-terabyte Data Warehouse and understand its impacts.* *1. **Logical descriptions of the extract, transform, and load process * *2. **ETL Detailed Design* *3. **Input and output record layouts * *4. **File/Directory naming conventions * *5. **File/table sizing information* *6. **File/table volume information * *7. **File retention/archival information* * ii. **Performance tuning of ETL jobs * * iii. **Experience working with flat files, running ELT jobs concurrently.* * iv. **Data standards and metadata management SQL Standards / Processes/Tools * * v. **ETL Development, monitoring, reporting and metrics* c. Familiar with data warehousing architectures d. Cube consolidation 2. Should have experience in the defining ETL standards & processes 3. Must have previous exp interfacing & working with users to discuss requirements 4. Must be able to interface effectively with all levels of the organization. 5. Must have excellent interpersonal skills and be strong and effective communicator 6. Good writing skills and ability to multi task in the support of this project *Thanks & Regards* *Sudheer * *Oberon IT, Inc * *Email: [email protected]* *Phone # 972- 432- 6537 * *Fax: 800 218 2820* *YM: [email protected]* *GM:[email protected]*** -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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/us_itgroups?hl=en.
