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

✔ Robust 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