Oracle Banking Technical Consultant

Responsibilities

• Analyse customer requirements and prepare technical specifications and solution design documents.
• Assess requirements against existing product capabilities and recommend configuration, extensibility or custom development approaches.
• Design, develop, test and deploy customisations and enhancements within the Oracle FLEXCUBE UBS framework.
• Develop and optimise Oracle SQL queries and PL/SQL procedures, functions, triggers and views.
• Integrate application processing logic with three-tier architectures and third-party systems.
• Plan and execute banking data migration activities, including source-to-target mapping, transformation, validation, data quality checks and reconciliation.
• Investigate and resolve migration discrepancies, application defects and complex production issues.
• Develop and execute unit test plans and support integration, regression and customer testing within agreed project schedules.
• Review test plans with quality assurance teams and ensure that delivered solutions meet functional and technical requirements.
• Follow established development standards, documentation practices, change control procedures and applicable quality, audit and compliance requirements.
• Lead and mentor a small team of developers, providing technical guidance and reviewing deliverables.
• Collaborate across functional, technical and customer teams, participating in and leading project discussions as required.

Required Qualifications and Skills

• 10–14 years of relevant experience in software development, implementation or production support, including hands-on experience with core banking products.
• Strong Oracle SQL and PL/SQL development skills, including stored procedures, functions, triggers, views, query optimisation and debugging.
• Hands-on experience delivering data migration projects in the banking domain.
• Good understanding of banking products and processes, including current and savings accounts (CASA), loans, payments and deposits.
• Experience in data mapping, transformation, data quality validation and reconciliation.
• Familiarity with data migration tools and scripting.
• Development experience with JavaScript, XML and web services.
• Experience integrating processing logic within three-tier application architectures.
• Ability to translate business requirements into clear technical designs and implementation specifications.
• Experience guiding developers and taking ownership of technical deliverables.
• Strong analytical, problem-solving, presentation and communication skills.
• Ability to work independently and collaborate effectively with customers and distributed project teams.

Preferred Qualifications

• Development, implementation or production support experience with Oracle FLEXCUBE UBS.
• Experience with Java, service-oriented architecture (SOA) and RESTful web services.
• Working knowledge of Oracle development tools and application deployments on Oracle WebLogic Server.
• Experience with Oracle BI Publisher or Oracle Business Intelligence Enterprise Edition (OBIEE).
• Experience developing and implementing interfaces with third-party systems.

Additional Requirements

• Willingness to travel to customer or prospective customer locations for implementations, product walkthroughs and proofs of concept, as required.
• Flexibility to work shifts according to project and customer requirements.