< Back to all jobs
Data Engineer (Teradata, Control-M, Informatica PowerCenter, UNIX Shell Scripting)
NEPTUNEZ SINGAPORE PTE. LTD.
Data & AISenior ExecutiveContractIslandwide, Singapore
Job Description
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.
Listing closes 19 Dec 2026.
Apply directly through the original listing. The employer’s page has the latest application details.