Senior ETL Developer

5 Months ago • 6-9 Years • DevOps

Job Summary

Job Description

Senior ETL Developer needed for a leading Asian bank's new technology center in Kuala Lumpur. Responsibilities include designing, coding, testing, and debugging data warehouse components throughout the SDLC; applying cloud and ETL engineering skills to solve problems; troubleshooting and debugging ETL pipelines; creating unit tests; optimizing query performance; writing technical documentation; supporting internal audits; creating reports and dashboards; collaborating with various teams (Development Lead, DWH Architect, QA Engineers, Business Analysts); and adhering to Agile principles. The role requires expertise in Microsoft Data Stack, Azure cloud services (Synapse Analytics, Data Factory), Power BI, and SQL. Experience with data governance and enterprise concepts, preferably within a banking environment, is preferred.
Must have:
  • 6-9 years ETL Dev experience
  • Advanced relational database knowledge
  • Dimensional Data Warehouse modeling
  • Microsoft Data Stack expertise
  • Azure cloud experience (Synapse, Data Factory)
  • Power BI & SQL skills
  • Agile project experience
Good to have:
  • Microsoft Fabric
  • Snowflake
  • SSIS/SSAS/SSRS
  • Azure DevTest Labs
  • Azure PurView
  • Banking/finance experience
  • Python scripting

Job Details

Project description

Our Client 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 are looking for Consultants to be part of the project

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. They work closely together to harness the power of technology to support our physical and digital banking services and operations. This includes developing, centralising and standardising technology systems as well as banking operations in Malaysia and overseas branches.

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

Responsibilities

Act as a technical expert in the designing, coding, unit testing, supporting, and debugging of data warehouse software components in all aspects of SDLC

Apply cloud and ETL engineering skills to solve problems and design approaches

Troubleshoot and debug ETL pipelines and creating unit tests for ETL pipelines.

Assess query performance and actively contribute to optimizing the code

Write technical documentation and specifications

Support internal audit by submitting required evidence

Create reports and dashboards in the BI portal

Work with Development Lead, DWH Architect and QA Engineers to plan, implement and deliver best ETL strategies

Work with business analysts to understand requirements to create technical design specifications, gaining a sound understanding of business processes for related applications so that integration processes fulfill the end-user requirements

Communicate effectively in a collaborative, complex and high performing team environment as per Agile principles

Skills

Must have

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

Other

Languages

English: C1 Advanced

Seniority

Senior

Similar Jobs

Trend Micro - Sr. AI Engineer

Trend Micro

Taipei City, Taiwan (On-Site)
7 Months ago
Omnissa - Staff Engineer (Data Science)

Omnissa

Bengaluru, Karnataka, India (Hybrid)
5 Months ago
ION - Senior Security Architect

ION

Milan, Lombardy, Italy (On-Site)
6 Months ago
Trailmix Games - Senior DevOps Engineer

Trailmix Games

London, England, United Kingdom (Hybrid)
1 Month ago
Rackspace Technology - Senior Machine Learning Engineer

Rackspace Technology

Vietnam (Remote)
2 Months ago
Adobe - Senior Engineering Manager, Media Services & Storage

Adobe

New York, New York, United States (Remote)
1 Month ago
Match Group - Senior Platform Engineer

Match Group

New York, New York, United States (Hybrid)
6 Months ago
Google - Senior Product Manager, DevOps, Google Cloud

Google

Kirkland, Washington, United States (On-Site)
1 Week ago
SparkCognition - Senior DevOps Engineer

SparkCognition

Bengaluru, Karnataka, India (On-Site)
7 Months ago
Ubisoft - Monitoring Specialist - Golang Developer

Ubisoft

Saint-Mandé, Île-de-France, France (Hybrid)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Microsoft - Software Quality Engineer

Microsoft

Bengaluru, Karnataka, India (On-Site)
1 Week ago
Anavation - Systems Administrator (SME)

Anavation

Clarksburg, West Virginia, United States (Remote)
4 Weeks ago
N-iX - Lead Java Engineer

N-iX

Poland (Remote)
2 Weeks ago
G- space studios - Unreal Engine Network Developer

G- space studios

(Remote)
1 Day ago
Ubisoft - Linux DevOps System Administrator

Ubisoft

Montreal, Quebec, Canada (On-Site)
2 Days ago
Milestone - Senior DevOps Engineer

Milestone

