Job Summary :
We are seeking a highly experienced and technically proficient Oracle Data Integrator (ODI) Developer to lead the design, development, and maintenance of complex enterprise data integration solutions. This role requires 5+ years of hands-on expertise with ODI, coupled with mastery of PL / SQL and the Oracle database ecosystem. The Developer will be responsible for the full ETL / ELT lifecycle, focusing on optimizing data movement, ensuring data quality, and applying a strong understanding of relational database design to solve complex business intelligence challenges.
Core Responsibilities :
ODI Development and Architecture :
- Design, develop, implement, and optimize complex ETL / ELT processes using the Oracle Data Integrator (ODI) platform, including the creation of Interfaces, Packages, Procedures, Scenarios, and Load Plans.
- Customize and leverage Knowledge Modules (KM) within ODI to enhance data integration capabilities and optimize ELT performance.
- Manage and maintain the ODI Repository (Master and Work), Topology, and Security configurations.
Database Programming and Performance :
Apply strong expertise in PL / SQL for writing complex stored procedures, functions, triggers, and packages to support advanced data transformations and backend logic within the Oracle database.Utilize advanced SQL skills for complex data querying, analysis, validation, and rigorous performance optimization on existing ETL jobs and database objects.Work daily with professional database tools such as SQL Developer and TOAD for development, debugging, and operational monitoring.Data Integrity and Operations :
Implement robust error handling, logging, and job recovery mechanisms within all ODI artifacts to ensure the reliability and stability of data pipelines.Apply a strong understanding of relational database design principles (e.g., dimensional modeling, indexing strategies) to build and maintain an optimized data warehouse environment.Leverage excellent troubleshooting and problem-solving skills to quickly diagnose and resolve production incidents and data flow anomalies.Collaboration and Execution :
Demonstrate the ability to work independently and effectively manage project deliverables in a remote environment.Collaborate effectively with source system administrators, data architects, and distributed BI teams to understand requirements and deliver integrated data solutions.Required Qualifications :
5+ years of hands-on experience specifically with Oracle Data Integrator (ODI) development.Strong expertise in PL / SQL, advanced SQL, and proven experience in backend programming within the Oracle databases.Demonstrated proficiency using SQL Developer and TOAD for database and code management.Proven experience in end-to-end data integration and ETL development lifecycle management.Strong understanding of relational database design concepts and best practices for performance optimization.Excellent analytical, troubleshooting, and problem-solving capabilities.Ability to work effectively and independently in a remote setting while collaborating with global teams.Preferred Skills :
Experience integrating data with Snowflake or other modern cloud-based data platforms (e.g., AWS Redshift, Azure Synapse).Experience with reporting and visualization tools such as Power BI or Tableau.Familiarity with CI / CD pipelines and using version control tools (e.g., Git) for managing ODI artifacts.Exposure to DevOps or data automation practices using scripting languages (e.g., Python, Shell).(ref : hirist.tech)