SalaryPeak

Data Engineer with ETL

OX CONSULTANCY PTE. LTD.
Singapore 5+ years Posted Yesterday

Salary Range

SGD 84,000 - SGD 108,000 /year

SGD 7,000 - SGD 9,000/month

Skills Required

SAP Implementationdata uploadsApplication Performance ManagementTeradata SQLApache SparkOracleInformaticaETLComputer ProficiencyImpalaPythonHive

Job Description

  • Strong hands‑on experience with the ETL(Informatica Power Center) and Teradata based ETL development, similarly Hadoop ecosystem (Hive, Impala, Spark, Kafka, Iceberg, Ranger, Atlas, Nifi, Flink etc.,), and data pipeline orchestration.
  • Proficiency in Java, Python, shell scripting, RESTful API development, and web frameworks such as Flask and React.
  • Create EDW ETL/ELT codes using Teradata SQL, Informatica, Apache Spark, QueryGrid to perform various transformations and load into Teradata based data warehouse or datamarts
  • Performance tuning of highly complex applications to reduce resource usage
  • Create framework using GCFR, shell scripts, BTEQ and shell scripts to automate end to end. Also to integrate with control
  • Build in-house CDC framework using Java to process OLR logs from SAP(Oracle) and ingestion the data into Teradata. Create framework around this CDC ingestion to make it configurable
  • Install and build Master Data Management (MDM) application for various user uploads along with data validations and approval workflow.