Must Be Local to these locations as to work onsite with client
Tampa FL
Coppell TX
Jersey City NJ
Position Overview We are seeking a seasoned Oracle ETL Developer to join our team and support the migration of our IT portfolio data warehouse from on-premises (SQL Server SSIS) to Oracle Cloud. This role will focus on designing developing and optimizing integrations ensuring seamless replication of existing business logic and data addition you will provide ongoing support post-launch to maintain performance and reliability of the data warehouse environment.
Key Responsibilities
- Design develop and deploy ETL processes using Oracle Data Integrator (ODI) and OCI-DI.
- Implement integration solutions with OIC connecting cloud and on-prem systems via databases REST APIs and flat files.
- Write and optimize SQL and PL/SQL scripts for data extraction transformation and loading.
- Contribute to the migration of legacy ETL processes from on-premises platforms to Oracle Cloud.
- Monitor troubleshoot and tune ODI jobs SQL queries and PL/SQL procedures for performance optimization.
- Prepare and maintain clear technical documentation for developed processes and solutions.
Qualifications - 6 years of hands-on ETL development experience.
- Bachelors degree in Computer Science Information Systems or equivalent work experience.
- Proven expertise in Oracle Data Integrator (ODI) development and administration.
- Strong proficiency in SQL and PL/SQL including advanced data manipulation and query optimization.
- Experience deploying and managing ETL solutions in OCI PaaS/IaaS environments.
- Solid understanding of data warehousing concepts and cloud-based integration practices.
- Background in integrating both on-premises and cloud data sources.
- Excellent analytical problem-solving and debugging skills.
- Strong communication and collaboration abilities.
If you are interested or have any references please share resume at