ETL Consultant

ENCORA TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

ENCORA TECHNOLOGIES PTE. LTD.

is seeking an ETL Consultant to design, develop, implement and maintain ETL processes that integrate data from multiple sources into data warehouses, data lakes and BI platforms. You will ensure data accuracy, quality, consistency and availability for reporting, analytics and business decisions, leveraging Talend, Informatica, SSIS and various RDBMS such as Oracle, SQL Server, MySQL.

Qualifications

• Hands-on ETL development and data integration across multiple sources.
• Strong SQL skills, including complex queries, joins, stored procedures, and performance tuning.
• Experience with Informatica PowerCenter, SSIS, and Talend ETL tools.

Responsibilities

• Design, develop, implement, and maintain ETL processes to consolidate data into data warehouses and data lakes.
• Ensure data accuracy, quality, consistency, and availability for reporting and decision-making.

Skills

ETL development

Data integration

Data warehousing

SQL

Performance tuning

Tools

Talend

Informatica PowerCenter

SSIS

Microsoft SQL Server

Oracle DB

MySQL

PostgreSQL

Job description

The ETL Consultant is responsible for designing, developing, implementing, and maintaining Extract, Transform, and Load (ETL) processes to integrate data from multiple sources into data warehouses, data lakes, and business intelligence platforms. The role ensures data accuracy, quality, consistency, and availability for reporting, analytics, and business decision-making

Data Migration / ETL Skillset on platforms:Talend / Informatica / SQL DB / Oracle DBHands-on experience in ETL development, data integration, and data warehousing.

Strong SQL skills, including complex queries, joins, stored procedures, and performance tuning.

Experience with ETL tools such as:Informatica PowerCenterMicrosoft SQL Server Integration Services (SSIS)TalendRelational databases such as SQL Server, Oracle, MySQL, or PostgreSQL.