Datastage Developer

Band – 3- 5 yrs

no of Positions : 6

JD – 3+years of Experience Primary Skills: DataStage v8.x, DataStage v9.x, DataStage v11.x, Databases, SQL, Basic Unix Commands Secondary Skills: PL/SQL, Unix scripting, shell scripting, DB2, Dataware housing concepts, ETL Tools, Informatica, C++, Java, Control M, TSM, Unix scheduler Long Description 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, data set, 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 · peer review of datastage jobs, writing unit test cases, unit testing, · debugging jobs · tool components datastage designer, director · basic unix commands · tools such as putty, Winscp,etc. The candidate should understand data warehousing concepts like SCDs, data mart, staging area, Dimension and Fact tables. Candidate should be able to work on mapping sheets, and convert mapping sheet logic to Data Stage job design. Good communication skills is a pre-requisite

Fields with (*) are compulsory.