Oracle Integration & Data Engineer

Enigen; Hyderabad; Hybrid; INR 1,080,000 - 1,320,000; Full time

Benefits offered by this job

Flexible working options

Mentorship and growth

Job summary

Enigen is seeking an Oracle Integration & Data Engineer to build, extend, and support enterprise integrations in Hyderabad, adopting a hybrid work model with three days in the office. The role emphasizes OIC development and real-time data replication via GoldenGate and robust data pipelines across heterogeneous databases.

The candidate will craft event-driven workflows, ensure high availability, and optimize performance, leveraging OIC, GoldenGate, and PL/SQL within a collaborative consultancy

Qualifications

• Experience building OIC integrations with REST, SOAP, DB adapters.
• Proficient in GoldenGate extracts and replicates.
• Strong PL/SQL development and data mapping skills.

Responsibilities

• Design and maintain OIC integrations and API connections.
• Develop GoldenGate replication tasks for real-time data sync.
• Handle JSON/XML payload processing and data mapping in OIC.
• Write optimized PL/SQL for back-end integration logic.
• Monitor, troubleshoot, and optimize data replication and deployments.

Skills

OIC

Oracle GoldenGate

SQL & PL/SQL

REST/SOAP/JSON/XML

Monitoring & Troubleshooting

Tools

GGSCI/Admin Client

Oracle GoldenGate

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 (please note you must currently be based in Hyderabad)

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 12 LPA depending on experience and professional development support.

Enigen 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 strive 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.