Oracle OFSC B2B Enhancements Consultant

Job Summary

We are looking for an experienced OFS B2B Enhancements Consultant to support enhancement customization integration and production support activities for the existing OFS B2B application landscape The consultant will work with business and technical teams to understand enhancement requirements perform impact analysis develop solutions conduct testing and support successful deployment

Key Responsibilities

• Analyze business requirements and enhancement requests related to OFS B2B applicationsprocesses
• Perform requirement analysis solution design development configuration and implementation of enhancements
• Understand existing application functionality interfaces data flows and customizations before implementing changes
• Develop and modify PLSQL procedures packages functions triggers and SQL queries as required
• Support enhancements to existing screens reports interfaces batch processes and integrations
• Perform impact analysis for proposed changes and identify dependencies across upstream and downstream applications
• Troubleshoot application data interface and production issues and perform rootcause analysis
• Coordinate with functional teams business users infrastructure teams and other application teams for implementation activities
• Prepare technical specifications solution documents deployment instructions and other project documentation
• Perform unit testing and SIT support and assist business teams during UAT
• Support defect resolution deployment postproduction validation and stabilization activities
• Ensure enhancements comply with established coding security performance and changemanagement standards

Required Technical Skills

• Strong experience working on OFSOFS B2B applications or related Oracle Financial Services solutions
• Strong knowledge of Oracle Database SQL and PLSQL
• Handson experience in application enhancements customization and production support
• Experience with Oracle packages procedures functions triggers views and complex SQL queries
• Knowledge of batch processing interfaces filebased integrations and dataprocessing workflows
• Experience in debugging and performance tuning of SQLPLSQL components
• Good understanding of UnixLinux and shell scripting
• Experience with application deployment and releasemanagement processes
• Experience in SIT UAT defect management and production support