1) Loading of data from source file to OCDM staging layer and then from Staging layer to Foundation & ODS Layer after applying transformation rule as per company policy.
2) Creation of Interface, Procedures and Packages by using ODI
3) Load Plan for Hourly, Daily, Weekly and Monthly ETL-Batches by using ODI.
4) Remove the Manual File processing work and automate it to run the batch without Human interaction.
5) Trouble Shooting in case of Errors during Data Loading.
6) Participated in query & database customization and optimization with DBA