EDW Developer (Teradata / Informatica)

Hong Kong Unison Limited

Kuala Lumpur

On-site

MYR 90,000 - 150,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Hong Kong Unison Limited is seeking an experienced EDW Developer with 3–5 years in Enterprise Data Warehousing, Teradata and Informatica technologies.

The candidate should have hands-on experience in data integration, ETL development, SQL, data processing and supporting Global Data Warehouse (GDW) and Data Mart projects.

Qualifications

  • 3–5 years of experience in Data Warehousing / EDW development.
  • Hands-on experience with Teradata.
  • Knowledge of Teradata IntelliFlex.
  • Experience with Informatica Data Integration suite of tools.
  • Knowledge of Informatica BDM, IDQ and IDL.
  • Strong SQL and database concepts.
  • Understanding of ETL and data integration processes.
  • Experience working with GDW and Data Marts.

Responsibilities

  • Develop, maintain and support Enterprise Data Warehouse (EDW) solutions.
  • Work on Global Data Warehouse (GDW) and Data Mart development.
  • Develop and support ETL workflows using Informatica Data Integration tools.
  • Work with Teradata databases for data processing and SQL development.
  • Perform data extraction, transformation, loading and validation activities.
  • Work with different databases, including AS400 DB2, Teradata, Oracle, SQL Server and PostgreSQL.
  • Support data quality, data profiling and data validation activities.
  • Troubleshoot data integration and database-related issues.
  • Collaborate with business analysts, data architects and development teams.

Skills

Teradata
Informatica
SQL
ETL
Data Warehousing
GDW
Data Marts
IntelliFlex
IDQ
BDM
IDL

Tools

Informatica Data Integration Suite
Informatica BDM
Informatica IDQ
Informatica IDL

Job description

Job Title: EDW Developer
Experience: 3–5 Years
Level: L2
Domain: Data / Enterprise Data Warehouse
Primary Skills: Teradata, Informatica
Database: AS400 DB2, Teradata, Oracle, SQL Server, PostgreSQL
Operating Systems: AS400, AIX, Linux, Windows

Job Title: EDW Developer
Experience: 3–5 Years
Level: L2
Domain: Data / Enterprise Data Warehouse
Primary Skills: Teradata, Informatica
Database: AS400 DB2, Teradata, Oracle, SQL Server, PostgreSQL
Operating Systems: AS400, AIX, Linux, Windows

Job Overview

We are looking for an experienced EDW Developer with 3–5 years of experience in Enterprise Data Warehousing, Teradata and Informatica technologies.

The candidate should have hands-on experience in data integration, ETL development, SQL, data processing and supporting Global Data Warehouse (GDW) and Data Mart projects.

Key Responsibilities
  • Develop, maintain and support Enterprise Data Warehouse (EDW) solutions.
  • Work on Global Data Warehouse (GDW) and Data Mart development.
  • Develop and support ETL workflows using Informatica Data Integration tools.
  • Work with Teradata databases for data processing and SQL development.
  • Perform data extraction, transformation, loading and validation activities.
  • Work with different databases, including AS400 DB2, Teradata, Oracle, SQL Server and PostgreSQL.
  • Support data quality, data profiling and data validation activities.
  • Troubleshoot data integration and database-related issues.
  • Collaborate with business analysts, data architects and development teams.
Mandatory / Core Technical Skills
  • 3–5 years of experience in Data Warehousing / EDW development.
  • Hands‑on experience with Teradata.
  • Knowledge of Teradata IntelliFlex.
  • Experience with Informatica Data Integration suite of tools.
  • Knowledge of Informatica BDM, IDQ and IDL.
  • Strong SQL and database concepts.
  • Understanding of ETL and data integration processes.
  • Experience working with GDW and Data Marts.
Database Technologies
  • AS400 DB2
  • Teradata
  • Oracle
  • Microsoft SQL Server
  • PostgreSQL
Additional Technical Skills

Data & Analytics:

  • SAS
  • Microsoft R
  • Spark
  • Cloudera Data Science Workbench
  • Hive, Impala and HUE
  • Kafka
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

EDW Developer (Teradata / Informatica)
EDW Developer (Teradata / Informatica)

Unison Group • Kuala Lumpur

On-site
MYR 120,000 - 180,000
Developer (Enterprise Data Warehouse)
Developer (Enterprise Data Warehouse)

GienTech • Kuala Lumpur

On-site
MYR 90,000 - 130,000
EDW Developer | Teradata & Informatica Specialist
EDW Developer | Teradata & Informatica Specialist

Unison Group • Kuala Lumpur

On-site
MYR 120,000 - 180,000
EDW Developer(Data Warehouse)
EDW Developer(Data Warehouse)

Luxoft • Kuala Lumpur

On-site
MYR 120,000 - 180,000
Data Warehouse / EDW development
Data Warehouse / EDW development

Luxoft • Malaysia

On-site
MYR 180,000 - 300,000
EDW Developer
EDW Developer

DXC Luxoft • Kuala Lumpur

On-site
MYR 120,000 - 180,000
Data Warehouse Engineer
Data Warehouse Engineer

Luxoft • Kuala Lumpur

On-site
MYR 180,000 - 240,000
Enterprise Data Warehouse Developer | EDW & GDW Specialist
Enterprise Data Warehouse Developer | EDW & GDW Specialist

GienTech • Kuala Lumpur

On-site
MYR 90,000 - 130,000
Developer (Informatica ETL)
Developer (Informatica ETL)

GienTech • Kuala Lumpur

On-site
MYR 90,000 - 130,000
Senior Informatica & Data Analytics Lead | ETL/DW Expert
Senior Informatica & Data Analytics Lead | ETL/DW Expert

Unison Group • Kuala Lumpur

On-site
MYR 180,000 - 260,000