Hiring.Camp

EDW Developer (Teradata / Informatica)

Unison Group

·

Today

Location
Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia
Workplace
Onsite
Type
Full-time
Department
Noresh
Seniority
Mid
Experience
3+ years
Source
Workable

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

Skills

LinuxSQLPostgreSQLOracleSQL ServerSparkData ScienceETLApache Kafka