Jobless Developer
Unison Group logo

Posted 1 day ago

EDW Developer (Teradata / Informatica)Unison Group · Kuala Lumpur

EDW Developer (Teradata / Informatica)

Kuala LumpurOn-siteFull-time

AI Summary

Develops, maintains and supports Enterprise Data Warehouse solutions, including Global Data Warehouse and Data Mart projects, building Informatica ETL workflows and Teradata SQL to extract, transform, load and validate data across multiple database platforms.

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

Skills

AS400 DB2Data MartsETLGlobal Data WarehouseHiveImpalaInformaticaInformatica BDMInformatica IDLInformatica IDQKafkaOraclePostgreSQLSASSparkSQLSQL ServerTeradataTeradata IntelliFlex

Explore related jobs

Browse these categories

Market data for this role

All reports →