n

Datawarehouse SQL Developer

R60 000 – R70 000

Remote РSouth Africa 

 

An International Remote work opportunity exists for a Senior Datawarehouse SQL Developer. You would be working remotely on exciting new projects.

 

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 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

 

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

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

 

Qualifications:

  • IT related Degree / Diploma / Certifications

 

REF. KJ0617

 

 

In sending your CV, you confirm that you have read and understood our POPI Policy found on our website www.recruitech.co.za.
Should you be unsuccessful for this particular position, you have no objection to us retaining your personal information in our database which you confirm is true, correct and up to date.
Should a suitable opportunity arise we will contact you and request your permission to submit your information.

Tagged with: , , ,