ETL Developer

Globalchannelmanagement; Jersey City (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading data integration company in Jersey City is seeking an experienced professional to design and deploy ETL processes using Oracle Data Integrator (ODI) and OCI-DI. Responsibilities include implementing data integration solutions, developing SQL scripts for data manipulation, and monitoring ETL processes. The ideal candidate has strong hands-on experience with ODI, proficiency in SQL/PLSQL, and a deep understanding of cloud and on-premises data integration. This role offers an opportunity to work in a dynamic environment focused on innovative data solutions.

Qualifications

• 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.
• Understanding of ETL processes, data warehousing concepts, and cloud data integration.

Responsibilities

• Design, develop, and deploy ETL processes using Oracle Data Integrator (ODI) and OCI-DI.
• Implement data integration solutions using OIC, connecting cloud databases and on-premises systems.
• Monitor and troubleshoot ODI jobs, tuning performance of ETL processes.

Skills

Oracle Data Integrator (ODI)

SQL

PL/SQL

ETL solutions

Cloud data integration

Education

Bachelor's degree or equivalent experience

Job description

Qualifications

• o Bachelor's degree preferred or equivalent experience
• o . Strong hands‑on experience with Oracle Data Integrator (ODI) development and administration.
• o . Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
• o . Experience deploying and managing ETL solutions on OCI PaaS/IaaS environments.
• o . Deep understanding of ETL processes, data warehousing concepts, and cloud data integration.
• o . Experience in integrating on‑premise and cloud‑based data sources.

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