Oracle Integration & Data Engineer

Enigen UK; Hyderabad; On-site; INR 1,350,000 - 1,650,000; Full time

Benefits offered by this job

Flexible working options

Mentorship

Professional development support

Job summary

Enigen UK is seeking an Oracle Integration & Data Engineer in Hyderabad to design, build, and support enterprise integrations using Oracle Integration Cloud (OIC) and real-time data replication with Oracle GoldenGate. You will connect diverse systems, translate complex business logic into efficient OIC workflows, and ensure high-availability data synchronization.

This hybrid role offers collaboration across Oracle-focused projects, competitive compensation up to 15 LPA, and opportunities for

Qualifications

• 1–3 years hands-on experience with OIC integrations using REST/SOAP adapters.
• Familiarity with GoldenGate architecture, extracts, pumps, and replicates.
• Strong SQL/PLSQL skills for data processing and mapping edge cases.
• Understanding of JSON/XML payloads and REST/SOAP endpoints.
• Experience with OIC monitoring consoles and GoldenGate tools.

Responsibilities

• Design, build, and maintain enterprise integrations within OIC.
• Configure GoldenGate replication tasks for real-time data sync.
• Handle JSON/XML payloads, data transformations, and REST/SOAP endpoints.
• Write efficient PL/SQL and SQL logic to support back-end mapping.
• Implement fault-handling, monitoring dashboards, and error queues.
• Perform unit and end-to-end integration testing and troubleshoot deployments.

Skills

OIC Integration Engineering

Oracle GoldenGate

SQL & PL/SQL

REST & SOAP

Troubleshooting & Monitoring

Tools

Oracle Integration Cloud (OIC)

Oracle GoldenGate

PL/SQL Tools

Job description

Job Title: Oracle Integration & Data Engineer

Hours: Full time (40-hours per week)

Location: Hyderabad – Hybrid 3 days a week in the office

We are looking for an Oracle Integration & Data Engineer to build, extend, and support our enterprise application integrations and real-time data replication streams. You will focus on developing custom, event-driven integrations using Oracle Integration Cloud (OIC) while designing, configuring, and maintaining robust data sync pipelines through Oracle GoldenGate.

This role is ideal for a developer who excels at connecting disparate systems, translating complex business logic into efficient OIC workflows, and ensuring high-availability, low-latency data replication across heterogeneous databases.

Enigen are a multi award winning consultancy, focused on Oracle applications and Cloud Infrastructure. We help our clients with advisory, design, implementation and support, to deliver successful change and impactful business outcomes to our customers across EMEA.

Key responsibilities include:

• OIC Integration Engineering: Design, build, and maintain enterprise application integrations, API connections, and process automations within Oracle Integration Cloud (OIC).
• GoldenGate Pipeline Development: Configure, deploy, and support Oracle GoldenGate replication tasks, extract/replicate processes, and parameter files to ensure seamless real-time data synchronization.
• API & Payload Processing: Handle complex JSON and XML payload structures, map data transformations, and construct REST/SOAP endpoints within OIC.
• Database & Integration Logic: Write clean, efficient PL/SQL and SQL logic (packages, procedures, functions) to support integration back-ends and handle data mapping edge cases.
• Data Quality & Error Handling: Implement robust fault-handling frameworks, error-queuing mechanisms, and monitoring dashboards across OIC and GoldenGate deployments.
• System Testing & Support: Conduct thorough unit and end-to-end integration testing, troubleshoot deployment failures, and optimize data replication performance.

Required Skills & Qualifications

• Oracle Integration Cloud (OIC): 1–3 years of hands-on experience building, testing, and supporting OIC integrations using standard adapters (REST, SOAP, DB, ERP) and connectivity agents.
• Oracle GoldenGate: Proven familiarity with GoldenGate architecture, setting up extracts, pump processes, and replicates for relational databases.
• SQL & PL/SQL Fundamentals: Strong skills in writing and optimizing database logic, stored procedures, and complex queries for data processing.
• Data Formats & Protocols: Solid understanding of REST/SOAP web services, JSON, XML, XSLT mappings, and HTTP request methods.
• Troubleshooting & Monitoring: Experience using OIC monitoring consoles and GoldenGate GGSCI/Admin Client tools to trace errors and resolve sync lag.

Preferred / Bonus Skills

• Familiarity with Oracle Cloud Infrastructure (OCI) services, such as OCI API Gateway or Streaming.
• Exposure to basic version control workflows (Git) for managing code deployments and PL/SQL scripts.
• Understanding of enterprise ERP/CRM systems (such as Oracle E-Business Suite or Oracle Fusion Applications).

What we offer

• A collaborative environment with opportunities for growth and mentorship.
• Involvement in innovative cloud and SaaS transformation projects.
• Flexible working options and supportive team culture.
• Competitive compensation up to 15 LPA and professional development support.

Enigen UK is an equal opportunity employer and is committed to a policy of treating all its employees and job applicants equally. We will avoid unlawful discrimination in all aspects of employment, including recruitment and selection, promotion, transfer, opportunities for training, pay and benefits, and all other terms of employment.

Enigen UK strives for an inclusive workplace where all forms of diversity are valued, including gender, race, religion, ethnicity, sexual orientation, gender identity, gender expression, age, disability, or background.