Having total experience is 10.3 years on ETL Tool "Datastage" in Data Warehousing Technologies in MNCs. Relevant 6.5 years on ETL tool Data Stage in Development for Extract, Transform and Loading data into DWH tables and 3.10 years on ETL & Reporting tools Data Stage & Business Objects in Production support for Loading the data into DWH tables and Generate reports and provide the End user support.
The followed process of customer and company while building the code and delivered within timelines.
Prepared detailed design technical document to build the data stage jobs.
Involved and created ETL jobs for data Extract, Transform and Load into DWH tables.
Applied transformation/business rules while transforming data then loaded into files & tables.
Designed the code to load the data into dimension tables first then loaded data into fact tables.
Transferred target files to server locations to consume data by next level based on dependency.
Rejection reprocess loading done on weekly and aggregate tables loading done on monthly.
Loaded data into DWH tables and refreshed reports, provided query reports on a daily basis.
Given end-user support to analyse the reports by providing the required information.
Had a good understanding of Software Development Life Cycle (SDLC) & Data Ware Housing Life Cycle (DWHLC), Data Modeling.
Certified on IBM Certified Solution Developer Infosphere Datastage.