- Minimum 8+ years of experience in Designing and
development on DataStage
- Expertise in Data Warehousing ETL Tool DataStage using
Components like DataStage Designer, DataStage Director and DataStage
Operations Console.
- Strong understanding of Data warehousing concepts,
dimensional Star Schema and Snowflakes Schema methodology.
- 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 different stages like
Transformer, look up, merge stage, ODBC connector, Oracle connector etc.
Having good knowledge on Teradata Fast Load, Teradata Multiload,
Teradata TPump