I Supervised a team of 8 persons ( scheduling and assigning tasks) and provided them technical Translating business visions and needs into technical documentations Modification of ETL process with Datastage 7.5:ETL development, Merge stage, Data comparisons,Īnalysis of Asset management investment funds in terms of inventories, cash flow. Integration/Extraction of many jobs in parallel. Metadata collection/maintenance/deployment.Īutomation of Oracle PL/SQL procedures/Functions. Implementation of exception handling mechanism. Loading data in staging area and feeding the datawarehouse & The DataMart.

ERD Design with Erwin and implementation.ģ0% of my role was to do the analysis of varied sources of data, determining extraction methodologiesĪnd loading to operational data models & data marts.įor the rest I performed the following: Jobs/mapping, Jobs execution, Jobs scheduling. Technical Specifications documents creation. Rows…Control of performance and storage volume. Implementing control tables/dashboard to trace files loading/rejected Feeding hundreds of tables in the Data warehouse via Oracleġ1g Plsql packages and ETL jobs. Dimensions and facts Tables creation in a star schemas datawarehouseĪrchitecture. Responsible of feeding the staging area and the Datawarehouse. I also performed some index Schrinking and used Plsql hints.

I maintained and support the application on a daily basis. I put in place a real time processing which was propagating all the Oracle Plsql Procedures handles this data propagation.Īll the scripts were executed via unix shell.

Set up and deploy of a tracking system application in several environments which consists of tracing customer Environment: Database : Oracle 11g, Teradata.

Datastage 7.5 architecture diagram