Description

You will design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI) to integrate data from multiple enterprise systems.

This role is on-site.

Responsibilities

• Build and optimize ODI mappings, interfaces, procedures, and scenarios for high-performance data loading.
• Own the full lifecycle of data workflows, from topology configuration and agent setup to load plans and package execution.
• Monitor and troubleshoot ODI workflows, sessions, agents, and RMJ jobs on Linux environments.
• Perform root cause analysis for failures related to ODI workflows, network connectivity, API integrations, and file transfers.
• Collaborate with DBAs, analysts, and business stakeholders to define data requirements and deliver solutions.

Required Skills

• 7+ years of hands-on experience with Oracle Data Integrator (ODI) and Oracle Data Warehouse.
• Expertise in Oracle PL/SQL, including stored procedures, functions, and complex queries.
• Strong proficiency in Linux/Unix environments, shell scripting, and command-line tools.
• Experience with Python scripting for data processing and operational automation.
• Hands-on experience with ODI administration: Agent setup, log configuration, and certificate installation.
• Proficiency in development practices: unit testing, CI/CD, refactoring, and clean code principles.
• Experience with Bitbucket/GIT for source control management.
• Understanding of networking fundamentals: APIs, IP/ports, SFTP/FTP connectivity.
• Experience with agile methodologies (Scrum, Kanban) and tools like Jira.

Preferred Skills

• Experience with Apache Airflow for workflow orchestration.
• Knowledge of dbt (Data Build Tool) for modern data transformations.

Key Skills

Education

Any Gradute