Data Engineer (Oracle / Amazon RDS)

SCIENTEC CONSULTING PTE. LTD.; Singapore; Hybrid; SGD 60,000 - 80,000; Full time

Job summary

A leading consulting firm in Singapore is seeking a Data Architect to optimize data pipeline architecture. The role involves developing ETL processes and ensuring effective data management. Ideal candidates will have at least 3 years of experience in data architecture and familiarity with AWS cloud solutions. This role offers a hybrid working arrangement and a competitive salary package.

Benefits

Hybrid working arrangement

Supportive working environment

Competitive salary package up to $7,000

Qualifications

• Minimum 3 years of experience in data architecture and data warehousing.
• Experience in real-time streaming solutions.
• Familiarity with database development for OracleSQL/PLSQL.
• Experience in AWS cloud environment.

Responsibilities

• Design, develop, deploy and improve ETL tasks.
• Create data pipelines for modelling and mining.
• Ensure data architecture supports analytics requirements.
• Optimize PL/SQL and SQL in applications.

Skills

Data architecture

ETL/ELT processes

AWS services (EC2, S3, EMR, Redshift, Athena, Kinesis)

SQL/PLSQL optimization

Python

Data modelling

Data processing

Data crawling

Job description

You will be responsible to expand and optimize data pipeline architecture, as well as optimizing data flow and collect for cross-functional teams.

• Salary up to $7,000 + AWS + VB
• Hybrid working arrangement with supportive working environment
• Exposure to Oracle and Amazon RDS

Responsibilities:

1. Design, develop, deploy and continuously improve ETL tasks and be involved in data preparation for descriptive and prescriptive modelling.
2. Design and develop data pipelines for data modelling, mining and production.
3. Ensure data architecture is in place to support routine and ad-hoc requirements of data analytics team, stakeholders and the business.
4. Leverage on variety of programming languages and data crawling/processing tools to make raw data clean and highly available for use in descriptive and predictive modelling.
5. Ensure data assets and data catalogs are organized and stored in an efficient way.
6. Perform PL/SQL and SQL tuning and optimization of newly develop and existing applications.

Requirements:

• min. 3 years' working experience in data architecture, data warehousing, data processing, data modelling and ETL/ELT, familiarity with real-time streaming solutions.
• Working experience in database development for OracleSQL/PLSQL
• Working experience in AWS cloud environment, familiar with solutions such as EC2, S3, EMR, Redshift, Athena, Kinesis
• Skills in Python, R, SQL for data cleaning, processing and aggregation
• Hands-on experience in data crawling, data modelling, data lake formation and data warehouse construction

Be a driving force in cloud innovation and automation. Submit your updated resume today!
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).

This authorizes us to:
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.

Ng Kee Hung (Vickus) - R2091423
ScienTec Consulting Pte Ltd - 11C5781