This project extract data from various data supplier databases and does client specific transformation using Data Stage after which the data is loaded into the target DWH. Migration of all the DataStage projects from lower version 9.1 to higher version v11.7.

This project have a different data area like Copy, Common Integration Layer(CLI) and data presentation Layer(DPL) and finally Data mart. Here copy area is the Staging area and source for the remaining areas. In Staging area we will extract the records and perform various transformation and will load it into 2 Databases(Staging and History).

I have 2+ years of hands on experience as a ETL Developer using the IBM Datastage ETL tool.
Experience in Designing Jobs based on buisness requirements and optimising the performence of Datastage jobs.
Experience in Migration of Datastage projects from lower version to higher version v9.1 to v11.7.
Proficient knowledge in SQL queries and basics of Unix commands.
Worked in multiple projects on performance optimization.
Worked in different methodologies of delivery like Agile and Waterfall delivery.
Worked on various stages like Lookup, Aggregator, Join, Merge, Change Capture, Filter, Flat Files , SQL,Oracle, DB2 during the implementation of job design.
Took initiative to Automate the ETL jobs using VBA tool and got good appreciation from clients towards process improvement.
Creating Packages and buiding packages using IBM Information server manager tool.
Coordinate with Business Partners, Technical Analysts and Developers to identify and define specifications indicate areas of system impact and continuously communicate project status and needs.
Excellent problem solving skills and analytical skills.
Knowledge of Banking domain.

Strong track record of interviewing business partners, setting and managing expectations in relation to deliverables and requirements.

Solid understanding of software project life cycle and associated methodologies.

Experience with standard systems analysis tools and procedures.

Ability to prioritize and handle multiple projects.