SQL Warehouse Developer

SUMMARY:
The Role:

We are looking for a SQL Warehouse Developer for a 6 month contract for our Financial Services client.

Role Purpose

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 str...

POSITION INFO:
The Role:

We are looking for a SQL Warehouse Developer for a 6 month contract for our Financial Services client.

Role Purpose

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.

 

Skills

Modelling

Data Transportation

Development Software

• 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 +).
• Should have a good understanding of source control systems and the concepts of building and releasing software versions. Microsoft TFS knowledge is preferred.

Governance and Framework

• Clear understanding and application of DAMA framework.
• Have the ability to draft new data governance policies in accordance with TOGAF, ZACHMAN or other frameworks.

Repository type

• Must be able to source data from different repositories.
• Must be fully acquainted with Microsoft SQL Server repository.
• Must have knowledge of NoSQL would be an advantage.
• Must have knowledge of Data Lake would be an advantage.
• Must have the ability to source data from any repository in an appropriate manner with the appropriate application.

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

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