Principal Consultant - ODI

Oracle; Chennai District; On-site; INR 1,500,000 - 2,000,000; Full time

Benefits offered by this job

Competitive benefits including medical, life insurance, and retirement options

Opportunities for community volunteering

Job summary

A leading global technology company is seeking a Senior ODI Developer in Chennai. This role requires deep expertise in Oracle Data Integrator (ODI) and strong SQL/PL/SQL skills for designing ETL processes on Oracle Cloud Infrastructure (OCI). Candidates should have over 10 years of experience, especially in banking or insurance projects. The position involves collaborating with data architects to implement cloud-based solutions that meet business needs. Join a team committed to inclusivity and flexible work-life balance.

Qualifications

• 10+ years of experience in ODI development.
• At least 2 years of experience in OCI-based projects.
• Experience in banking or insurance domains is a significant advantage.

Responsibilities

• Design, develop, and deploy ETL processes using ODI on OCI.
• Configure and manage ODI instances on OCI.
• Develop and optimize complex SQL and PL/SQL scripts.
• Implement data integration solutions connecting diverse data sources.
• Monitor and troubleshoot ODI jobs on OCI.
• Collaborate with data architects and business analysts.

Skills

Oracle Data Integrator (ODI)

SQL

PL/SQL

ETL processes

Cloud data integration

Problem-solving skills

Communication

Agile methodologies

Education

Bachelor’s degree in Computer Science, Information Technology, or related field

Tools

Oracle Cloud Infrastructure (OCI)

Autonomous Database

Object Storage

Compute services

Job description

Senior ODI Developer (OCI PaaS/IaaS Expertise)

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 Oracle Cloud Infrastructure (OCI) 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.

Skills and Qualifications

• Mandatory Skills:
  • Oracle Data Integrator (ODI) development and administration.
  • Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
  • Experience deploying and managing ODI solutions on OCI PaaS/IaaS environments.
  • Deep understanding of ETL processes, data warehousing concepts, and cloud data integration.
• Preferred Experience:
  • Hands‑on experience in banking or insurance domain projects, with knowledge of domain‑specific data structures.
  • Familiarity with OCI services like Autonomous Database, Object Storage, Compute, and Networking.
  • Experience integrating on‑premise and cloud‑based data sources.
• Other Skills:
  • Strong problem‑solving and debugging skills.
  • Excellent communication and teamwork abilities.
  • Knowledge of Agile methodologies and cloud‑based DevOps practices.

Education and Experience

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 10+ years of experience in ODI development, with at least 2 years in OCI‑based projects.
• Domain experience in banking or insurance is an added advantage.

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 such as 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.

Career Level

IC3

Seniority Level

Mid–Senior level

Employment Type

Full‑time

Job Function

Consulting

Companies

Oracle

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity. We’re committed to growing an inclusive workforce that promotes opportunities for all. Oracle careers open the door to global opportunities where work‑life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We’re committed to including people with disabilities at all stages of the employment process.

Equal Employment Opportunity Statement

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.