Lead ETL Engineer — Data Warehouse Migration

Click Global Talent; Kuala Lumpur; On-site; MYR 180,000 - 260,000; Full time

Job summary

Click Global Talent in Kuala Lumpur is seeking an experienced ETL Lead to manage a small team and drive a Data Warehouse migration project (Netezza). You will design, develop, and optimize ETL pipelines, perform data migrations, and ensure data integrity across target systems.

The role requires 5–6 years in Data/ETL engineering, strong SQL/Python skills, and hands-on experience with Talend or NiFi. You will collaborate with business, QA, and technical teams and produce runbooks and documentation.

Qualifications

• 5–6 years of experience as a Data/ETL Engineer.
• Experience leading a small technical team.
• Strong hands-on experience with databases (Oracle, Netezza, MS SQL).
• Proficient in SQL, Python, and scripting.
• Hands-on experience with ETL tools such as Talend, NiFi, or similar.
• Experience building stored procedures and data processing logic.
• Strong experience in performance tuning and query optimization.
• Basic knowledge of Linux/Unix commands.
• Experience in Data Warehouse migration projects.
• Familiar with Hadoop/Cloudera ecosystem.
• Exposure to Data Warehouse and Data Lake environments.
• Nice to Have: Banking or financial services experience.
• Exposure to Huawei stack (GaussDB, MRS)
• Knowledge in reporting tool such as Qlik is added advantage.

Responsibilities

• Lead and manage a team of 3–4 ETL engineers.
• Design, develop, and optimize ETL pipelines (extract, transform, load).
• Perform data migration from Netezza to target systems.
• Develop and optimize stored procedures and ETL workflows.
• Monitor job execution, troubleshoot issues, and perform performance tuning.
• Implement data validation and support reconciliation activities.
• Collaborate with business, QA, and technical teams.
• Prepare technical documentation and runbooks.

Skills

Team leadership

SQL

Python

Scripting

ETL Tools

Data Warehousing

Performance tuning

Tools

Talend

NiFi

Oracle

Netezza

MS SQL

Job description

Click Global Talent in Kuala Lumpur is seeking an experienced ETL Lead to manage a small team and drive a Data Warehouse migration project (Netezza). You will design, develop, and optimize ETL pipelines, perform data migrations, and ensure data integrity across target systems.

The role requires 5–6 years in Data/ETL engineering, strong SQL/Python skills, and hands-on experience with Talend or NiFi. You will collaborate with business, QA, and technical teams and produce runbooks and documentation.