• 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