Senior ETL Engineer - Data Warehouse Migration Specialist

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

Job summary

Click Global Talent in Kuala Lumpur is seeking a Senior ETL Engineer to support a one-time Data Warehouse migration project (Netezza). This hands-on role focuses on building, tuning, and running ETL pipelines to ensure accurate data migration.

You will collaborate with QA and business teams, develop stored procedures, optimize SQL and Python scripts, and prepare runbooks and technical documentation.

Qualifications

• 3–5 years of experience as a Data/ETL Engineer
• Experience with databases (Oracle, Netezza, MS SQL)
• Proficient in SQL, Python, and scripting
• Experience with ETL tools such as Talend, NiFi, or similar
• Experience developing stored procedures and ETL workflows
• Strong knowledge of performance tuning and query optimization
• Basic knowledge of Linux/Unix commands
• Experience in Data Warehouse/Data migration projects
• Familiar with Hadoop/Cloudera ecosystem
• Exposure to Data Warehouse and Data Lake environments
• Nice to Have: Banking or financial services experience
• Nice to Have: Large-scale or enterprise data migration projects
• Nice to Have: Huawei stack (GaussDB, MRS)

Responsibilities

• Design, develop, and maintain ETL pipelines (extract, transform, load)
• Perform data extraction from Netezza and load into target systems
• Develop and optimize stored procedures and transformation logic
• Execute migration jobs and support batch processing activities
• Perform performance tuning for ETL jobs and SQL queries
• Troubleshoot data and pipeline issues during migration runs
• Implement data validation checks and support reconciliation
• Work closely with Lead, QA, and business teams to ensure data accuracy
• Prepare technical documentation and job runbooks

Skills

SQL scripting

Python scripting

Performance tuning

Data validation

ETL design

Education

Bachelor's degree in a related field

Tools

Talend

NiFi

Netezza

Oracle

MS SQL

Linux/Unix

Job description

Click Global Talent in Kuala Lumpur is seeking a Senior ETL Engineer to support a one-time Data Warehouse migration project (Netezza). This hands-on role focuses on building, tuning, and running ETL pipelines to ensure accurate data migration.

You will collaborate with QA and business teams, develop stored procedures, optimize SQL and Python scripts, and prepare runbooks and technical documentation.