Write complex SQL statements on MS SQL Server (incl. analytical functions)
Debug and optimize SQL statements
Data warehousing/Data Modeling:
Key principles of s star/snowflake schema with conformed dimensions
Defining robust and reusable data models
Understanding of data normalization
Understanding temporal databases
Beneficial, non-mandatory: Talend studio for ETL/ELT (using cloud-based Big Data Fabric version):
Best practices in designing reusable Talend Studio jobs for Data integration
Development and debugging in Talend Studio, deployment to Talend Cloud (Beneficial)
Designing optimized jobs with a proper use of query pushdown, and use of ELT components
Beneficial, non-mandatory: SAP and MSDAX source system know how (processes and data):
End-to-end business process knowledge in SAP / MSDAX; ability to understand the where and how different processes connect
Knowledge of SAP tables and data extraction (SAP business content extractors, generic extractors)
Knowledge of MSDAX tables
