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.
