OFSAA ETL / ODI Technical Consultant

Role & responsibilities

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