About the role
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.
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. 3–5 years of relevant experience in Data Warehousing, ETL Development or Data Engineering.