Senior ETL Developer

LUXOFT MALAYSIA SDN. BHD.; Kuala Lumpur; On-site; MYR 100,000 - 150,000; Full time

Job summary

A leading technology firm in Kuala Lumpur is seeking an experienced ETL Developer to contribute to innovative financial technology solutions. The ideal candidate will have 6-9 years of experience in ETL development, strong knowledge of relational databases and cloud data solutions, and proven expertise with the Microsoft Data stack. You will collaborate on high-priority projects and be a vital part of technology transformation efforts within the organization.

Qualifications

• 6 to 9 years of experience in ETL development.
• Expert knowledge of relational databases and data modeling.
• Strong SQL knowledge for complex queries.

Skills

ETL Development

Relational databases

Data Warehouse modelling

SaaS / PaaS solutions

Microsoft Data stack

Cloud data solutions

PowerBI

SQL

Python

Agile methodology

Tools

Azure DevOps

Git

Power Query

DAX

Job description

Overview

Our client is a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe and North America. The Technology and Operations function is comprised of five teams of specialists with distinct capabilities: business partnership, technology, operations, risk governance and planning support and services. The client has more than 80 years of history in the banking industry and is expanding its footprint in Malaysia. The selected resource will be working in a newly set up technology centre located in Kuala Lumpur as part of Technology and Operations to deliver innovative financial technology solutions that enable business growth and technology transformation.

Skills

• 6 to 9 years of experience
• Proven work experience as an ETL Developer
• Advanced knowledge of relational databases and dimensional Data Warehouse modelling concepts
• Good understanding of physical and logical data modeling
• Very good understanding of modern SaaS / PaaS data solutions in a cost conscious approach
• Expert level of knowledge of Microsoft Data stack
• Experience in developing and deploying data oriented solutions in Cloud (Azure / Synapse Analytics / Fabric)
• Experience in designing and implementing data transformation and ETL layers using Data Factory, Notebooks
• Experience with PowerBI for report & dashboard creation. PowerQuery and/or DAX is an advantage.
• Experience in / understanding of Azure Data Lake Storage
• Knowledge / use of CI/CD tools and principles, preferably Azure DevOps or Bamboo
• Strong SQL knowledge, able to create complex SQL queries and good understanding of stored procedures, views, indexes, functions, etc.
• Good working knowledge of at least one scripting language. Python is an advantage.
• Experience with GIT repositories and working with branches. GitHub, Azure DevOps or Bitbucket experience are preferable.
• Ability to troubleshoot and solve complex technical problems
• Good understanding of software development best practices
• Working experience in Agile projects; preferably using JIRA
• Experience in working in high priority projects preferably greenfield project experience
• Able to communicate complex information clearly and concisely.
• Able to work independently and also to collaborate across the organization
• Highly developed problem-solving skills with minimal supervision
• Understanding of data governance and enterprise concepts preferably in banking environment
• Nice to have: Microsoft Fabric, Snowflake, Background in SSIS / SSAS / SSRS, Azure DevTest Labs, ARM templates, Azure PurView, Banking / finance experience.