Copenhagen, Denmark (Hybrid)
2 Weeks ago
Trend Micro - (Sr.) Cloud Backend Engineer

Trend Micro

Taipei City, Taiwan (On-Site)
7 Months ago
Hawk Eye Innovations - IT Support Coordinator

Hawk Eye Innovations

Atlanta, Georgia, United States (Hybrid)
2 Weeks ago
Nagarro - Associate Principal Engineer - Scrum Master

Nagarro

Colombia (Remote)
4 Months ago
IManage - Full Stack Senior Developer (ReactJS, NodeJS)

IManage

Bengaluru, Karnataka, India (Hybrid)
6 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

PwC - Senior Data Scientist

PwC

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
7 Months ago
PwC - Internal Auditor

PwC

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
3 Months ago
Google - Technical Account Manager, Google Cloud Consulting

Google

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
1 Week ago
PwC - Associate - Governance, Risk & Compliance (GRC) Enablement Solutions

PwC

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
6 Months ago
ByteDance - Knowledge Management Analyst - Global Payment

ByteDance

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
1 Month ago
Sony Music Career - Senior Artists & Repertoire Manager

Sony Music Career

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
18 Hours ago
QS Quacquarelli Symonds - Events Assistant

QS Quacquarelli Symonds

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (Hybrid)
3 Weeks ago
PwC - Senior Manager - Financial Risk Management

PwC

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
6 Months ago
USE Insider - Sales Development Representative - Malaysia

USE Insider

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
6 Months ago
Larian Studios - Junior Gameplay Programmer

Larian Studios

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
3 Weeks ago

Get notifed when new similar jobs are uploaded

DevOps Jobs

Microsoft - Senior Software Engineer

Microsoft

Charlotte, North Carolina, United States (On-Site)
2 Days ago
Ubisoft - Intermediate/Senior Tools Programmer

Ubisoft

Malmö, Skåne County, Sweden (Hybrid)
1 Month ago
Meta - Production Engineer

Meta

Warsaw, Masovian Voivodeship, Poland (On-Site)
5 Months ago
ByteDance - Software Engineer - Compute Infrastructure (Orchestration & Scheduling)

ByteDance

Seattle, Washington, United States (On-Site)
2 Weeks ago
Gearbox Software - Senior Site Reliability Engineer

Gearbox Software

Frisco, Texas, United States (On-Site)
5 Months ago
NVIDIA - Senior DevOps Engineer, Deep Learning Frameworks

NVIDIA

Warsaw, Masovian Voivodeship, Poland (On-Site)
3 Months ago
Argus Labs - Site Reliability Engineer (South East Asia)

Argus Labs

(Remote)
3 Weeks ago
ION - Senior Technical Consultant – IT2

ION

Central Sulawesi, Indonesia (On-Site)
6 Months ago
Krafton  - [Infra Div.] Game DevOps Engineer (BGMI) (3년 ~ 5년)

Krafton

Seoul, South Korea (On-Site)
5 Months ago
N-iX - Middle Support Engineer (Java/AWS)

N-iX

Colombia (Remote)
2 Weeks ago

Get notifed when new similar jobs are uploaded

About The Company

Luxoft, a DXC Technology Company (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Acquired by U.S. company DXC Technology in 2019, Luxoft is a global operation in 44 cities and 21 countries with an international, agile workforce of nearly 18,000 people. It combines a unique blend of engineering excellence and deep industry expertise, helping over 425 global clients innovate in the areas of automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications.

DXC Technology is a leading Fortune 500 IT services company which helps global companies run their mission critical systems. Together, DXC and Luxoft offer a differentiated customer-value proposition for digital transformation by combining Luxoft’s front-end digital capabilities with DXC’s expertise in IT modernization and integration. Follow our profile for regular updates and insights into technology and business needs.

Poland, Ohio, United States (Remote)

Kraków, Lesser Poland Voivodeship, Poland (On-Site)

Wrocław, Lower Silesian Voivodeship, Poland (On-Site)

Ukrainka, Kyiv Oblast, Ukraine (Remote)

Bengaluru, Karnataka, India (On-Site)

Mississauga, Ontario, Canada (On-Site)

Toronto, Ontario, Canada (On-Site)

Poland, Ohio, United States (Remote)

Pune, Maharashtra, India (On-Site)

View All Jobs

Get notified when new jobs are added by Luxoft

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug