Technical Analyst Oracle Data Integrator (ODI)

You will be responsible for developing/enhancing objects in Oracle Data Integrator (ODI), RPD, and OACS Reports & Analyses. Your role will involve providing end-to-end solution architecture for integrating Oracle ERP and SCM Cloud applications using ODI and OACS. You will be tasked with ODI ELT Data Load Scheduling, Monitoring, and Troubleshooting, as well as applying data fixes. Furthermore, you will need to coordinate with the onshore team by setting day-to-day execution targets. Your expertise will be crucial in integration architecture design, solutions selection, implementation, and continuous technical improvement. Collaboration with a cross-functional team to resolve issues and guide team members to successful delivery will also be part of your responsibilities. To qualify for this role, you must have at least 5 years of demonstrable hands-on development experience using standard SDLC and/or Agile methodologies in an ODI/OACS/PLSQL developer role. Additionally, you should have 5+ years of experience in extracting data from Oracle ERP/SCM. Proficiency in developing ETL processes, such as ETL control tables, error logging, auditing, data quality, etc., and implementing reusability, parameterization, workflow design, is essential. Expertise in the Oracle ODI 12c toolset, Oracle PL/SQL, RPD, OACS, BICC, BI Publisher, as well as knowledge of data modeling and ETL design, are required. You should be able to integrate ODI with multiple sources and targets and have experience in error recycling/management using ODI. Strong knowledge of database objects development (SQL/PLSQL) and ELT/ETL concepts, design, and coding is expected. Moreover, expert knowledge of OBIEE/OAC RPD design and BI analytics reports design is necessary. Familiarity with BI Apps will be an advantage. Experience in creating PL/SQL packages, procedures, functions, triggers, views, materialized views, and exception handling for retrieving, manipulating, checking, and migrating complex datasets in Oracle is crucial. Your role will also involve devising partitioning and indexing strategies for optimal performance, leading support & development projects, and possessing good verbal and written communication skills in English. Strong interpersonal, analytical, and problem-solving abilities are essential. Any certifications in ODI or OACS will be a plus. Good knowledge of Oracle database and development experience in database applications, along with traits such as creativity, personal drive, influencing and negotiating skills, and problem-solving capabilities, are desired attributes for this role.,