ETL with ODI Developer (W2)

Job Description

Role: ETL Developer

Locations: Tampa, FL | Coppel, TX | Jersey City, NJ (Onsite)

Must Have

Minimum Of 6 Years Of Related Experience

Bachelor's degree preferred or equivalent 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, data warehousing concepts, and cloud data integration.

Experience in integrating on-premise and cloud-based data sources.

Strong problem-solving and debugging skills.

Good communication and teamwork abilities.

Responsibilities

Design, develop, and deploy ETL processes Oracle Data Integrator (ODI) and OCI-DI.

Implement data integration solutions using OIC, connecting diverse data sources like 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 migration of on-premises ETL solutions to cloud-based platforms as needed.

Monitor and troubleshoot ODI jobs, performance tuning of ETL processes, SQL queries, and PL/SQL procedures.

Prepare and maintain detailed technical documentation for developed solutions.