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.