Enterprise Data Warehouse Developer | EDW & GDW Specialist

GienTech; Kuala Lumpur; On-site; MYR 90,000 - 130,000; Full time

Job summary

GienTech is seeking an experienced Developer (Enterprise Data Warehouse) in Kuala Lumpur to design, implement, and maintain the Global Data Warehouse and related data marts. You will work with Teradata, Informatica, and BI tools to deliver reliable data solutions across multiple environments.

The role requires 3–5 years in data warehousing, ETL, or data engineering, with hands-on Teradata and Informatica experience.

Qualifications

• 3–5 years of relevant experience in Data Warehousing, ETL Development or Data Engineering.

Responsibilities

• Develop, enhance, and maintain Enterprise Data Warehouse (EDW), Global Data Warehouse (GDW), and data marts.
• Design, develop, and optimize ETL processes and data integration workflows using Informatica Data Integration tools.
• Work with Teradata IntelliFlex and Teradata platforms for data warehousing and data processing.
• Develop and optimize complex SQL queries, stored procedures, and database objects across Teradata, Oracle, SQL Server, PostgreSQL, and DB2.
• Perform data profiling, data quality assessments, validation, and reconciliation using Informatica IDQ and QuerySurge.
• Work with data management frameworks and technologies, including MDM, FSLDM/GCFR, and ViewPoint.
• Support data analytics and reporting requirements using Qlik Sense, Power BI, Business Objects, SAS, and Microsoft R.
• Work with big data technologies such as Hadoop ecosystem tools, Spark, Hive, Impala, Kafka, and Cloudera Data Science Workbench.
• Participate in code reviews, version control, and deployment activities using Git/Bitbucket, Jenkins, and SonarQube.
• Manage batch processing and scheduling activities using Control-M and other relevant tools.
• Troubleshoot data-related issues, perform root cause analysis, and ensure data accuracy, integrity, and performance.
• Collaborate with business analysts, data architects, QA teams, and other technical stakeholders to deliver data solutions.
• Support development, testing, deployment, and production maintenance activities across multiple environments.

Skills

Data warehousing

ETL development

Data engineering

SQL development

Data profiling

Data quality

Data validation

Analytical skills

Troubleshooting

Communication

Tools

Teradata

Informatica

Teradata IntelliFlex

Oracle

SQL Server

DB2

PostgreSQL

Hadoop

Spark

Hive

Impala

Kafka

Qlik Sense

Power BI

SAS

SAP BusinessObjects

Jenkins

Bitbucket

SonarQube

JIRA

Control-M

Job description

GienTech is seeking an experienced Developer (Enterprise Data Warehouse) in Kuala Lumpur to design, implement, and maintain the Global Data Warehouse and related data marts. You will work with Teradata, Informatica, and BI tools to deliver reliable data solutions across multiple environments.

The role requires 3–5 years in data warehousing, ETL, or data engineering, with hands-on Teradata and Informatica experience.