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.