# EDW Developer (Teradata / Informatica)

**Company:** [Unison Group](https://jobs.workable.com/companies/deKpPhPMtQZga7XoPG1tSo.md)
**Location:** Kuala Lumpur, Malaysia
**Workplace:** on site
**Employment type:** Full-time
**Department:** Noresh

[Apply for this job](https://jobs.workable.com/view/b7cffc64-0600-457a-a854-e2733838d5a0)

## 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 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
