Position: BI DWH Developer
Company: RINF Tech
Experience required: 3y
Category: Business Analyst
English level: upper
Published: 2020-06-01T00:00:00+03:00

Min 3 years experience with extensive SSIS development, SQL Server, procedures, SQL and DWH development
he purpose of dimensional modelling

In terms of how to architect the data warehouse, there are two distinctive schools of thought (Kimble & Inmon).
 
Kimble design principles and methodology
(not normalized data marts focusing on business processes and the key business questions needed to be answered)

 
Familiar with architecture design based on	
Inmon (father of the data warehouse, focusing on the corporate data model)
 
Daniel Linstedt (Data Vault 2.0, the agile data warehouse) Started to emerge from 2013 and brings to the table Big Data, NoSQL, unstructured, semi-structured seamless integration, along with methodology, architecture, and implementation best practices.


 
SSIS level of knowledge	
Experience with complex SSIS package development
(not only moving data from a to b)
Different strategies for how to develop packages
Transformations, their usage, pro's and con's
Transaction handling
Debugging
 
SQL Server	Extensive experience with SQL and procedures.
SQL data definition language (DDL)

Columnstore tables, clustering, indexes, keys, partitioning

Read and understand execution plans, tuning and optimization.
 
Programming	C# Programming experience, not a full stack developer but a bit more than 'hello world' is to be expected.

Java basic knowledge, use of variables and functions.
Report development	Today we use Jasper Enterprise and Jasper Studio for development of reports and dashboards. Studio is based on Eclipse and we use java syntax for development.

If not experienced with Jasper, minimum requirement of knowledge would be Java basic
Schema and formats	XML

Would be nice if they have experience with standards such as: ArtsPosLog and Avro