Data Engineer (Python / AWS)

ScienTec Consulting Pte. Ltd.; Singapore; On-site; SGD 66,000 - 79,000; Full time

Job summary

ScienTec Consulting Pte. Ltd. is seeking an experienced Data Engineer to design, build, and maintain data pipelines across Oracle and AWS environments. You will ensure data quality and reliability while supporting analytics initiatives.

You will develop ETL/ELT processes, optimise Oracle databases, and leverage AWS services to create scalable data solutions. Collaboration with developers and analysts is key to delivering robust data architectures.

Qualifications

• Experience in Data Engineering and ETL development.
• Strong Oracle database skills: SQL, PL/SQL, stored procedures.
• Experience with AWS cloud services and data engineering.
• Proficient in data modelling and data warehousing concepts.
• Scripting in Python or Shell.

Responsibilities

• Design, develop and maintain scalable data pipelines and ETL/ELT processes to support data integration and transformation requirements.
• Develop, optimise and maintain Oracle database solutions, including SQL queries, PL/SQL scripts, stored procedures and database performance tuning.
• Leverage AWS cloud services to build, deploy and manage cloud-based data engineering solutions.
• Perform data extraction, transformation, loading and validation across multiple data sources and systems.
• Develop and maintain data integration workflows to support data migration, synchronisation and reporting requirements.
• Monitor and troubleshoot data pipelines, database performance and data processing issues to ensure reliability and efficiency.
• Implement data quality checks, data validation and error-handling mechanisms to maintain data accuracy and integrity.
• Work closely with application developers, solution architects, business analysts and stakeholders to understand data requirements and deliver technical solutions.
• Support database optimisation, data migration and cloud modernisation initiatives.
• Ensure data solutions comply with established security, governance and operational standards.

Skills

Oracle

SQL

PL/SQL

AWS

ETL/ELT

Python

Data modelling

Shell scripting

CI/CD

Git

Education

Bachelor's degree in Computer Science or related field

Tools

AWS Glue

Redshift

S3

DMS

Lambda

CloudWatch

Job description

We are looking for an experienced Data Engineer to design, develop and maintain data pipelines, data integration solutions and database systems across Oracle and AWS environments. You will be responsible for building and optimising data processing workflows, ensuring data quality and reliability, and supporting the organisation's data management and analytics initiatives.

• Working Hours: Mon-Fri
• Working Location: Central
• Salary Package: Up to $6,500 (basic) + AWS + VB

Key Responsibilities

• Design, develop and maintain scalable data pipelines and ETL/ELT processes to support data integration and transformation requirements.
• Develop, optimise and maintain Oracle database solutions, including SQL queries, PL/SQL scripts, stored procedures and database performance tuning.
• Leverage AWS cloud services to build, deploy and manage cloud-based data engineering solutions.
• Perform data extraction, transformation, loading and validation across multiple data sources and systems.
• Develop and maintain data integration workflows to support data migration, synchronisation and reporting requirements.
• Monitor and troubleshoot data pipelines, database performance and data processing issues to ensure reliability and efficiency.
• Implement data quality checks, data validation and error-handling mechanisms to maintain data accuracy and integrity.
• Work closely with application developers, solution architects, business analysts and stakeholders to understand data requirements and deliver technical solutions.
• Support database optimisation, data migration and cloud modernisation initiatives.
• Ensure data solutions comply with established security, governance and operational standards.

Requirements

• Degree in Computer Science, Information Technology, Engineering or a related discipline.
• Proven experience in Data Engineering, Database Development or ETL development.
• Strong hands-on experience with Oracle databases, including SQL, PL/SQL, stored procedures, functions and query optimisation.
• Practical experience with AWS cloud services and cloud-based data engineering solutions.
• Experience developing and maintaining ETL/ELT pipelines and data integration workflows.
• Good understanding of data modelling, database design, data warehousing and data management concepts.
• Experience with data processing, transformation, validation and troubleshooting.
• Familiarity with scripting languages such as Python, Shell scripting or similar.
• Strong analytical, troubleshooting and problem-solving skills.
• Good communication skills and ability to work collaboratively with technical and business stakeholders.

Good to Have

• AWS services such as Amazon S3, AWS Glue, Lambda, Redshift, RDS and CloudWatch.
• Experience with AWS Database Migration Service (DMS).
• Exposure to Oracle Database migration or modernisation to AWS.
• Experience with Apache Spark, PySpark or other big data technologies.
• Familiarity with CI/CD, Git and Infrastructure as Code (IaC).
• AWS certifications such as AWS Certified Data Engineer - Associate or AWS Solutions Architect - Associate.

By submitting your resume, you consent to the collection, use, and disclosure of your personal information per ScienTec's Privacy Policy(scientecconsulting.com/privacy-policy).

• Contact you about potential opportunities.
• Delete personal data as it is not required at this application stage.
• All applications will be processed with strict confidence. Only shortlisted candidates will be contacted.

Elane Yap Theng Yu- R1989397

ScienTec Consulting Pte Ltd - 11C5781