Job Opportunities at BankservAfrica

You will engage with the following stakeholders:

• Head of Data
• Analytics services
• Technical production teams
• Information Technology Application Development Teams
• DBAs
• External regulators such as SARB and PASA

Your key responsibilities include:

ETL and data design

• Implementation of advanced design strategies and optimization techniques, using ETL tools.
• Design and documentation of data extractions and transformations.
• Develop and communicate best practices and coding standards ensuring adherence to data warehouse principles.
• Provide data integration technical expertise to analyze capabilities and provide effective knowledge transfer of BI Program application and data integrations with the Business Intelligence team.
• Work closely with business subject matter experts to ensure effective incorporation of business requirements in data integration processes.
• Contribute to the ETL components of data mart builds in the BI environment.
• Work closely with the BI team to define and construct the data and data mart objects to support reporting, system and end user functions in the BI solution.

ETL and database development

• SQL development and development of complex and efficient queries and stored procedures.
• Basic database administration within the Data Warehousing environment.
• Tuning of the ETL Mappings or jobs, deploying, administering and scheduling ETL jobs.
• Performance tuning of database tables through the use of indexes, statistics collection, partitioning, etc
• Suggest data integration performance benchmarks and develop methods for the automation of data integration quality measurement.

Data Provisioning

• Responsible for the provisioning of tokenised data to regulators such as the South African Reserve Bank (SARB) and the Payments Authority of South Africa (PASA) as and when required.
• Responsible for the creation of ad-hoc data extracts for internal and external stakeholders as and when required.

Troubleshooting and error/failure management

• Implementation and management of ETL error handling, error propagation and email alerting and notification.
• Troubleshooting and optimizing ETL code; interpret ETL logs, perform data validation, event handlers.
• ETL development for data movement, data quality, data cleansing and other ETL-related activities.
• Troubleshooting ETL processes failures and technical support for all ETL related issues
   

Qualifications / Knowledge

• Appropriate qualification/training in computer science, software development, informatics or similar.
• Practical experience in ETL, data management and transformation.
• Strong SQL skills.

Experience

• Experience in data modelling, management and ETL.
• Minimum 3 years’ experience in related field.
• Minimum 3 years' experience in Oracle RDBMS.
• Experience in Database Performance assessment.
• Experience in performance tuning in Oracle.
• Experience in working with large Oracle tables / datasets.

go to method of application »

What You Will Do

You will be joining our Application Maintenance and Support - Delivery and Web team as a As a Programmer reporting into the Manager Delivery and Web. You will primarily be accountable for creating and modifying computer programs by converting project requirements into code. Good communication and time management skills, learning agility, broad technical experience and being team player combined with your technical capabilities are key attributes for this role

You will engage with the following stakeholders:

• Financial institutions
• Product Owners
• Enterprise Project Management Office
• BSVA Service Centre
• External and internal technical teams

Your key responsibilities include:

• Confirm, arrange and encode project requirements by converting work flow diagrams into computer language
• Conduct unit tests and modify code where applicable
• Draft user operating instructions coded in a chosen programming language.

Qualifications / Knowledge

• Diploma or degree in Computer Science would be advantageous
• Knowledge in Java, .Net Frameworks and XML
• Good knowledge on Java, C++, MySQL and Oracle.
• Experience with core AWS services would be preferential.
• Working knowledge on Angular based application deployment and JBOSS application
• Good background in Linux/Unix administration.

Experience

• Minimum 3 years’ experience in development
• Experience with building or maintaining cloud-native applications preferential.
• Domain knowledge in the financial sector would be advantageous.