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

Mumbai - India

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Were 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 youll 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 only apply if you have the relevant skills & experience.