Description
You will design and build ETL solutions supporting a data warehouse migration from on-prem (SQL Server, SSIS) to Oracle Cloud (OCI).
Responsibilities
- Design, develop, and deploy ETL processes using Oracle Data Integrator (ODI/OCI-DI).
- Implement OIC-based integrations with REST APIs, cloud, and on-prem systems.
- Develop and optimize SQL & PL/SQL scripts for transformation and performance.
- Monitor, troubleshoot, and tune ETL jobs for efficiency.
- Support migration and post-launch operations, maintaining strong documentation.
Required Skills
- 5+ years of experience in ETL Migration.
- Proficiency with Oracle Data Integrator (ODI/OCI-DI).
- Experience implementing integrations using OIC.
- Strong skills in REST API development and consumption.
- Expertise in SQL and PL/SQL scripting.
- Experience with Cloud Integration (OCI).