Microsoft ETL Developer

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)

Awards & Certifications -

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

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.