Senior ODI Consultant

We are seeking a highly skilled Senior ODI Developer with strong hands-on experience in SQL, PL / SQL, and Oracle Data Integrator (ODI) projects, particularly on OCI (Oracle Cloud Infrastructure) PaaS or IaaS platforms. The ideal candidate will design, implement, and optimize ETL processes, leveraging cloud-based solutions to meet evolving business needs. Prior experience in banking or insurance projects is a significant advantage.

Key Responsibilities :

• Design, develop, and deploy ETL processes using Oracle Data Integrator (ODI) on OCI PaaS / IaaS.
• Configure and manage ODI instances on OCI, ensuring optimal performance and scalability.
• Develop and optimize complex SQL and PL / SQL scripts for data extraction, transformation, and loading.
• Implement data integration solutions, connecting diverse data sources like cloud databases, on-premise systems, APIs, and flat files.
• Monitor and troubleshoot ODI jobs running on OCI to ensure seamless data flow and resolve any issues promptly.
• Collaborate with data architects and business analysts to understand integration requirements and deliver robust solutions.
• Conduct performance tuning of ETL processes, SQL queries, and PL / SQL procedures.
• Prepare and maintain detailed technical documentation for developed solutions.
• Adhere to data security and compliance standards, particularly in cloud-based environments.
• Provide guidance and best practices for ODI and OCI-based data integration projects.

Skills and Qualifications :

Education and Experience :