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

Synergic Links

Deutschland

Remote

EUR 120,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Synergic Links in Germany is seeking a senior hands-on Integration SME to lead end-to-end integration and data migration into Oracle ERP Cloud. This delivery-facing role owns assessment, architectural design, build, test/UAT, implementation, hypercare, and warranty.

You will serve as SME for ODI and OIC, produce HLD/LLD/FSD/TSD/ICD mappings, develop ODI ETL/ELT flows, build OIC integrations, perform data migration, and ensure performance, security, and compliance across the landscape.

Qualifications

  • 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.

Responsibilities

  • Lead assessment & requirements gathering across source systems and stakeholders.
  • Produce HLDs, LLDs, FSDs, TSDs, ICDs and mapping/transformation specs.
  • Develop robust ODI ETL/ELT flows for master and 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 for orchestration.
  • Collaborate with functional teams to align integrations with business processes.
  • Ensure performance, security and compliance of integration landscape.

Skills

ODI & OIC
ETL/ELT development
SQL/PLSQL
Data migration
API integrations
Orchestration
Communication skills
Problem-solving

Tools

Oracle ODI
Oracle OIC
FBDI
UCM
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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Oracle EBS Finance Lead
Oracle EBS Finance Lead

LTM • Augsburg

On-site
EUR 90,000 - 120,000
Oracle ERP Cloud - Program Manager - CRL - Germany
Oracle ERP Cloud - Program Manager - CRL - Germany

Infosys Consulting • München

On-site
EUR 90,000 - 150,000
Oracle Cloud HCM Consultant
Oracle Cloud HCM Consultant

Adroit People Limited (UK) • Frankfurt

Remote
EUR 60,000 - 90,000
Oracle Database Engineer (Strong automation engineering mindset and Solid Oracle/Exadata) (f/m/d)
Oracle Database Engineer (Strong automation engineering mindset and Solid Oracle/Exadata) (f/m/d)

HCLTech Germany • Frankfurt

On-site
EUR 90,000 - 130,000
Principal Network Developer
Principal Network Developer

Oracle Corporation • Geldern

On-site
EUR 120,000 - 180,000
Consulting Project Snr Principal Consultant
Consulting Project Snr Principal Consultant

Oracle Corporation • Geldern

On-site
EUR 74,000 - 151,000
Medical, dental, and vision insurance
401(k) Savings and Investment Plan
Employee Stock Purchase Plan
+1
Principal Application Software Engineer, Java & Cloud
Principal Application Software Engineer, Java & Cloud

Oracle Corporation • Geldern

On-site
EUR 90,000 - 190,000
Health insurance
401(k) plan with match
Paid time off
Senior Oracle HCM / ADP Payroll Integration Consultant (Freelance, Europe)
Senior Oracle HCM / ADP Payroll Integration Consultant (Freelance, Europe)

Sidekick-Network GmbH • Germany

Remote
EUR 80,000 - 120,000
Senior Oracle HCM / ADP Payroll Integration Consultant (Freelance, Europe)
Senior Oracle HCM / ADP Payroll Integration Consultant (Freelance, Europe)

Sidekick Network • Dresden

Hybrid
EUR 70,000 - 100,000
Oracle Database Engineer (m/f/d)
Oracle Database Engineer (m/f/d)

Cubio Consulting • Frankfurt

On-site
EUR 90,000 - 140,000