EDW Developer (Teradata / Informatica)

Unison GroupKuala Lumpur, Kuala LumpurOn-siteFull-timeMid level, 2–5 yearsListed 1 day ago

Apply now

About this role

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