SQL Warehouse Developer - Centurion

SUMMARY:
SQL Warehouse Developer

POSITION INFO:

 SQL Warehouse Developer

Position based in Centurion

6 month contract with possible extension

Our client in the finance industry is looking for a SQL Warehouse Developer

EXPERIENCE AND QUALIFICATIONS

• IT Degree
• 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

Development Software

• Have practical knowledge of T-SQL (2-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 (2-5 years).
• Have practical experience of MS SSIS ETL software (2-5 years).
• Knowledge of MS SSAS OLAP software would add an advantage.
• Have practical experience of MS Visual Studio Data Tools (2-5 years).
• Should have a good understanding of source control systems and the concepts of building and releasing software versions.
• Microsoft TFS knowledge is preferred.
• MS SSRS and/or PowerBI report development experience

SKILLS

Methodologies

• Have a clear understanding of Agile methodologies.
• Be familiar with Waterfall methodology.
• Be able to demonstrate hybrid integration of both Agile and Waterfall when required.
• Have solid understanding of Metadata, Master Data Management (MDM) and Data Architecture.

Principles

• Be familiar with Software development principles such as SOLID, TDD, Separation of Concerns, Loose Coupling
• Have a clear understanding of Data warehouse principles.
• Be familiar with n-tier layered architecture (3-5 years).

Modelling

• Should have data modelling skills and should be able to interpret conceptual, logical and physical data models. (3 – 5 years).
• Should be able to translate business requirements into technical designs with appropriate data modelling.
• Should have proven data modelling techniques including normalization skills.
• Must be familiar with data warehousing principles, based on the Kimball and/or Inmon architectures.

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