Description

You will build and maintain enterprise data integration pipelines using Oracle Data Integrator, PL/SQL, and Linux.

This role is on-site.

Responsibilities

• Design and maintain ETL/ELT pipelines, ODI mappings, interfaces, packages, and load plans.
• Develop complex PL/SQL queries, stored procedures, and functions for high-performance data loading.
• Monitor, troubleshoot, and resolve failures in ODI workflows, RMJ jobs, and sessions.
• Perform root cause analysis for ODI, network, and API integration issues in production.
• Optimize ETL workflows and enforce coding standards through code reviews.

Required Skills

• 7+ years hands-on experience with Oracle Data Integrator (ODI), including topology and agent configuration.
• Extensive expertise in Oracle Data Warehouse and advanced PL/SQL development.
• Proficiency in Linux/Unix environments, including shell scripting for automation.
• Experience with Python scripting for data processing and operational workflows.
• Strong understanding of data modeling principles.
• Knowledge of CI/CD practices, unit testing, and clean code standards.
• Experience with Git/Bitbucket for source control.
• Familiarity with Agile methodologies (Scrum, Kanban) and Jira.
• Understanding of networking fundamentals, including API, IP/ports, and SFTP/FTP.

Preferred Skills

• Experience with Apache Airflow for workflow orchestration.
• Knowledge of dbt (Data Build Tool) for modern data transformations.
• Private Banking domain experience or background in financial services.

Key Skills

Education

Bachelor's degree