Information Technology

Microsoft ETL Developer

Johannesburg, Gauteng   |   Full time

Company Description

Read about us on www.copious-software.com

Job Description

Role & Responsibilities -

  • Interact with business and system analysts to solutionise problems.

  • Collaborate with analysts to understand source structures, evaluate requirements and finally deliver a solid solution.

  • Conduct data analysis on various source systems as part of the ETL development process.

  • Utilise the toolstack of the environment which is primarily Microsoft (SSIS, T-SQL) to deliver solutions.

  • Must be able to read and maintain code not written by yourself.

  • Have experience following a formal SDLC as part of solution delivery.

  • Optimise ETL processes as well as SQL queries by analyzing query execution plans.

  • Maintain code repositories for version control of developed solutions.

  • Create and maintain metadata repositories.

  • Implement database structures according to specifications and guide on improvements (indexes/partitioning etc) where necessary.

  • Perform ETL support on a standby basis to ensure that the ETL batch completes within SLA.

Technical skills required -

  • Ability to design and implement complete ETL processes using SSIS and T-SQL.

  • Strong ETL experience in loading slowly changing dimensions as well as transactional and snapshot fact tables.

  • Proven experience with working with large datasets in the region of billions of records.

  • Experience on working with delta datasets and versioned history on target tables.

  • Solid experience in understanding ERD’s and source-to-target mappings as well as producing source-to-target mappings of solutions.

  • Strong SQL query writing ability (across database environments eg Oracle, Postgres etc) with a firm understanding of analytical functions.

  • Good understanding of ODS, data warehouse, data mart, cube, and database technologies.

Other skills required -

  • Strong analytical and problem solving skills.
  • Navigating ambiguity and complexity
  • Excellent oral and written communication skills.
  • Added advantage of the entire Microsoft data technology stack including (SSAS, SSRS, PowerBI)

Qualifications

Awards & Certifications -

  • IT-related Degree or Diploma (BSc/BTech or similar)

Additional Information

We define the role level as below -

  • 4 to 8 years of related experience.

Employment type -

  • Our preferred engagement model is contracting (6 to 12 months of initial engagement & renewable).
  • In some cases, we do welcome a permanent employment model too; let's discuss this further close to the onboarding stage.

Submit Your Application

You have successfully applied
  • You have errors in applying
Upload any other documents like ID, Visa, Certificates, Cover Letters etc. (No images)