Technical/Functional Skills • DWH support experience using ODI. • Should have experience in developing ETL processes - ETL control tables, error logging, auditing etc. Should be able to implement reusability, parameterization, workflow design, etc. • knowledge of ODI Master and work repository • 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
Experience Required • Overall experience of 8+ Years • At least 2 to 3 Implementation projects using ODI • Resource must have experience in Orace eBS knowledge • Should possess good consulting & communication skills. • Must have ODI work experience • Having OIC knowledge will have additional advantage.
Roles & Responsibilities • 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
Generic Managerial Skills • Maintain and establish effective working relationships with co-workers and other developers. • Excellent interpersonal, communication and organizational skills are essential to perform the tasks. • Good communication with team and customer • Perform a wide variety of duties and responsibilities with accuracy