ETL/DW Developer

Stockholm  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

Templeton & Partners are representing a prestigious Swedish Company for a long-term programme.

ETL DW Developer in Microsoft BI production solution team.

The BI solution manages production data and includes large amounts of data with daily loads of millions of transactions daily with storage and presentation of billions of transactions.

The solution consists of the following components:

  • ETL - SQL Server Integration Services

  • DB - SQL Server and SQL Server Analytics Platform, APS (MPP)

  • Cubes - SQL Server Analysis Services Tabular

  • Reference data - SQL Server Master Data Services (MDS)

  • SSRS reports

  • Business Objects reports

The assignment includes:

  • Expand ETL processes to load more data to DW

  • Create integrations to production systems using component development and Web Services consumption to load data to DW.

  • Expand existing DW/DB solution with more information

  • Expand reference data in MDS to manage more information.

  • Optimize existing solution for better performance

  • Use SQL Server 2016 and 2017 and APS

Fulfillment of assignment

The assignment is performed in a team with agile development methodology according to SCRUM.

Details

Start: Immediate

Duration: August 2018 + Extensions

Language: English

The project will work on short frequent deliveries, where the end result is a solution with higher data quality and richer information model, as well as improved performance in both data loads and data recovery.

Start date
n.a
From
Templeton and Partners
Published at
01.02.2018
Project ID:
1495234
Contract type
Freelance
To apply to this project you must log in.
Register