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