Oracle Data Integration Specialist

Experience: 7+ Years

Job Description:

• Design, develop, and implement data integration solutions using Oracle technologies.
• Build and maintain ETL/ELT processes to integrate data from multiple source systems into centralized databases and data warehouses.
• Develop and optimize data pipelines for high performance, scalability, and reliability.
• Ensure data quality, consistency, integrity, and governance across integrated systems.
• Work with Oracle databases, Oracle Data Integrator (ODI), Oracle GoldenGate, and related integration tools.
• Perform data mapping, transformation, validation, and reconciliation activities.
• Collaborate with business, application, and data architecture teams to understand integration requirements.
• Monitor, troubleshoot, and resolve data integration and performance issues.
• Support data migration, database upgrades, and system integration projects.
• Create and maintain technical documentation, ETL workflows, and integration standards.
• Ensure compliance with security, privacy, and organizational data governance policies.

Required Skills:

• Strong experience with

Oracle Data Integrator (ODI) .

• Hands-on experience with

Oracle Database , SQL, and PL/SQL.

• Experience with

Oracle GoldenGate for real-time data replication.

• Strong knowledge of ETL/ELT development and Data Warehousing concepts.
• Experience in data modeling, data transformation, and data validation.
• Good understanding of performance tuning for Oracle databases and ETL processes.
• Experience with Linux/Unix environments.
• Knowledge of Oracle Cloud Infrastructure (OCI) or cloud-based integration platforms is preferred.
• Strong analytical, troubleshooting, and communication skills.

Preferred Skills:

• Oracle Autonomous Database
• Oracle Data Pump
• Oracle Warehouse Builder (OWB)
• Oracle Integration Cloud (OIC)
• Oracle Analytics Cloud (OAC)
• REST/SOAP APIs
• Shell/Python scripting
• Git and CI/CD tools
• Data Governance and Master Data Management (MDM)

Preferred Certifications:

• Oracle Certified Professional (OCP) – Oracle Database
• Oracle Data Integrator (ODI) Certification
• Oracle Cloud Infrastructure (OCI) Certification
• Oracle Integration Cloud (OIC) Certification
• ITIL Foundation (Preferred)

Mandatory Skills:

• Oracle Data Integrator (ODI)
• Oracle Database
• SQL
• PL/SQL
• Oracle GoldenGate
• ETL/ELT Development
• Data Warehousing
• Data Mapping & Transformation
• Performance Tuning
• Linux/Unix

Good to have skills:

• Oracle Integration Cloud (OIC)
• Oracle Analytics Cloud (OAC)
• Oracle Autonomous Database
• Oracle Data Pump
• REST/SOAP APIs
• Python/Shell Scripting
• Git
• CI/CD
• Data Governance
• Master Data Management (MDM)