Oracle OFSAA with Data Integrator ODI

Job Description

Oracle OFSAA with ODI experience Employment Type : CTH with our client Location: Bangalore India No. of positions:1 This role will involve developing and implementing data integration solutions using Oracle Data Integrator (ODI) for Oracle Financial Services Analytical Applications (OFSAA). Candidate would be working on financial data integration, data warehousing, and ETL processes to ensure that the financial and operational data are processed efficiently and meet the required reporting standards. The ideal candidate will have a strong background in Oracle OFSAA, ODI, and financial services data models, and will be capable of delivering high-quality solutions. Technical Skills - 5+ years of strong expertise in Oracle OFSAA, ODI, middleware tools and financial services data models - Proficiency in SQL, PL/SQL and other relevant technologies. - Write and optimize SQL queries, PL/SQL scripts, and other database management tasks to support system functionality. Key Responsibilities: Data Integration Maintenance/ Development Design and develop ETL processes using Oracle Data Integrator (ODI) for financial services applications. Work on integrating data from different financial systems/ EDW into OFSAA Design and implement solutions for data extraction, transformation, and loading (ETL) OFSAA Application Management Develop, enhance, and maintain integration processes within Oracle OFSAA EPM modules (e.g. ALM, LRM, FTP, LLFP and PFT). Ensure seamless integration between OFSAA modules and external data sources/systems. Work with stakeholders to understand business requirements and map them into effective data solutions using ODI and OFSAA. Performance Tuning Optimize ODI ETL workflows for performance and efficiency. Monitor data processing and troubleshoot issues related to data integration and OFSAA functionalities. Data Quality & Validation Work closely with data analysts and business users to ensure that data in OFSAA is accurate and reflects business needs.