Description

Design and implement enterprise-grade ETL/ELT processes using Oracle Data Integrator.

Responsibilities

• Build and maintain ETL/ELT processes to manage enterprise data workflows.
• Develop functions and stored procedures within the ODI tool.
• Design dimensional data models using star and snowflake schemas.
• Load and process JSON data and flat files.
• Manage database performance through the creation of partitions and indexes.

Required Skills

• 10+ years of experience in data integration and development.
• Expertise with Oracle Data Integrator (ODI) or industry-standard ETL tools.
• Strong proficiency in SQL and PL/SQL scripting.
• Hands-on experience with Oracle databases (11g, 12c, 19c) and SQL Server.
• Experience with dimensional data modeling, including star and snowflake schemas.
• Ability to read and load JSON and flat files.
• Experience managing partitions and indexes in relational databases.
• Practical knowledge of DevOps CI/CD workflows using Azure DevOps or GitHub.
• Bachelor's degree or equivalent graduate level education.

Key Skills

Education

Any Graduate