Oracle Database Integrator

December 11, 2025

Apply for this job

Job Description

Summary

Our client is seeking an experienced Oracle Database Integrator to design, develop, and support enterprise-wide data integration solutions. This role focuses on building scalable data flows, optimizing PL/SQL components, and ensuring secure, high-quality data movement across complex systems.

Key Responsibilities

  • Design, develop, and maintain integration solutions across enterprise applications using Oracle Database and PL/SQL.
  • Define data flows, mapping rules, and transformation logic based on business and technical requirements.
  • Build and optimize ETL pipelines, APIs, stored procedures, packages, and triggers.
  • Integrate Oracle databases with external systems using REST/SOAP services, Oracle AQ, GoldenGate, DB Links, SQL*Loader, and external tables.
  • Develop secure and scalable data ingestion, synchronization, and replication processes.
  • Implement data validation, cleansing, reconciliation, and auditing routines.
  • Troubleshoot integration failures, performance issues, and data discrepancies.
  • Collaborate with cross-functional teams to ensure alignment with integration standards.
  • Maintain comprehensive technical documentation and interface control records.
  • Support upgrades, patches, migrations, and system enhancements.
  • Perform performance tuning for SQL, PL/SQL, and data movement processes.
  • Follow DevOps, CI/CD, and version-control practices for deployment.
  • Ensure compliance with data governance, security, and regulatory requirements.

Required Qualifications

  • Extensive experience designing and developing Oracle-based integration solutions.
  • Strong expertise in PL/SQL, ETL development, APIs, and data movement processes.
  • Hands-on experience with Oracle GoldenGate, SQL*Loader, external tables, REST/SOAP services, and Oracle AQ.
  • Proven ability to troubleshoot and optimize data integrations and performance issues.
  • Experience supporting on-prem and cloud-based integration environments.
  • Strong understanding of data integrity, validation, reconciliation, and auditing processes.
  • Familiarity with DevOps and CI/CD deployment practices.
  • Must have Oracle Data Integrator (ODI) Certification.

Tech Stack

Oracle Database, PL/SQL, Oracle Data Integrator (ODI), Oracle GoldenGate, SQL*Loader, REST/SOAP APIs, Oracle AQ, DB Links, ETL pipelines, CI/CD tooling, DevOps frameworks.

Compensation & Benefits

Competitive compensation aligned with market standards.
Health benefits, PTO, remote flexibility (varies by client).

Work Schedule

Monday–Friday, flexible hours, occasional on-call (if applicable).

About the Client

Our client is a growing technology-focused organization committed to building scalable digital solutions.

Why Join the Team?

  • Opportunity to lead critical enterprise data integration initiatives.
  • Collaborative environment with strong technical and architectural teams.
  • Long-term project stability with modern integration strategies.

How to Apply

Submit your resume to people@ignitetalentpartners.com. Shortlisted candidates will be contacted.