Job Title: :Oracle Data Integration Consultant
Exp range: 6+ Years
Location: PAN India
Availability: Immediate to 20 days only
Budget: 21-22 LPA max
At least 6+ 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
·Must have Good verbal and written communication in English, Strong interpersonal, analytical, and problem-solving abilities