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