Oracle

Senior Consultant

Job Description

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.
  • 4 to 6 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.

 

Career Level - IC2


Jobs at Bengaluru

Amazon

Business Analyst, RBS

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: June 24, 2025

Amazon

Program Manager , RCO Global Adviso…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: June 24, 2025

Amazon

Software Dev Engineer II, Cross Bor…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: July 1, 2025

Oracle

Software Developer 3

Professional

Bengaluru, Karnataka

View Details

Last Date: Aug. 3, 2025

Oracle

Technical Enterprise Architect – Di…

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 25, 2025

Oracle

Credit & Collections Analyst 2-Fin

Professional

Bengaluru, Karnataka

View Details

Last Date: Nov. 18, 2025

Oracle

Support Analyst

Professional

Bengaluru, Karnataka

View Details

Last Date: July 7, 2025

Amazon

Technical Program Manager III, Inte…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: July 1, 2025

Oracle

Software Developer 3

Professional

Bengaluru, Karnataka

View Details

Last Date: Sept. 9, 2025

Oracle

Oracle Fusion Financials Techno Fun…

Professional

Bengaluru, Karnataka

View Details

Last Date: Aug. 31, 2025

Amazon

Support Engineer , Payment Services

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: July 1, 2025

Oracle

Applications Developer

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 29, 2025




More Jobs at Oracle

Oracle

Oracle Application Lead (Oracle PLS…

Professional

Bengaluru, Karnataka

View Details

Last Date: June 24, 2025

Oracle

Program Manager 3-ProdDev

Professional

Bengaluru, Karnataka

View Details

Last Date: July 11, 2025

Oracle

Applications Developer 3

Professional

Hyderabad, Telangana

View Details

Last Date: July 1, 2025

Oracle

Principal Software Developer

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 20, 2025

Oracle

Snr Oracle Apps Technical - EBS Fin…

Professional

Hyderabad, Telangana

View Details

Last Date: July 21, 2025

Oracle

Principal/Member of Technical Staff…

Professional

Bengaluru, Karnataka

View Details

Last Date: Nov. 23, 2025

Oracle

Lead Analyst Collections

Professional

Bengaluru, Karnataka

View Details

Last Date: Sept. 16, 2025

Oracle

Security Analyst 2

Professional

Bengaluru, Karnataka

View Details

Last Date: July 7, 2025

Oracle

Software Development Snr Manager

Professional

Hyderabad, Telangana

View Details

Last Date: Sept. 15, 2025

Oracle

Site Reliability Developer 3

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 26, 2025

Oracle

Applications Developer 4

Professional

Hyderabad, Telangana

View Details

Last Date: July 6, 2025

Oracle

Customer Success Specialist, CSS Pl…

Professional

Bengaluru, Karnataka

View Details

Last Date: Oct. 21, 2025




Actively Recruiting Companies at Bengaluru, Karnataka