OFSAA ETL / ODI Technical Consultant

5+ years of hands-on experience in Oracle Data Integrator (ODI), preferably supporting OFSAA implementations and financial services data models.
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 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.