our work for you

about us

our technologies

sql server

Microsoft SQL Server Developer - T-SQL, SSIS

Creation of ETL routes for filling the internet platforms of the company Swisslife. The tables of the databases behind the internet platforms are filled, but also the data of the data warehouse. Depending on the data source, a preload or a load is first made using stored functions in T-SQL. Subsequently, the data is transformed a first time and loaded into the load structure. Subsequently, the data is refined or transformed a second time and the data transformation is carried out using complex stored functions. Afterwards, the data is loaded into the internet databases on the one hand, and into the data warehouse on the other hand, taking into account the key values. The task is to write dynamic stored procedures for filling these tables, test them, document them and integrate them into the system. The development will be implemented using Microsoft SQL Server 2012 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages, which are also tested and documented.

dwh

Microsoft SQL Server DWH Developer - T-SQL, ETL

Creation of ETL routes for filling the financial data warehouse of the company ElipsLife. The tables of the data warehouse are first filled in the stage area and then, after transformation, in the area of the data warehouse. Both the stage database and the data warehouse are filled by calling stored functions that were implemented in T-SQL. Since the data warehouse is a data vault schema, the filling of the tables of the data warehouse is done according to exact rules. Only one statement is provided for filling the hubs, links or satellites. All three are always filled in the same way, only the names of tables and attributes change. The task is to write dynamic stored procedures for filling these tables, test them, document them and integrate them into the system. The development will be implemented using Microsoft SQL Server 2016 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages; these are also tested and documented.

dwh

Microsoft SQL Server DWH Developer / Consultant - Microsoft SQL Server T-SQL, SSIS, SCCM

The aim of the project is to generate reports based on a data warehouse to be created, which evaluates the data from Microsoft SCCM. For this purpose, a concept is created and then the relevant data from SCCM is loaded into the data warehouse using ETL routes implemented with Microsoft SQL (T-SQL) and Microsoft SSIS. After loading the data, the Enterprise DWH is created and the entire reporting is implemented using SSRS.

dwh
Add your project
If you want us to perform your project, upload all the necessary data and we will be happy to discuss with you all the details of our cooperation.
Name
E-mail
Want to order
Upload your brief
For message
Send Message
Order a template
To install and configure the theme, you need to specify your billing details and hosting data (FTP, PHP admin logins, passwords). After that, our specialists will install the template and you can test it.
Name
E-mail
Want to order
Hosting data and databases
For message
Send request
Add your Review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World), Youtube url, text...
Name
E-mail
Upload your review
URL video-feedback Youtube
Write a review
Post a review
Add your review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World)
Name
Upload
Post a review

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.

+41 (0)56 552 01 85

+41 (0)58 590 10 04

+41 (0)44 442 01 80

+41 (0)56 552 01 86