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