ODI Developer (Mid-Senior)

Seven Seven Global Services, Inc.; Philippines; On-site; PHP 700,000 - 1,000,000; Full time

Job summary

Seven Seven Global Services, Inc. in the Philippines seeks a seasoned ODI specialist to lead batch pipelines for migration projects and T-1 delta ingestion, aligned to Load Plans.

You will design end-to-end ODI frameworks, implement Load Plans for Migration and Delta execution, and develop ingestion pipelines from source systems into EDW/ADW staging.

This role requires a focus on restartable, dependency-driven execution, data quality, performance optimization, and ongoing production support.

Qualifications

• Experience building ODI batch pipelines end-to-end.
• Proficient in migration and T-1 delta ingestion.
• Knowledge of data loading into EDW/ADW staging.
• Experience with historical data migration (bulk loads).
• Ability to design incremental delta ingestion for daily loads.
• Ensure restartable, dependency-driven batch execution.

Responsibilities

• Design and build ODI pipeline framework for batch orchestration.
• Implement Load Plans for Migration and Delta execution.
• Develop ingestion pipelines from sources to EDW/ADW.
• Execute historical data migrations via bulk loads.
• Implement incremental delta ingestion for daily loads.
• Ensure restartability and dependency-based execution.
• Build reconciliation and control total frameworks.
• Optimize batch performance and load windows.
• Support production stabilization and incident resolution.

Skills

SQL (advanced)

Batch data processing

Data migration

ETL design

Data modeling

Tools

ODI 14c

ADW

OCI

Unix/Linux scripting

Jenkins / OCI DevOps

Oracle performance tuning tools

Batch scheduling design

Job description

Tech Stack (Required)

• Oracle Data Integrator (ODI 14c – expert level)
• Oracle Autonomous Data Warehouse (ADW)
• Oracle Cloud Infrastructure (OCI)
• SQL (advanced – transformations, tuning, reconciliation)
• Unix/Linux scripting
• CI/CD tools (Jenkins / OCI DevOps)
• Oracle performance tuning tools
• Batch data architecture (T-1 / scheduled processing)
• Data modeling (star/snowflake for reporting layer)
• Security architecture (RBAC, encryption, audit)
• Batch scheduling design (dependency-based pipelines)

Role Summary

Leads development and execution of ODI batch pipelines supporting both initial migration and T-1 delta ingestion, fully aligned to Load Plans.

Key Responsibilities

• Design and build ODI pipeline framework (end-to-end batch orchestration)
• Implement Load Plans for Migration and T-1 Delta execution
• Develop ingestion pipelines from source systems into EDW/ADW staging and curated layers*
• Execute historical data migration (bulk load processing)
• Implement incremental (delta) ingestion for daily T-1 loads
• Ensure restartability and dependency-driven execution
• Build reconciliation and control total frameworks
• Optimize batch performance and load windows
• Support production stabilization and incident resolution