Oracle Integration Consultant

Role Details

• Experience: 5+ Years
  

• Location: Pune (Preferred)/ Bangalore /Remote
  

• Work Mode: Hybrid
  

• Shift: UK Hours
  

• Contract Duration: 6 Months
  

• Budget: INR 250k per month
  

• Joining: Immediate Joiners Only
  

Role Overview

We are seeking a Senior Oracle Integration Consultant with strong expertise in data integration, Python, REST APIs, PL/SQL, and Kafka (mandatory).

This role focuses on building scalable, enterprise-grade integration solutions within Oracle ecosystems. The ideal candidate should have hands-on experience in event-driven architectures, API-based integrations, and data transformation frameworks, along with strong Oracle database capabilities.

Key Responsibilities

Data Integration & Architecture (Core Focus)

• Design and implement data integration solutions across multiple enterprise systems.
  

• Build scalable and efficient data pipelines and transformation frameworks.
  

• Work on event-driven architectures using Kafka.
  

• Ensure high performance, reliability, and scalability of integration systems.
  

Python & API Development

• Develop and maintain Python-based integration components.
  

• Build and consume REST APIs for system-to-system communication.
  

• Handle data transformation, validation, and orchestration logic using Python.
  

Database & Backend Development

• Develop complex logic using PL/SQL (procedures, functions, packages).
  

• Work on data modeling and database optimization.
  

• Perform data extraction, transformation, and loading processes.
  

Integration & Collaboration

• Integrate Oracle systems with external applications using APIs and messaging systems.
  

• Collaborate with functional and technical teams to design end-to-end solutions.
  

• Participate in architecture discussions, estimations, and solution design.
  

Delivery & Governance

• Follow Agile SDLC practices.
  

• Maintain code using GIT and standard version control practices.
  

• Ensure adherence to data security, governance, and compliance standards.
  

• Prepare technical documentation and integration design artifacts.
  

Required Skills & Experience

Mandatory Skills

✔ Strong experience in Data Integration

✔ Hands-on expertise in Python (integration & transformation)

✔ Strong knowledge of REST APIs

✔ Strong experience in PL/SQL

✔ Hands-on experience with Kafka (mandatory)

✔ Understanding of event-driven architecture

✔ Experience working in Oracle ecosystem environments

Good to Have

• Experience with Oracle EPM Planning / Essbase
  

• Exposure to Oracle Analytics tools (OAC / OBIEE / ODI)
  

• Experience with OCI (Oracle Cloud Infrastructure)
  

Soft Skills

• Strong communication and stakeholder interaction skills
  

• Ability to design scalable integration solutions
  

• Strong analytical and problem-solving mindset
  

• Ability to work independently and in team environments
  

Key Clarification

? Primary Focus: Python + Kafka + PL/SQL + Data Integration

? Secondary: REST APIs & Oracle ecosystem

? Good to Have: EPM