Job Description :
Job Title: ETL DataStage consultant

Location: Cincinnati ,OH

Duration : 6 Months



Description:

Individual must be able to effectively communicate with onshore, offshore, client team, client management and stake holder involved. Strong Communication and interpersonal skills is a must.
Experienced in onshore/offshore project execution, specialized in onshore/offshore delivery/service management and past experience with managing onshore/offshore team and should have client escalation management capacity.
Good experience on Onsite and offshore co-ordination and Handling big ETL teams.
The individual should be able to prioritize work based on demand and provide guidance to other staff.
Ability to conduct design review session with different stake holders.
Experienced in techno functional role.
Good presentation skills
Skilled in Estimation, planning, coordination, and execution of system applications and engineering projects, deployment release/deployment management
Must be expertise in DataStage for Data warehouse in the area of ETL design, implementation, deploying.
In Depth Experience in DB2, write complex SQL, stored procedures, tuning rogue ETL jobs, development of UNIX shell scripts for enhancing the ETL job performance.
He will be responsible of development, technical lead working within team or communicating with other stakeholders supporting deployments, code reviews, and technical Design & documentation.


Required Skills

Proven track record in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
Should have experience in Datastage 8.1 and 8.5, 9.1 hands on experience with Complex Datastage ETL delivery Data warehouse/Data Marts.
Strong Dev experience in understanding Mapping document and convert in to technical job design.
Experience integrating the components of the following DB2, Tivoli and Data Stage (ETL
Strong understanding of Datawarehouse concepts, schemas, Slowly Changing Dimensions, Facts and Dimensions.
Extensive experience in Designing and Debugging both Server and Parallel Jobs and also Job Sequencers.
Provide support and guidance by creating Release, Deployment & Operation guide documents.
Strong writing and documentation skills for the management, development and control of documentation.
Experience in creating Technical Design & Implementing ELT solution for multi-terabyte Data Warehouse and understand its impacts.


Desired/Nice to Have Skills

Mainframe work experience
ETL IBM Datastage Migration and BMC Remedy tool hands on.

Client : slk