Etl Lead

Role & responsibilities

6+ years ETL Lead / developer experience and a minimum of 3-4 Years experience in Oracle Data Integrator (ODI)

• Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI
• Minimum 2-3 end to end DWH Implementation experience.
• Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.
• knowledge of ODI Master and work repository
• Knowledge of data modelling and ETL design
• Design and develop complex mappings, Process Flows and ETL scripts
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, Agents etc.
• Packaging components, database operations like Aggregate pivot, union 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
• Integrate ODI with multiple Source / Target
• Experience in Data Migration using SQL loader, import/export
  Consulting Requirements

Preferred candidate profile