Data Pipeline Engineer - ETL & Data Quality

Pan Asia Software Solutions; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

Pan Asia Software Solutions in Singapore is seeking an experienced ETL Developer to design, develop, and maintain scalable data pipelines that move data from diverse sources into data warehouses or data lakes for analytics.

The role requires hands-on SQL expertise, experience with major ETL tools, and familiarity with warehousing concepts (e.g., Snowflake) to ensure data quality and timely delivery.

Qualifications

• 3+ years of hands-on experience as an ETL Developer or Data Engineer.
• Expert proficiency in SQL for writing complex queries and procedures.
• Experience with at least one major ETL tool (Informatica, Talend or cloud equivalent).
• Familiarity with data warehousing concepts and data modeling.

Responsibilities

• Pipeline Development: Design, build, and deploy ETL/ELT pipelines using tools like Informatica, Talend, NiFi, or cloud native services.
• Data Transformation: Write complex SQL queries, stored procedures, and scripts to clean, transform, and aggregate data.
• Monitoring and Optimization: Monitor pipeline performance and troubleshoot data flow issues to improve latency.
• Documentation: Create and maintain technical documentation for data mappings and ETL processes.
• Data Quality: Implement validation and error handling to ensure data accuracy in the warehouse.

Skills

SQL

Data pipelines

Data validation

Education

Bachelor’s degree or equivalent experience

Tools

Informatica

Talend

Apache NiFi

AWS Glue

Azure Data Factory

Snowflake

Job description

Pan Asia Software Solutions in Singapore is seeking an experienced ETL Developer to design, develop, and maintain scalable data pipelines that move data from diverse sources into data warehouses or data lakes for analytics.

The role requires hands-on SQL expertise, experience with major ETL tools, and familiarity with warehousing concepts (e.g., Snowflake) to ensure data quality and timely delivery.