Oracle Data Integrator (ODI) Developer with Oracle GoldenGate

Oracle Data Integrator (ODI) Developer

Oracle GoldenGate

Key Responsibilities

• Design, develop, and implement data integration solutions using ODI and Oracle GoldenGate.
• Build and maintain ETL processes for data migration, transformation, and integration.
• Design real-time data replication setups using GoldenGate across heterogeneous systems.
• Optimize and troubleshoot data pipelines for maximum performance and reliability.
• Collaborate with cross-functional teams to translate business needs into technical solutions.
• Coordinate with DBAs and infrastructure teams to ensure smooth integration and system performance.
• Manage data warehousing, synchronization, and migration tasks, ensuring data integrity.
• Support GoldenGate replication for high availability, disaster recovery, and data synchronization.
• Ensure the scalability, performance, and security of integration configurations.
• Develop technical documentation and provide training on ODI and GoldenGate processes.
• Support production environments and troubleshoot data integration issues as needed.
  

Required Skills And Qualifications

• 5+ years of hands-on experience in ODI development and implementation.
• Proven expertise in Oracle GoldenGate including real-time replication and conflict resolution.
• Strong command of SQL, PL/SQL, and scripting for data manipulation.
• Solid understanding of data modeling, ETL architecture, and multi-system integration.
• Familiarity with Oracle databases and data warehousing concepts.
• Experience with ODI components such as Interfaces, Mappings, Packages, and Procedures.
• Proficient in configuring GoldenGate for high availability and disaster recovery.
• Excellent troubleshooting and optimization skills for data pipelines.
• Experience handling complex data migration and synchronization tasks.
• Ability to thrive in a fast-paced, client-facing environment.
  

Preferred Skills

• Familiarity with other ETL tools (e.g., Informatica, Talend).
• Knowledge of Oracle Cloud Infrastructure (OCI) or other cloud platforms.
• Certifications in ODI, GoldenGate, or other Oracle technologies.
• Experience with performance tuning in large-scale data integration projects.
  

Educational Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Relevant Oracle certifications (ODI, GoldenGate) are a plus.