Oracle Integration & Data Engineer

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)

Industry: IT Consultancy

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.

About Enigen

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.

Seniority level: Entry level

Employment type: Full-time

Industries: IT Services and IT Consulting