EDW Developer

DXC Luxoft; Kuala Lumpur; In loco; MYR 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

Luxoft is seeking an experienced Data Warehouse Engineer in Kuala Lumpur to contribute to the Global Data Warehouse and Data Mart initiatives. The role involves developing and maintaining ETL pipelines, working with Teradata, Informatica, and a broad BI stack, and supporting data processing across multiple platforms and operating systems.

You will collaborate with teams to validate data, ensure data quality, and support BI reporting using Power BI, Qlik Sense, SAS, and other tools.

Competenze

• 3–5 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.

Mansioni

• 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 BI, 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.

Strumenti

Teradata IntelliFlex

TD Studio

MDM

FSLDM

GCFR

Viewpoint

Informatica BDM

Informatica IDQ

Informatica IDL

AS400 DB2

Teradata

Oracle

SQL Server

PostgreSQL

Spark

Hive

Impala

Kafka

HUE

Cloudera Data Science Workbench

Microsoft BI

Qlik Sense

SAS

Power BI

Business Objects

Experian PowerCurve

QuerySurge

Jenkins

Bitbucket

SonarQube

Aldon

JIRA

Control-M

AS400

AIX

Linux

Windows

Descrizione del lavoro

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.

SKILLS

Must have

• 3–5 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.

Nice to have

NA