Developer (Enterprise Data Warehouse)

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

Role: Developer (Enterprise Data Warehouse)

Entity Reporting: Head of Delivery, ASEAN Business Unit

Functional Reporting: Service Delivery Manager

Job Scope Overview:

We are looking for an experienced Data Warehouse (EDW) Developer with 3–5 years of hands-on experience in enterprise data warehousing, data integration, data engineering, and business intelligence technologies.

The successful candidate will be responsible for developing, enhancing, maintaining, and supporting the Global Data Warehouse (GDW) and associated data marts. The role involves working with Teradata, Informatica, various database platforms, data integration tools, and BI technologies to deliver reliable and high-quality data solutions.

Key Responsibilities:

• Develop, enhance, and maintain Enterprise Data Warehouse (EDW), Global Data Warehouse (GDW), and data mart solutions.
• 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 AS400 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, Microsoft 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.

Experience, Qualifications and Requirements:

• 3–5 years of relevant experience in Data Warehousing, ETL Development or Data Engineering.
• Hands-on experience with Teradata and Informatica technologies.
• Strong SQL development skills, including Teradata SQL and Oracle SQL.
• Experience with databases such as Teradata, Oracle, DB2, SQL Server or PostgreSQL.
• Good knowledge of ETL, data integration, data quality and data validation processes.
• Familiarity with big data technologies such as Spark, Hive, Impala and Kafka.
• Experience with BI and reporting tools such as Qlik Sense, Power BI, MSBI or SAP BusinessObjects.
• Knowledge of development and DevOps tools such as Jenkins, Bitbucket, SonarQube, JIRA and Control-M.
• Good understanding of enterprise data warehouses, data marts and financial data models such as FSLDM/GCFR.
• Experience in data pipeline monitoring, batch scheduling and production support is an advantage.
• Exposure to Global Data Warehouse (GDW) implementation and support is preferred.
• Strong analytical, troubleshooting and problem-solving skills.
• Good communication skills and ability to work independently and collaborate with cross-functional teams.