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.
