Apply for the job
RecruiTech

Datawarehouse SQL Developer

null, null, ZA
FULL TIME

Company: RecruiTech

Category: Computer and Mathematical Occupations

Published on 2022-05-23 14:44

Responsibilities / Skills:

SQL:

  • Write complex SQL statements on MS SQL Server (incl. analytical functions)
  • Debug and optimize SQL statements

Data warehousing/Data Modeling:

  • Key principles of a 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

Beneficial, non-mandatory: Theobald Xtract Universal (Optional)

Beneficial, non-mandatory: DevOps with Git (Optional)

Qualifications:

  • IT related Degree / Diploma / Certifications
© 2022 JobSearchine South Africa