Oracle PL/SQL Support

KEY RESPONSIBILITIES:

Applications Architecture

• Perform planning/enhancement of Group IT solutions architecture

• Perform development and control best-of-class applications development and management methodologies

Application and Systems Development

• Perform the development of enterprise class applications and integration in line with Group IT solutions architecture

• Support of IT application development functions (plan, organize, outsource management and monitor development projects according to set standards) • Operational efficiency of applications delivery

• Manage opportunities to improve / enhance existing systems

• Services include application customization and integration, user training, installation, live implementation support and maintenance.

• Application customization includes analysis of customization requests and writing of amendment/program specifications, designing, coding and testing of complex programs.

• Manage and resolve application issues

• Manage production system SLA

• Provide post-implementation support to the business users related to their areas of supports.

• Ensure compliance to all processes, audit and risk matters in the execution of user story.

Applications Maintenance and Support

• Perform efficient and effective first and-or second level support for applications.

REQUIREMENTS:

• Minimum Bachelor’s Degree in Technology/IT/Engineering
• Over 2-5 years of Experience as an Oracle Developer.
• Application development using Oracle 12c or 19c database.
• Expertise in developing Applications using ODI, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Tables, Indexes, Views, Sequences, Synonyms
• Good experience in data extraction, transformation and loading operations on oracle using ODI, SQL*Loader, UTL_FILE Package.
• Good experience in developing UNIX Shell Scripts.
• Good experience in requirement gathering from the client and preparing FSD and TSD for reports.
• Good experience in tuning and performance improvement on queries.
• Good understanding of AMLCFT domain.
• Experience in writing batch flow documentation