Development of ELT process utilizing Oracle Data Integrator. Designing integrated process using Oracle Data Integrator(ODI) for centralizing the data, processing raw files and after applying data validation, data transformation and change data capture the processed data gets loaded into proper schemas, tables. Writing views, plsql procedures, functions, packages to manipulate the data in the desired format from the raw data loaded from flat files. Using Sql Developer for unit-testing for the self-designed modules