jobs in NEPTUNEZ SINGAPORE PTE. LTD.

全职 Data Engineer (Teradata, Control-M, Informatica PowerCenter, UNIX Shell Scripting) 工作, 薪水 up to SGD 8,000, NEPTUNEZ SINGAPORE PTE. LTD. Islandwide (Singapore) 公司招聘中 - Ricebowl

Data Engineer (Teradata, Control-M, Informatica PowerCenter, UNIX Shell Scripting)

NEPTUNEZ SINGAPORE PTE. LTD.

Islandwide (Singapore)

分享
保存

工作地点

  • Islandwide (Singapore) Singapore

职位描述

岗位职责

Responsibilities

  • Handle production operations for enterprise data warehouse applications, covering scheduled data processing, ETL execution and downstream data availability across daily and monthly processing cycles.
  • Investigate database and data-processing failures using SQL and PL/SQL queries, particularly across Teradata and Oracle environments, to identify incorrect data loads, query-related issues and processing discrepancies.
  • Manage Control-M batch execution activities, including monitoring scheduled workloads, analysing unsuccessful job runs, identifying dependency failures and performing job restart and recovery operations.
  • Examine Informatica PowerCenter workflows, mappings and session execution details to isolate ETL failures, investigate unsuccessful data loads and identify the stage at which processing issues occur.
  • Trace data movement from incoming source files through ETL transformations into Enterprise Data Warehouse tables to identify data loss, incomplete loads and inconsistencies between source and target records.
  • Perform database-level validation and reconciliation to investigate missing, duplicate and mismatched records, ensuring the accuracy and completeness of processed data.
  • Work within UNIX/Linux environments to examine application and batch logs, verify file availability and investigate errors affecting scheduled data-processing activities.
  • Support data integration processes involving structured file formats such as CSV, TXT, JSON and XML, including investigation of file-related and data-loading failures.
  • Conduct root cause investigations for recurring ETL, database and batch-processing incidents, documenting findings and coordinating permanent corrective actions with relevant technical teams.
  • Participate in production implementation and release activities, performing post-deployment checks to verify application functionality, workflow execution and data-processing results.

Requirements

  • Minimum 6 years of experience in ETL, Data Warehousing and Enterprise Data Application Support.
  • 6+ years of experience in Production Support environment.
  • Strong hands-on experience in Teradata, SQL and PL/SQL, with practical knowledge of database troubleshooting, query execution, data analysis and production data validation.
  • Experience handling Control-M batch scheduling operations, including job monitoring, dependency analysis, failed-job investigation, restart and recovery.
  • Experience with Informatica PowerCenter, particularly ETL workflow monitoring, mapping analysis, session execution and error-log investigation.
  • Strong working experience in UNIX/Linux, including command-line operations, UNIX Shell Scripting, file verification and log analysis for production troubleshooting.
  • Experience supporting Enterprise Data Warehouse (EDW) environments involving data extraction, transformation, loading and reconciliation.
  • Ability to investigate end-to-end data discrepancies through source-to-target validation, record-level checks and database queries.
  • Experience supporting production applications through L2/L3 incident resolution, root cause analysis and SLA-driven operational processes.
  • Experience with Oracle databases and SQL development tools such as TOAD or SQL Developer.
  • Experience with ServiceNow or Jira for incident tracking and production support documentation.
  • Experience in healthcare domain will be strongly preferred.

重要安全守则

申请工作时,切勿提供您的银行或信用卡详细资料。不要转账或完成无关的在线调查问卷。如果您发现可疑内容,请举报此招聘广告。

了解更多