Senior ETL Developer
About the job
Summary
- 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
- Microsoft Fabric
- Snowflake
- SSIS/SSAS/SSRS
- Azure DevTest Labs
- Azure PurView
- Banking/finance experience
- Python scripting
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
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.
Similar Jobs
(Remote)
(On-Site)
(Remote)
(Hybrid)
(On-Site)
(On-Site)
(On-Site)
(Hybrid)
(Remote)
Similar Skill Jobs
(Hybrid)
(Hybrid)
(On-Site)
(Hybrid)
(Remote)
(On-Site)
(Remote)
(Remote)
Jobs in Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia
(On-Site)
(On-Site)
(On-Site)
(On-Site)
(On-Site)
DevOps Jobs
(On-Site)
(On-Site)
(Hybrid)
(Remote)
(On-Site)
(Hybrid)
(Hybrid)
(On-Site)
