Tagcor

Oracle

Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
Design and develop complex mappings, Process Flows and ETL scripts
Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
Experience of performance tuning of mappings
Ability to design ETL unit test cases and debug ETL Mappings
Expertise in developing Load Plans, Scheduling Jobs
Ability to design data quality and reconciliation framework using ODI
Integrate ODI with multiple Source / Target
Experience on Error recycling / management using ODI,PL/SQL
Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
Experience in SQL tuning and optimization using explain plan and Sql trace files.
Strong knowledge of ELT/ETL concepts, design and coding
Partitioning and Indexing strategy for optimal performance