Description

You will build and maintain data integration pipelines using ETL methodologies.

Responsibilities

• Design, develop, and deploy ETL processes using Oracle Data Integrator (ODI) and OCI-DI.
• Implement data integration solutions using OIC, connecting diverse data 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.
• Assist with migrating on-premises ETL solutions to cloud-based platforms.
• Monitor and troubleshoot ODI jobs, tuning ETL processes, SQL queries, and PL/SQL procedures.

Required Skills

• 6+ years of related experience.
• 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.
• Strong problem-solving and debugging skills.

Key Skills

Education

Any Graduate