OFSAA ETL / ODI Technical Consultant

OFSAA ETL / ODI Technical Consultant

Job Type: Full time

Delivery Centric is seeking an experienced OFSAA ETL / ODI Technical Consultant with strong hands-on expertise in Oracle Data Integrator (ODI), ETL development, SQL/PLSQL and OFSAA data integration within financial services environments.

Key Requirements

  • 5+ years of hands-on experience with Oracle Data Integrator (ODI), with experience supporting OFSAA implementations, preferably within financial services.
  • Strong experience in designing, developing and maintaining ETL interfaces using ODI for extraction, transformation and loading of data from EDW/source systems into OFSAA.
  • Experience integrating data for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT, with a good understanding of OFSAA staging and data structures.
  • Strong SQL and PL/SQL skills, including development, troubleshooting, query optimization and database processing.
  • Hands-on experience with ODI mappings, packages, workflows, scheduling, data transformations and ETL performance tuning.
  • Ability to perform source-to-target data mapping, data validation, reconciliation and troubleshooting of data-load and integration issues.
  • Experience working closely with functional/business teams to understand data requirements and translate them into effective ODI/OFSAA integration solutions.
  • Experience supporting SIT, UAT and production environments, including troubleshooting and resolution of data integration issues.

How to Apply

Ready to take on a OFSAA ETL / ODI Technical Consultant role with Delivery Centric? Apply now to join a team that delivers excellence and realises value for its clients.