+8 years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred)
•5+ years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects
•experience in software development life cycle
•experience in DW/BI related technologies and tools - MUST
•experience in Project life cycle activities on DW/BI development and maintenance projects
•experience in Design and Architecture review
•Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs-Knowledge of data loading techniques using Datastage
•Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages etc
•Using Datastage Director for running and monitoring the jobs.
•Created Datastage sequences to run the batch jobs.
•Knowledge Best Practices in Datastage, Performance improvements, implementing CDC, UDFs