Oracle Integration Consultant

Talpro; Pune District; On-site; INR 2,678,000 - 2,902,000; Full time

Job summary

Talpro is seeking a Senior Oracle Integration Consultant to design and implement data integration solutions within Oracle ecosystems. You will work on event-driven architectures, API-based integrations, and data transformation using Python, REST APIs, and PL/SQL.

This hybrid role in India requires 5+ years of experience, Kafka expertise, and collaboration with cross-functional teams to deliver scalable, enterprise-grade integrations.

Qualifications

• Strong experience in data integration across enterprise systems.
• Hands-on Python for integration & transformation tasks.
• Experience building and consuming REST APIs for system-to-system communication.
• Proficient in PL/SQL procedures, functions and packages.
• Hands-on Kafka experience is mandatory.
• Understanding of event-driven architectures and data modeling in Oracle environments.

Responsibilities

• Design and implement data integration solutions across multiple enterprise systems.
• Build scalable data pipelines and transformation frameworks.
• Work on event-driven architectures using Kafka.
• Ensure high performance, reliability, and scalability of integration systems.
• Develop Python-based integration components and REST API interfaces.
• Handle data extraction, transformation, and loading processes.

Skills

Data Integration

Python

REST APIs

PL/SQL

Kafka

Event-driven architecture

Oracle ecosystem

Job description

Talpro is leading the way in transforming the talent acquisition landscape. We deliver innovative, sustainable, and cost-effective recruitment solutions tailored to today’s business needs. Our mission is to offer comprehensive hiring strategies that address immediate recruitment demands while laying the groundwork for long-term success.

Job Description

Oracle Integration Consultant

Experience: 5+ Years

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.

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

Work on data modeling and database optimization.

Perform data extraction, transformation, and loading processes.

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