For our business partner, one of the largest integrators of IT and physical security solutions for national and European critical infrastructure, we are looking for an ETL Developer with ODI to join their team and contribute to the development and optimization of ETL processes using Oracle Data Integrator (ODI), Oracle GoldenGate, and Oracle databases, including Oracle Exadata technology.
In this role, you will be responsible for designing, developing and implementing ETL solutions that ensure effective data integration and support Business Intelligence initiatives.
Responsibilities:
- Creating, developing, and maintaining ETL flows using Oracle Data Integrator (ODI).
- Using Oracle GoldenGate to replicate and synchronize data between sources and destinations.
- Implementing ETL solutions on Oracle Exadata to ensure optimal performance and integration of large-volume data.
- Design and develop scalable ETL processes to integrate data from multiple and heterogeneous sources.
- Optimizing the performance of ETL processes and Oracle infrastructure to reduce processing times and improve efficiency.
- Configure and monitor data replication and integration flows to ensure consistency and accuracy.
- Collaborating with Business Intelligence and Data Warehouse teams to understand requirements and develop ETL solutions to meet them.
- Provide technical support and resolve issues related to ETL processes.
- Maintaining and patching ETL code and ensuring compliance with development best practices and standards.
- Create and maintain detailed technical documentation for ETL processes and data architecture.
- Reporting progress and issues encountered in developing and implementing ETL solutions.
Requirements:
- Bachelor’s Degree in Computer Science or equivalent;
- Minimum 3 years of experience developing and implementing ETL solutions using Oracle Data Integrator (ODI).
- Advanced SQL and PL/SQL skills for developing and optimizing ETL scripts.
- Knowledge of Oracle GoldenGate for real-time data replication and synchronization between sources.
- Familiar with Oracle Exadata and performance optimization for high-volume ETL processes.