PL/SQL Developer

Job Title: PL/SQL Developer & ETL Engineer (Oracle ODI)

We are looking for a PL/SQL Developer with a strong focus on ETL/ELT processes. The ideal candidate will help bridge database development and data integration activities, with a particular focus on Oracle Data Integrator (ODI) to support our data warehousing initiatives.

Key Responsibilities

• Develop and maintain high-performance PL/SQL code (packages, procedures, triggers).
• Design, implement, and monitor ETL/ELT workflows using Oracle Data Integrator (ODI).
• Support data migration and integration from multiple source systems.
• Perform SQL tuning and optimize data loading and transformation processes.
• Troubleshoot and resolve data integration and ETL pipeline issues.

Technical Requirements

• Strong experience with Oracle PL/SQL development.
• Junior to Mid-level experience with Oracle Data Integrator (ODI).
• Familiarity with ODI Mappings, Packages, Scenarios, and Knowledge Modules (KM).
• Understanding of ETL best practices and Data Warehouse architecture.
• Ability to analyze, debug, and optimize data integration workflows.

Nice to Have

• Experience with large-scale data environments.
• Knowledge of performance tuning and data pipeline optimization.
• Exposure to data migration or enterprise data integration projects.