Oracle ETL (ODI / OIC) Systems Analyst — Lead Systems Analyst (Remote)

Synergic Links; United States; Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading tech integration firm is seeking a Senior Integration SME to oversee Oracle ERP Cloud integrations. You will lead data migration efforts and ensure alignment with business processes, leveraging ODI & OIC expertise. Ideal candidates have over 8 years of experience in integration projects and strong skills in ETL/ELT development. This role includes collaboration with functional teams and requires excellent communication abilities.

Qualifications

• 8+ years of hands-on experience with ODI & OIC in migration/integration projects.
• Strong understanding of ODI ETL/ELT dev & tuning.
• Experience in delivering HLD, LLD, FSD, TSD documents.

Responsibilities

• Lead end-to-end integration and data migration into Oracle ERP Cloud.
• Serve as SME and primary owner for ODI and OIC deliverables.
• Collaborate with functional teams to align integrations with business processes.

Skills

ODI & OIC expertise

ETL/ELT development

SQL & PL/SQL

Problem-solving skills

Communication skills

Tools

Oracle ERP Cloud

Airflow

Control-M

Job description

We’re looking for a senior hands‑on Integration SME to lead end‑to‑end integration and data migration into Oracle ERP Cloud. This is a delivery-facing role — you’ll own assessment, HLD/LLD design, build, test/UAT, implementation, hypercare and warranty.

Key responsibilities

• Serve as SME and primary owner for ODI and OIC deliverables.
• Lead Assessment & Requirements gathering across source systems and business stakeholders.
• Produce HLDs, LLDs, FSDs, TSDs, ICDs and mapping / transformation specs.
• Develop robust ODI ETL/ELT flows for master & transactional data.
• Build OIC integrations: adapters, orchestration, API & event-driven workflows.
• Implement integrations using APIs, FBDI, UCM, and file-based approaches.
• Execute data migration: extraction, cleansing, transform, load, validate, reconcile.
• Use Oracle 19c + SQL/PLSQL for complex transformations and tuning.
• Work with Airflow/Control-M (or similar) for orchestration.
• Collaborate with functional teams (GL, AP, AR, FA, CM, AHC, UCM) to align integrations with business processes.
• Ensure performance, security and compliance of integration landscape.

Required

• 8+ years hands‑on with ODI & OIC in Oracle ERP migration/integration projects.
• Strong ODI ETL/ELT dev & tuning, OIC flows/adapters/orchestration, FBDI/UCM/API patterns.
• Oracle DB 19c, SQL & PL/SQL expertise.
• Experience delivering HLD, LLD, FSD, TSD docs.
• Scheduler/orchestration experience (Airflow/Control-M).
• Excellent communication and problem-solving skills.

Preferred

• Oracle ODI/OIC certifications, banking/tax/CRM integrations, Oracle BI Publisher/OTBI familiarity, waterfall & agile exposure.

📩 Interested? Email your updated resume to [e-mail] — only apply if you have the relevant skills & experience.