Career Details

Job Description

Description:

Datastage Lead

Position Description
Datastage Dev:
1) Minimum 8 years of experience in Designing and development on Datastage (8.5/ 11.x)
2) Expertise in Data Warehousing ETL Tool DataStage using Components like DataStage Designer; DataStage Director and DataStage Operations Console.
3) Strong understanding of Data warehousing concepts; dimensional Star Schema and Snowflakes Schema methodology.
4) Expertise in designing DataStage Server jobs; Parallel Jobs; Job Sequencing; Creating Parameter Sets; Container; Environment Variables and Creating Parallel Routines; Data Cleansing and Writing Transformation expressions to derive values and remove unwanted data.Also should have good working knowledge in difeerent stages like Transformer; look up; merge stage; ODBC connector; Oracle connector etc.
5) In depth experience in troubleshooting of Datastage jobs and addressing issues like performance tuning.
6) Efficient in all phases of the development lifecycle; coherent with Data Cleansing; Data Conversion; Performance Tuning and System Testing.
7) Should have strong analytic and problem solving skills.
8) Good to have Unix shell script knowledge
9) Good communication skills
10) Good team player and co-ordinate with multiple teams
11) knowledge of ICP4D will be an added advantage

Key Responsibilities
1) Translate requirements and data mapping documents to technical design.
2) Develop; enhance; and maintain code following best practices and standards.
3) Create and execute unit test plans. Support regression and system testing efforts.
4) Debug and problem solve issues found during testing and/or production.
5) Communicate status; issues; and blockers with the project team.
6) Support continuous improvement by identifying and solving opportunities.

Skills:

• DataStage - 7 year(s)
• ETL - 7 year(s)
• Shell Script - 5 year(s)
• Unix - 5 year(s)
• Snowflake - 4 year(s)