Description

Build and maintain data integration pipelines using ETL methodologies, focusing on Oracle Data Integrator (ODI) and OCI-DI.

This role is hybrid.

Responsibilities

• Design, develop, and deploy ETL processes using Oracle Data Integrator (ODI) and OCI-DI.
• Implement data integration solutions using OIC, connecting diverse sources including cloud databases, on-premises systems, REST APIs, and flat files.
• Develop and optimize SQL and PL/SQL scripts for data extraction, transformation, and loading.
• Monitor and troubleshoot ODI jobs, tuning ETL processes, SQL queries, and PL/SQL procedures.
• Assist with migrating on-premises ETL solutions to cloud-based platforms.

Required Skills

• 6+ years of related experience in ETL development.
• Strong hands-on experience with Oracle Data Integrator (ODI) development and administration.
• Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
• Experience deploying and managing ETL solutions on OCI PaaS/IaaS environments.
• Deep understanding of ETL processes and data warehousing concepts.
• Experience integrating on-premises and cloud-based data sources.
• Experience with REST APIs.

Preferred Skills

• Strong problem-solving and debugging skills.

Key Skills

Education

Any Graduate