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

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.