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