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.

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