Description

You will design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI) to integrate data from multiple enterprise systems. You own the full lifecycle of data workflows, from topology configuration and agent setup to load plans and package execution.

Responsibilities

• Build and optimize ODI mappings, interfaces, procedures, and scenarios for high-performance data loading.
• 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.
• Maintain comprehensive documentation of data processes, configurations, and best practices.

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