Data Warehouse / EDW development

Luxoft; Malaysia; Sur place; MYR 180 000 - 300 000; Plein temps

Résumé du poste

Luxoft Malaysia is hiring a Software Engineer to join a newly established technology centre in Kuala Lumpur, supporting a leading Asia-Pacific bank. The role focuses on data integration, ETL/ELT design, and BI/analytics across GDW and Data Mart environments, using Teradata, Informatica, and a broad BI stack.

You will collaborate with global teams, implement robust data processing pipelines, and contribute to technology-driven banking operations across on-prem and cloud environments.

Qualifications

• 35 years of experience in Data Warehouse / EDW development.
• Experience in Global Data Warehouse (GDW) and Data Mart environments.
• Experience with the listed data warehouse, ETL, database and BI platforms.

Responsabilités

• Develop and maintain data integration solutions for Global Data Warehouse (GDW) and Data Mart environments.
• Work with Teradata IntelliFlex and Informatica Data Integration tools for data extraction, transformation and loading.
• Develop and maintain ETL processes using Informatica BDM, IDQ and IDL.
• Work with Teradata components, including TD Studio, MDM, FSLDM, GCFR and Viewpoint.
• Perform database operations and data processing across AS400 DB2, Teradata, Oracle, SQL Server and PostgreSQL.
• Work with data processing and analytics technologies, including Spark, HUE, Hive, Impala and Kafka.
• Support business intelligence and reporting solutions using Microsoft Business Intelligence, Qlik Sense, Power BI and Business Objects.
• Work with SAS, Microsoft R and Experian PowerCurve platforms.
• Use QuerySurge for data validation and testing activities.
• Support development and deployment activities using Jenkins, Bitbucket, SonarQube and Aldon.
• Work with JIRA for project tracking and Control-M for job scheduling.
• Perform development and support activities across AS400, AIX, Linux and Windows environments.

Connaissances

ETL/ELT design

Data Warehouse

GDW

Outils

Teradata IntelliFlex

TD Studio

MDM

FSLDM

GCFR

Viewpoint

Informatica BDM

IDQ

IDL

AS400 DB2

Teradata

Oracle

SQL Server

PostgreSQL

Spark

HUE

Hive

Impala

Kafka

Cloudera Data Science Workbench

Microsoft BI

Qlik Sense

SAS

Microsoft R

Power BI

Business Objects

Experian PowerCurve

QuerySurge

Jenkins

Bitbucket

SonarQube

Aldon

JIRA

Control-M

AIX

Linux

Windows

Description du poste

Job Description

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 Software Engineers.

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.

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

Responsibilities:

• Develop and maintain data integration solutions for Global Data Warehouse (GDW) and Data Mart environments.
• Work with Teradata IntelliFlex and Informatica Data Integration tools for data extraction, transformation and loading.
• Develop and maintain ETL processes using Informatica BDM, IDQ and IDL.
• Work with Teradata components, including TD Studio, MDM, FSLDM, GCFR and Viewpoint.
• Perform database operations and data processing across AS400 DB2, Teradata, Oracle, SQL Server and PostgreSQL.
• Work with data processing and analytics technologies, including Spark, HUE, Hive, Impala and Kafka.
• Support business intelligence and reporting solutions using Microsoft Business Intelligence, Qlik Sense, Power BI and Business Objects.
• Work with SAS, Microsoft R and Experian PowerCurve platforms.
• Use QuerySurge for data validation and testing activities.
• Support development and deployment activities using Jenkins, Bitbucket, SonarQube and Aldon.
• Work with JIRA for project tracking and Control-M for job scheduling.
• Perform development and support activities across AS400, AIX, Linux and Windows environments.

Mandatory Skills:

ETL/ELT design Teradata Data Warehouse

Mandatory Skills Description:

• 35 years of experience in Data Warehouse / EDW development.
• Experience working on Global Data Warehouse (GDW) and Data Mart environments.
• Relevant experience with the listed data warehouse, ETL, database and BI platforms.

Technical Skills

• Data Warehouse: Teradata IntelliFlex, TD Studio, MDM, FSLDM, GCFR, Viewpoint.
• ETL & Data Integration: Informatica BDM, IDQ, IDL.
• Databases: AS400 DB2, Teradata, Oracle, SQL Server, PostgreSQL.
• Big Data Technologies: Spark, HUE, Hive, Impala, Kafka, Cloudera Data Science Workbench.
• BI & Analytics: Microsoft Business Intelligence, Qlik Sense, SAS, Microsoft R, Power BI, Business Objects, Experian PowerCurve.
• Data Testing: QuerySurge.
• Development & Deployment Tools: Jenkins, Bitbucket, SonarQube, Aldon, JIRA.
• Job Scheduling: Control-M.
• Operating Systems: AS400, AIX, Linux, Windows.