The Role :
We are looking for a SQL Warehouse Developer for a 6 month contract for our Financial Services client.
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 and Experience :
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.
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
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