Principal Consultant

INNOPEAK ADVISORS PTE. LTD.

Islandwide
Sgd 8,000 - 11,000 / monthly pm
On-site
Data uploads
Application performance management
Data ingestion
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 would be added advantage. Create EDW ETL/ELT codes using Teradata SQL, Informatica, Apache Spark, QueryGrid, Trino 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. 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

Job Summary

  • 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 would be added advantage
  • Build in-house CDC framework using Java to process OLR logs from SAP(Oracle) and ingestion the data into Teradata

Matching Summary

Match Score: 85

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 would be added advantage. Create EDW ETL/ELT codes using Teradata SQL, Informatica, Apache Spark, QueryGrid, Trino 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. 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.

Salary

SGD 8,000 - 11,000 / Monthly

Skills & Requirements

Must-have

  • Data Uploads
  • Application Performance Management
  • Data Ingestion
  • Apache Spark
  • ETL Tools

Nice-to-have

  • Shell Scripting
  • Impala
  • Data Marts
  • Hive
  • Master Data Management
  • Teradata Data Warehouse

Key Requirements

  • Minimum 6 years experience

Work Rights

Tailored Resume

Cover Letter