ODI Developer

Job Description

3 - 5 years of demonstrable hands-on development experience using standard SDLC and/or Agile in an ODI/PLQL developer role. Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, Mat Views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in Oracle. 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. Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI Knowledge of data modelling and ETL design Integrate ODI with multiple Source and Targets. Experience on Error recycling / management using ODI, PL/SQL Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. Strong knowledge of ELT/ETL concepts, design, and coding Partitioning and Indexing strategy for optimal performance Experience in leading support & development projects Must have Good verbal and written communication in English, Strong interpersonal, analytical, and problem-solving abilities