Search by job, company or skills

AmpsTek

Data Engineer

Fresher
Save
new job description bg glownew job description bg glow
  • Posted 19 hours ago
  • Be among the first 10 applicants
Early Applicant

Job Description

Job Title: Data Engineer

• 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

- 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 OR 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

- 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.

- Create EDW ETL/ELT codes using Teradata SQL, Informatica, apache Spark, QueryGrid, Trino to perform various transformation and load into Teradata based data warehouse or datamarts

- Performance tuning of highly complex applications to reduce resource

- 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 OR 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 Usage

Must Have:

  • ETL/ELT Development using Informatica
  • Power Center and Teradata
  • Data Platform Expertise
  • Data Pipeline & Orchestration using enterprise scheduling tools
  • Performance Optimization
  • Data Integration & CDC
  • MDM - Reference data management
  • ETL Framework & Automation Development

More Info

Job Type:
Industry:
Employment Type:

About Company

Job ID: 148638325

Similar Jobs

Singapore

Skills:

Informatica Power CenterBteqJavaRangerHadoop EcosystemApache SparkKafkaImpalaELTHiveEtlGCFR shell scriptsATLASFlinkTeradataIcebergQueryGridTrinoNifi

Singapore

Skills:

JavaDistributed ComputingHadoopLinuxScalaSparkBig Data TechnologiesPythonGoClickhouseFlink

Singapore, Robinson

Skills:

snowflake S3AWS GlueTableauPythonAWSJavaBigQueryApisData SecurityPower BiScalaRedshiftSqlGcpApache KafkaData GovernanceETL processesdata pipeline toolsGoogle Looker Studiodata warehouse designdata lake architecturedata integration methodsGoogle Cloud Dataflow

Singapore

Skills:

JavaBteqRangerHadoopApache SparkKafkaTeradata SqlInformaticaImpalaHiveATLASFlinkGCFR shell scriptingIcebergQueryGridTrinoNiFi

Singapore

Skills:

BteqJavaRangerApache SparkKafkaTeradata SqlImpalaELTHiveshell scriptingPrestoInformatica PowercenterEtlATLASGCFRFlinkTeradataIcebergdatabase automation frameworksTrinodata security access control frameworksMaster Data Management