ETL Developer

RISKDATA CONSULTING PTE. LTD.; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

A technology consulting firm in Singapore is hiring an ETL Developer responsible for ETL/ELT processes, SQL query optimization, and developing comprehensive documentation. Candidates should have solid experience in data pipeline development and integration workflows. This role offers an opportunity to work with diverse data sources in a dynamic environment.

Qualifications

• Experience in ETL/ELT processes.
• Strong SQL skills for complex queries.
• Ability to implement data integration workflows.

Responsibilities

• Develop and maintain ETL/ELT processes for data transformation.
• Write, optimize, and maintain complex SQL queries.
• Develop technical documentation and user manuals.

Job description

We are hiring ETL Developer with below requirements;

Responsibilities

• ETL / Data Pipeline Development
  • Develop and maintain ETL/ELT processes to, transform, and load data from various sources.
  • Implement data integration workflows.
  • Ensure pipelines are efficient, fault-tolerant, and well-documented.
  • Automate data movement and transformation tasks where possible.
• Database Development & Performance Optimization
  • Write, optimize, and maintain complex SQL queries, stored procedures, and scripts.
  • Monitor and tune database performance, indexing, and query execution plans.
  • Manage data versioning, schema evolution, and migrations.
  • Maintain database integrity, security, and backup processes.
• Verification & Validation
  • Perform end-to-end verification & validation.
• Documentation and Knowledge Transfer
  • Develop comprehensive technical documentation including architecture, deployment, and operational guides

Create user manuals and administrative procedures