Description

You will design, develop, and maintain ODI interfaces, packages, and load plans for large-scale data integration solutions.

Responsibilities

• Design and maintain ODI interfaces, packages, and load plans for large-scale data integration.
• Build complex file topologies in ODI to handle multi-format structured and unstructured data.
• Develop PL/SQL scripts and use Oracle SQL for data transformation, validation, and enrichment.
• Automate batch jobs and scheduling using Unix shell scripting and integrate ODI processes with Autosys.
• Monitor daily job executions, perform root cause analysis, and implement corrective actions.
• Mentor junior team members and perform peer code reviews.

Required Skills

• 6+ years of hands-on experience with Oracle Data Integrator (ODI) 12c.
• Expertise in developing complex file topologies including delimited, fixed-width, and hierarchical formats.
• Experience with Oracle BI Applications (OBIA), specifically customizing load plans and data mappings.
• Proficiency in Oracle SQL and PL/SQL for ETL/ELT processes.
• Hands-on experience with Unix/Linux shell scripting.
• Deep understanding of ELT/ETL best practices and data warehousing concepts.
• Experience with job scheduling tools and ODI batch job integration.
• Ability to translate business requirements into scalable ETL/ELT logic.

Preferred Skills

• Exposure to OBIEE, Oracle Cloud, or other reporting/analytics tools.
• Familiarity with version control systems like Git.

Key Skills

Education

Any Graduate