SQL Warehouse Developer

SUMMARY:
Psybergate seeks a skilled SQL Warehouse Developer for a 12 month Contract, to be based at a Client in Centurion.

POSITION INFO:

• Develop, maintain and support a portfolio of software applications and services to ensure improved business efficiencies and that are aligned to the enterprise architecture and business strategy.
• Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
• Translate business requirements into workable solutions and document solution into technical specifications.
• Design and code new software functionality using codes that is readable, maintainable and re-usable.
• Provide client with regular feedback on the technical design and timelines for solution.
• Collaborate with business analysts and testing team in developing, testing and deploying new software system components or software system enhancements.
• Collaborate with testing team to co-create test cases.
• Conduct System Integration Testing (SIT) and User Acceptance Testing (UAT) and resolve all issues/queries.
• Contribute to user acceptance testing (UAT) and training material.
• Provide authoritative, expertise and advice to clients and stakeholders.
• Build and maintain relationships with clients and internal and external stakeholders.
• Deliver on service level agreements made with clients and internal and external stakeholders in order to ensure that client expectations are managed.
• Make recommendations to improve client service and fair treatment of clients within area of responsibility.
• Participate and contribute to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service.
• Identify solutions to enhance cost effectiveness and increase operational efficiency.
• Manage financial and other company resources under your control with due respect

• IT Degree or any other related
• 3-5 Years development experience within a SQL data lake and warehouse environment within the Financial Sector and
• Must have knowledge of the Software Development Lifecycle
• Has practical experience in using ETL software applications (advantageous)
• Must be able to source data from different repositories.
• Must be fully acquainted with Microsoft SQL Server repository.
• Have practical knowledge of T-SQL (5 years +),
• Exposure and knowledge of Oracle, DB2, MySQL, MS Access, Mongo and PostgreSQL will be an advantage.
• Have practical experience of SQL Server Database Engine (5 years +).
• Have practical experience of MS SSIS ETL software (5 years +).
• Knowledge of MS SSAS OLAP software would add an advantage.
• Have practical experience of MS Visual Studio Data Tools (5 years +).

NB! This job is now closed. You can apply for other jobs by uploading your CV.