Senior Data Engineer: Pipelines, SQL & Data Migrations

Encora Technologies Sdn Bhd; Kuala Lumpur; On-site; MYR 80,000 - 120,000; Full time

Job summary

A data engineering firm in Kuala Lumpur is looking for a Senior Data Engineer with extensive expertise in SQL and ETL processes. The role involves designing and optimizing data pipelines, migrating data across systems, and ensuring high-quality standards. Ideal candidates should have strong proficiency in SQL and tools like PostgreSQL and Informatica, along with hands-on experience in data transformation and API integration. This position offers a dynamic work environment focusing on enterprise data solutions.

Qualifications

• 6–7 years of strong SQL proficiency with complex SQL queries.
• 3+ years in SQL optimization within large-scale data environments.
• 6–7 years of ETL development experience with relevant tools.
• 6–7 years in database engineering with PostgreSQL or Oracle.
• 5+ years in data migration between heterogeneous systems.
• 5+ years of experience in data transformation focusing on data quality.
• 3+ years of REST API integration experience.

Responsibilities

• Design, develop, and optimize data pipelines and ETL workflows.
• Write complex SQL queries and performance-optimized transformations.
• Maintain data views and database objects for optimal query execution.
• Lead data migration initiatives across various systems.
• Implement data transformation logic for business rules.
• Integrate external data sources through RESTful APIs.
• Ensure data quality and consistency across environments.
• Participate in cut-over planning and deployment.

Skills

SQL Proficiency

ETL Development

Database Engineering

Data Migration

REST API Integration

Data Transformation

Tools

PostgreSQL

Oracle

Informatica

Datastage

ODI

Job description

A data engineering firm in Kuala Lumpur is looking for a Senior Data Engineer with extensive expertise in SQL and ETL processes. The role involves designing and optimizing data pipelines, migrating data across systems, and ensuring high-quality standards. Ideal candidates should have strong proficiency in SQL and tools like PostgreSQL and Informatica, along with hands-on experience in data transformation and API integration. This position offers a dynamic work environment focusing on enterprise data solutions.