RE: Need Lead Datastage Architect in Irvine CA

HI All,

 

Duration : 12 Months

 

Job Description:

General Technical Skills

·          Hands-on experience with ETL development for Data Warehousing and Data Integration projects

·           Solid analytical skills, detail and process-oriented

·          Exceptionally good in handling problem and troubleshooting under pressure

DataStage Skills

·         Proven knowledge and experience with ETL design and development using DataStage Server and Parallel jobs

·         Experience in expanding DataStage capabilities by incorporating Unix or SQL script into ETL jobs

·         Experience in ETL job troubleshooting and performance tuning

·         Proficient in writing Complex SQL statements including DML/DDL statements, analytic SQL, set-based sub-queries

·         In-depth knowledge of SQL tuning techniques such as execution plan, join order, indexing and hint, etc

·         Experience with PL/SQL programs Sequence, function and procedure, etc

·         Familiar with Oracle 10g or 11g environments and 'TOAD/Oracle PL-SQL Builder for Oracle' user interface

Unix Shell Scripting Skills

·         Experience in writing Unix shell scripts to manage files and manipulate data in the file

·         Execute ETL jobs or SQL scripts using shell scripts

 

 

 

 

 

Thanks & Regards

 

Nitin Verma

 

Pyramid Consulting, Inc.

nitin.verma@pyramidci.com

office: 770-255-3146  /cell: 404-891-0461 / fax: 678-935-1353

 

 

http://www.pyramidci.com DISCLAIMERThe information in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorized. If you have received this communication in error, please notify the sender and delete the e-mail and destroy any copies of it. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any opinions or advice contained in this e-mail are subject to the terms and conditions expressed in the governing PYRAMID client engagement letter. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the firm are neither given nor endorsed by it.