Datastage-ETL

Resposibilities:-
? To use DataStage 8.1 ETL tool to extract data from source systems such as Flat Files, SQL Server Database to target system
? Developing complex ETL jobs involving multiple data sources including several RDBMS tables and flat files.
? To use different transformations such as Transformer, Merge, Join, Filter, Look-up, and Aggregator to transform the data.
? To use Parameter files and variables in mappings and sessions.
? To write SQL Queries (Sub queries and Join conditions, correlated sub queries).
? To monitor production DataStage jobs and resolving the incidents and tasks as per their severities.
Comfortable to work in work in 24X7 environment on Production Support. Candidate will be on the payroll of the Company & deployed at client site.