Operational Reporting Developer & ETL Specialist

The main responsibility is developing and enhancing complex reports requirements by the business for the core banking and other business applications. The incumbent will be responsible to perform ETL (Extract, Transform and Load) within other core systems that uses the data feed from the Core banking system.

7.1.Participates in development and support projects to design, implement, modify and optimise reports
7.2.Performs database monitoring and reporting tasks including reviewing daily loading logs, ensuring data integrity, monitoring system event and error logs, monitoring disk drive space available to databases and transaction logs, and helping control and monitor user access and activity levels.
7.3.Writes stored procedures, ORACLE views, triggers and scripts.
7.4.Works with application specialist and/or vendors to develop and maintain data warehouses.
7.5.Ensure uptime on all reporting portals
7.6.Ensure all data feeds from Core systems to external systems are completed within agreed timelines.
7.7.Documents non-routine procedures, workarounds and solutions.
7.8.Designs scripts and reports, using the Group’s report writing tools

•Bachelor's degree - preferably in Information Technology, Computer Science or equivalent
•At least 5 years post qualification experience in Oracle SQL scripting for a core banking system and related channels (advantage).
•In-depth knowledge of SQL/Oracle DB experience and various qualification will be an added advantage.
•In-depth scripting experience through jasper reporting tool, would be an added advantage.
•Experience with relational databases, such as MySQL, MS SQL, and SQL Server