Oracle Database Developer with OIC Experience

About Us: Fusion Practices is a leading IT consultancy delivering HR and finance transformations across financial services, insurance, banking, construction, and the public sector.Our expertise lies in Investment Banking, Trade Accounting, Insurance, Oracle Cloud ERP, HR & PayrollWe have won several awards. Fusion Practices won the ERP Innovation of the Year award for our GrantsNOW SAAS product. Additionally, we were finalists for the British Computing Society awards for IT Vendor of the Year and Development Team of the Year. We also won the Employee of the Year award for one of our team members at ERP Today.For more Info, visit our Website Role Overview: We are seeking a highly skilled Senior Oracle PLSQL Developer to join our team preferably having experience with Investment banking products such as Repos, Bonds, FX, Swaps, Equities and play a crucial role in developing integration routines using Oracle Integration Cloud Services and extending Oracle database software packages for derivatives processing into our financial accounting hub. Key Responsibilities: Strong understanding of Oracle PL/SQL with advanced level programming skills in Oracle PLSQL Develop integration routines using Oracle Integration Cloud Services to ensure seamless data flow between systems. Extend Oracle database software packages to process derivatives into our financial accounting hub. Work on SOA-based architecture, utilizing IBM MQ WebSphere experience for message queue management. Implement Pub/Sub XML message interfacing into the Oracle database to ensure efficient data processing. Leverage Oracle OCI cloud-based RDBMS for data storage and retrieval. Utilize Oracle Integration Cloud solution for data transformation and enrichment. Handle high-volume XML messaging and perform translation using XPath expressions. Maintain XSD schema definitions to ensure data consistency and integrity. Develop, optimize, and maintain database objects such as stored procedures, functions, views, tables, indexes, and more. Key Requirements and Skills: Bachelor's degree in computer science, Information Technology, or related field.Extensive experience in developing integration routines using Oracle Integration Cloud Services.Proficiency in extending Oracle database software packages for derivatives processingKnowledge of investment banking products and lifecycle across Bonds, FX, Swaps, Repos etcExpertise in working with Pub/Sub XML message interfacing into Oracle databases.In-depth understanding of Oracle OCI cloud-based RDBMS.Familiarity with Oracle Integration Cloud solutions for data transformation and enrichment.Experience with high-volume XML messaging, maintaining XSD schema definitions and translation using XPath expressions. Strong skills in developing and optimizing database objects such as stored procedures, functions, views, tables, and indexes.Proven ability to handle large data volumes and implement performance tuning and optimization strategies. Excellent problem-solving and communication skills

Key Skills

• SQL