The candidate should have good hands-on experience on DataStage job development and should understand ETL concepts. They should have working experience on:
· regular stages such as sequential file, Database connector, dataset, hashed file, lookup, Join, merge, filter, funnel, sort, remove duplicate, transformer, aggregator, sequences, notifications, etc.
· job parameters, parameter usage, parameter sets, environment variables etc.
· writing SQL queries