Data Engineer - ODS, Silver/Gold & 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 Data Engineer to lead the migration of a large EDW, build ODS, Bronze/Silver/Gold layers and modern ELT pipelines.

You will convert legacy IBM DataStage ETL into in-platform ELT, implement data quality checks, CDC, and data reconciliation, and work on GaussDB/DWS, Snowflake, Teradata or BigQuery environments.

Qualifications

• Minimum 7 years of experience in Data Engineering, ETL/ELT development, and enterprise data warehouse programs.
• Strong hands-on experience with IBM DataStage, including analyzing and converting legacy ETL jobs.
• Advanced SQL skills, including complex queries, stored procedures, data transformation, and performance tuning.
• Experience building Operational Data Stores (ODS) and Bronze, Silver, and Gold data layers.
• Experience with data warehouse migration, preferably from IBM Netezza or similar MPP platforms.
• Knowledge of target platforms such as GaussDB/DWS, Snowflake, Teradata, or BigQuery.
• Experience with data migration, CDC, incremental loading, and data reconciliation.
• Strong understanding of data quality, validation, and performance optimization.
• Banking or financial services experience is highly preferred.

Responsibilities

• Build and maintain ODS, Silver, and Gold data warehouse layers.
• Convert legacy IBM DataStage ETL jobs into modern in-platform ELT pipelines.
• Migrate data models, schemas, and database objects from legacy MPP platforms to modern target platforms.
• Develop and maintain GCIF (Golden Customer Information File) and SCV (Single Customer View) pipelines.
• Implement data loading, transformation, and orchestration processes.
• Perform data reconciliation, validation, and quality checks.
• Support SIT, UAT, performance testing, and parallel run activities.
• Troubleshoot and optimize SQL queries and data pipelines.

Skills

Mandarin Chinese communication

English communication

SQL

ETL/ELT development

Data quality

Data reconciliation

Performance tuning

Data modeling concepts

Tools

IBM DataStage

GaussDB/DWS

Snowflake

Teradata

BigQuery

CDC

Control-M

Autosys

Zena

Job description

WE'RE HIRING: DATA ENGINEER - ODS, SILVER/GOLD & MIGRATION

If you cannot communicate effectively in spoken Mandarin Chinese, PLEASE DO NOT APPLY.

Click Global Talent is looking for an experienced Data Engineer to join a large-scale Enterprise Data Warehouse (EDW) migration and modernization program.

We are looking for a hands-on Data Engineer who can develop and migrate data pipelines, convert legacy IBM DataStage ETL processes into modern ELT solutions, and build ODS, Silver, and Gold data layers.

Mandarin Chinese and English communication skills - MANDATORY.

Minimum 7 years of experience in Data Engineering, ETL/ELT development, and enterprise data warehouse programs.

Strong hands-on experience with IBM DataStage, including analyzing and converting legacy ETL jobs.

Advanced SQL skills, including complex queries, stored procedures, data transformation, and performance tuning.

Experience building Operational Data Stores (ODS) and Bronze, Silver, and Gold data layers.

Experience with data warehouse migration, preferably from IBM Netezza or similar MPP platforms.

Knowledge of target platforms such as GaussDB/DWS, Snowflake, Teradata, or BigQuery.

Experience with data migration, CDC, incremental loading, and data reconciliation.

Strong understanding of data quality, validation, and performance optimization.

Banking or financial services experience is highly preferred.

KEY RESPONSIBILITIES

Build and maintain ODS, Silver, and Gold data warehouse layers.

Convert legacy IBM DataStage ETL jobs into modern in-platform ELT pipelines.

Migrate data models, schemas, and database objects from legacy MPP platforms to modern target platforms.

Develop and maintain GCIF (Golden Customer Information File) and SCV (Single Customer View) pipelines.

Implement data loading, transformation, and orchestration processes.

Perform data reconciliation, validation, and quality checks.

Support SIT, UAT, performance testing, and parallel run activities.

Troubleshoot and optimize SQL queries and data pipelines.

NICE-TO-HAVE EXPERIENCE

Data Vault 2.0.

Sunline DataMind or equivalent ELT tools.

Python and Shell scripting.

Control-M, Autosys, or Zena.

Git, JIRA, and CI/CD workflows.

Experience in core banking, deposits, loans, treasury, and regulatory reporting.

#Hiring #DataEngineer #MandarinSpeaker #ChineseSpeaker #DataEngineering #DataMigration #DataWarehouse #IBMDataStage #ETL #ELT #BankingTechnology #RemoteJobs #ClickGlobalTalent