Oracle Integration Consultant

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 .