NS

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

  • Neptunez Singapore Pte. Ltd.
  • Singapore
  • On-site
  • Contract
  • SGD 8k–10k / month
  • Posted yesterday
Data & AIData Quality ChecksInformatica PowercenterDependency ManagementTeradata

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.
Apply on MyCareersFuture

You apply on MyCareersFuture, where this job was posted. Peter Nowak isn’t the employer and doesn’t check listings.

Get new jobs like this by email

Data & AI · Singapore

Free. Confirm by email first; unsubscribe anytime in one click.

Similar jobs

Data Engineer (Teradata, Control-M, Informatica PowerCenter, UNIX Shell Scripting) at Neptunez Singapore Pte. | Peter Nowak