Should have experience in developing ETL processesKnowledge in the Oracle ODI toolset and Oracle PL / SQL, ODIKnowledge of data modelling and ETL designSetting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etcPackaging components, database operations like Aggregate pivot, union etc.Using ODI mappings, error handling, automation using ODI, Migration of ObjectsDesign and develop complex mappings, Process Flows and ETL scriptsMust be well versed and hands-on in using and customizing Knowledge Modules (KM)Expertise in developing Load Plans, Scheduling JobsAbility to design data quality and reconciliation framework using ODIIntegrate ODI with multiple Source / TargetExperience on Error recycling / management using ODI, PL / SQLExpertise in database development (SQL / PLSQL) for PL / SQL based applications.Strong knowledge of ELT / ETL concepts, design and codingMust have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.Ability to work with minimal guidance or supervision in a time critical environment.Skills Required
Etl Design, Mappings, Plsql, Odi, Pl