We are looking for an experienced ODI/ETL Technical Consultant with robust expertise in Oracle Data Integrator (ODI), preferably with OFSAA implementation experience and financial services data models.
KEY RESPONSIBILITIES
• Design, develop and maintain ETL interfaces using ODI.
• Integrate EDW/source systems with OFSAA applications.
• Work on OFSAA modules such as ALM, LRM, FTP, LLFP and PFT.
• Develop and optimize SQL/PL-SQL queries and database processes.
• Create and manage ODI mappings, packages, workflows and schedules.
• Perform source-to-target mapping, data validation and reconciliation.
• Troubleshoot data-load and integration issues and improve ETL performance.
• Collaborate with functional/business teams on data requirements.