Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Oracle

Compare

3.7

based on 5.1k Reviews

1388 Oracle Jobs

Principal Consultant

Oracle India Pvt. Ltd.

3.7

based on 5.1k Reviews

5-8 years

Bangalore / Bengaluru

1 vacancy

Principal Consultant

Oracle

posted 1hr ago

Job Role Insights

Flexible timing

Key skills for the job

Computer Networking Information Technology PLSQL Agile Coaching Data Structures and Algorithms Data Security

+ 3 more

Job Description

Senior ODI Developer (OCI PaaS/IaaS Expertise)

Role Overview:

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:

Mandatory Skills:
- Strong hands-on experience with 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 in 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.
5 to 8 years of experience in ODI development, with at least 2 years of experience in OCI-based projects.
Domain experience in banking or insurance is an added 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.

Employment Type: Full Time, Permanent

Read full job description

Oracle Interview Questions & Tips

Prepare for Oracle Principal Consultant roles with real interview advice

What people at Oracle are saying

3.9

Rating based on 123 Principal Consultant reviews

Anonymous · Consulting in Bangalore / Bengaluru

Likes

Job security is there if you know your job. But if you are from India be prepared to be bashed by the Americans. Even if you give your best & take all the heavy lifting, if a small thing goes wrong, that too for no fault of yours, you would still be blamed without any second thought or investigation into the matter. Particularly ther..Read More

Dislikes

India is still a 3rd world country sadly. And just to save your job, your family, you aged mom & dad you need to accept anything & everything that Americans does. Its a favour that they are doing by providing us job :) We need to provide our children with the best possible knowledge & above all a strong spine so that they do not have to go through the same situation when they grow up.