1 - Pipeline design, development & testing
Define the current integration patterns.
Harvest new pipeline patterns.
Design, develop, test and deploy required:
o data ingestion between ODS and OLAP (Warehouse or Lake).
o pipeline between the ODS and OLAP.
Investigate and resolve problems in the OLAP layer.

2 - Metadata
Design and implement metadata harvesting in the OLAP layer.
Support relevant toolsets, where required.

3 - Pipeline patterns
Define and document pipeline patterns.
Document and manage pipeline technical debt.

4 - Data quality
Design, develop and test data quality rules as per the business requirements.
Support data quality tools where required.

5 - Data controls
Design, develop and test data controls to ensure:
o Integrity and completeness as per the non-functional and business requirements.
o Timeliness of data as per the agreed OLA and/or SLA.
o Escalation and notification procedures and solutions where control processes are not met.

6 - Mentorship
Identify technological skills weaknesses within business users on cloud and on-prem data warehouse
Identify and define approaches to address shortcomings for users on cloud and on-prem data warehouse.
Plan the execution of knowledge transfer and knowledge creation initiatives on cloud and on-prem data warehouse

7 - Research
Identify topics of potential interest to the organisation such as industry trends and state-of-the-art technology
Identify topics of interest to the organisation relating to existing technology and processes Prepare a proposal for research work
Research topics, document the results and commit the output to a body of knowledge Apply research findings to the analysis phase of upcoming initiatives
Apply research findings to ongoing implementation efforts
Apply research findings to planning for future initiatives

8 - Compliance
Analyse and interpret regulatory and compliance requirements in the form of specifications and regulation.
Conduct impact analyses
Advise on impact and approach to mitigate risk Continuous improvement of internal processes Timeliness of data as per the agreed OLA and/or SLA.
Escalation and notification procedures and solutions where control processes are not met.

1 - Customer
1. Create and maintain productive relationships with internal and external clients by providing advice and assistance
2. Create understanding of the ‘real’ versus ‘perceived’ need through experience and expertise while complying with company polices legislation and regulations
3. Keep the client informed about progress through written communication, telephone communications and/or face to face meetings
4. Build a positive image by exceeding client expectations at all times
5. Treat internal and external customers fairly at all times

2 - Developing Code
1. Understanding requirements and following code standards
2. Estimate time taken for that requirement
3. Identify best practices in development
4. Provide input to the Business Analyst regarding the quality and accuracy of specifications in terms of development requirements
5. Fix bugs with minimal return from Testers
6. Review of code from Java Developers

3 - Unit Testing
1. Check code standards
2. Check high level functionality before implementing to IT testing
3. Commit correct code to CVS (Control Version System)
4. Code profiling
5. Create test packs
6. Perform unit testing according to ABIL programming standards
7. Develop code according to specifications

4 - Communication
1. Discuss with Testers with regard to bug fixing
2. Discuss with BA’s regarding specification changes
3. Participate in Joint Application Design (JAD) sessions to give input and provide feedback on specifications

5 - Implementation
1. Generate change document / implementation plan
2. Generate all SQL scripts for implementation
3. Generate all Xiriuz parameters for implementation

6 - Documentation
1. Generate technical documentation
2. Generate change review documentation

7 - Research & Design
1. Research system implications and solutions
2. Research latest technologies and methodologies

8 - Application Support
Application support for all systems

9 - Customer
1. Create and maintain productive relationships with internal and external clients by providing advice and assistance
2. Create understanding of the ‘real’ versus ‘perceived’ need through experience and expertise while complying with company polices legislation and regulations
3. Keep the client informed about progress through written communication, telephone communications and/or face to face meetings
4. Build a positive image by exceeding client expectations at all times
5. Treat internal and external customers fairly at all times

1 - Leadership of IT Testing
1. Provide feedback to the Test Manager and Business Analyst regarding the quality and accuracy of specifications
2. Allocation of changes to be tested by the Testers and Test Analysts.
3. Review and approve quality of test cases
4. Coordinate testing of changes in the different test environments (IT test, UAT, Integration & Production environment)
5. Monitor the quality of testing, defect reporting and redeployment of defects
6. Managing the daily workload of a Tester and giving direction on projects.
7. Keep track of the status of all changes prior to it being implemented in the production environment
8. Review the quality and completeness of the documentation pertaining to the changes
9. Provide the Test Manager with accurate and precise estimates for assigned task duration, along with confidence levels and foreseeable dependencies.
10. Assist the Test Manager in preparing test plans, budgets, and schedules.
11. Provide technical guidance to junior-level test engineers and/or test technicians assigned to assist the Test Automation Engineer.
12.Provide the Test Manager with performance assessments for assigned junior personnel

2 - Technical Knowledge
1. Understanding of ISEB testing techniques and their practical application.
2. An appreciation of the role of testing tools in the QA Department.
3. A sound knowledge of databases and systems.
4. Understanding of the roles of change management and business implementation.
5. Compliance with the procedures laid down within the QA Department.

3 - People Management
1. Plan, monitoring and control of test activities and tasks:
2. Leave Planning
4. Time Management
5. Inspire / motivate subordinates by recognising and rewarding for optimum performance
6. Manage Performance of individuals (daily, weekly and monthly)
7. Conduct performance reviews for subordinates
8. Provide corrective measures to address underperformance
9. Manage and resolve conflict amongst the team
10. Conduct regular meetings in respect of:
11. Team productivity
12. Efficiencies
13. Department performance
14. New initiatives in the department
15. General information
16. Manage the trends:
a. Performance improvement plan
b. Coaching
c. Reinforce positive behaviour
17. Identify the training / coaching needs
18. Organise and drive training and coaching initiatives
20. Recommend to test manager re: recruitment and dismissal of staff

4 - Testing Quality
1. Improve quality and efficiency of IT testing.
2. Compile and update the list of matters that have to be tested during a test cycle
3. Keep abreast of the latest testing techniques, methodologies and software testing tools by reading, attending seminars and courses and research Evaluate these techniques, methodologies and software tools and implement changes to improve efficiency and quality
4. Analyse trends relating to non-successful testing of changes in all the environments and suggest measures to improve results
5. Design and implement changes to improve the quality of specifications