Data Engineer

SAKSOFT PTE LIMITED; Singapore; On-site; SGD 90,000 - 160,000; Full time

Job summary

SAKSOFT PTE LIMITED in Singapore is seeking a Data Engineer with 10+ years of experience to design, develop, and maintain robust ETL workflows. You will build data pipelines using Python, Spark, Hive, and HDFS, and optimize SQL across Oracle, Teradata, or SQL Server.

This role emphasizes collaboration with BAs, QA, and stakeholders through Agile ceremonies. Ideal candidates will have strong analytical and problem‑solving abilities, experience in large-scale enterprise data platforms, and a track

Qualifications

• Must have strong ETL and data engineering fundamentals in a large-scale environment.
• Experience with Informatica PowerCenter and SQL databases across Oracle/Teradata/SQL Server.
• Proficiency in Python, Spark, Hive, and HDFS for data pipelines.
• Familiarity with Agile/Scrum ceremonies and production support activities.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter.
• Develop data pipelines with Python, Spark, Hive, and HDFS.
• Extract, transform, and load data from multiple source systems (ETL/ELT).
• Write and optimize SQL queries for Oracle, Teradata, or SQL Server.
• Prepare technical design docs, mappings, and data flow docs.
• Perform performance tuning, troubleshooting, and production support.
• Collaborate with Business Analysts, QA, and stakeholders through the project lifecycle.
• Participate in Agile/Scrum ceremonies and contribute to sprint planning and delivery.
• Support production deployments and incident resolution.

Skills

Informatica PowerCenter

SQL databases

Python

Apache Spark

Hive & HDFS

ETL concepts

Unix Shell Scripting

Production Support

Agile Scrum

Tools

Apache Sqoop

Apache NiFi

Control-M/AutoSys

Git/Bitbucket

Jenkins

Job description

Experience

10+ Years

Role

Data Engineer

Required Skills

Must Have

• Informatica PowerCenter
• SQL (Oracle / Teradata / SQL Server)
• Python
• Apache Spark
• Hive & HDFS
• ETL / Data Warehousing concepts
• Unix Shell Scripting
• Production Support
• Agile / Scrum

Good to Have

• Apache Sqoop
• Apache NiFi
• Control‑M or AutoSys
• Git / Bitbucket
• Jenkins
• Banking or Financial Services domain experience

Preferred Qualifications

• 8–12 years of experience in ETL and Data Engineering
• Strong analytical, problem‑solving, and communication skills
• Experience working with large‑scale enterprise data platforms

Key Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter
• Develop data pipelines using Python, Spark, Hive, and HDFS
• Perform data extraction, transformation, and loading (ETL/ELT) from multiple source systems
• Write and optimize SQL queries for Oracle, Teradata, or SQL Server databases
• Prepare technical design documents, mapping specifications, and data flow documentation
• Perform performance tuning, troubleshooting, and production support
• Coordinate with Business Analysts, QA, and business stakeholders throughout the project lifecycle
• Participate in Agile/Scrum ceremonies and contribute to sprint planning and delivery
• Support production deployments and incident resolution