ETL Developer (Extract, Transform, Load) – Singapore

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

The ETL Developer is responsible for designing, developing, and maintaining scalable and efficient data pipelines that move and transform data from various sources into target data warehouses or data lakes, ensuring data quality and accessibility for analytics.

Key Responsibilities

• Pipeline Development: Design, build, and deploy robust ETL/ELT pipelines using tools like Informatica, Talend, Apache NiFi, or cloud-native services (e.g., AWS Glue, Azure Data Factory).
• Data Transformation: Write complex SQL queries, stored procedures, and scripts to clean, transform, and aggregate data according to business rules.
• Monitoring and Optimization: Monitor pipeline performance, troubleshoot data flow issues, and optimize ETL jobs for efficiency and latency.
• Documentation: Create and maintain technical documentation for data mappings, ETL processes, and database schemas.
• Data Quality: Implement data validation and error handling logic to ensure the accuracy and consistency of data within the warehouse.

Required Qualifications

• Bachelor’s degree in a technical field or equivalent work experience.
• 3+ years of hands-on experience as an ETL Developer or Data Engineer.
• Expert proficiency in SQL for writing complex queries and procedures.
• Proven experience with at least one major ETL tool (e.g., Informatica, Talend, or a cloud equivalent).
• Familiarity with data warehousing concepts and data modeling (e.g., Snowflake).