Description

Design, develop, and maintain ETL processes using IBM DataStage.

Responsibilities

• Translate data mapping documents and requirements into technical designs.
• Build DataStage Server jobs, Parallel Jobs, and job sequences.
• Implement data cleansing and transformation expressions to derive values and remove unwanted data.
• Create unit test plans and support regression and system testing efforts.

Required Skills

• 8+ years of experience in DataStage design and development.
• Expertise in DataStage Designer, Director, and Operations Console.
• Proficiency with Transformer, Lookup, Merge, ODBC, and Oracle connectors.
• Deep understanding of Data Warehousing, Star Schema, and Snowflake Schema methodologies.
• Experience creating Parameter Sets, Containers, Environment Variables, and Parallel Routines.
• Hands-on experience with ETL DataStage, RDM, Teradata, Oracle, and Big Data.
• Bachelor's degree or any graduate degree.

Key Skills

Education

Any Graduate