ETL Production Support Engineer

TechDigital Group; Holmdel Township (NJ); Vor Ort; USD 90.000 - 130.000; Vollzeit

Zusammenfassung

TechDigital Group seeks an Onsite Support Engineer with strong ETL, data warehousing, and production support expertise in New Jersey. The role focuses on providing onsite data integration support, monitoring ETL processes, and ensuring data quality across pipelines.

You will coordinate with business users, offshore teams, and vendors, validate data loads, and manage batch processing and job scheduling with Control-M.

Qualifikationen

• Experience with data integration, data warehousing, and production support.
• Strong SQL skills and data reconciliation experience.
• Unix/Linux administration and shell scripting abilities.
• Exposure to Control-M and batch scheduling.
• Familiarity with data quality and RCA processes.
• Hands-on experience with ETL tools such as Neoxam DataHub, Informatica.

Aufgaben

• Provide onsite support for data integration and data warehouse applications.
• Monitor, troubleshoot, and resolve production issues related to ETL processes and data pipelines.
• Analyze data quality issues and perform root cause analysis.
• Support daily, weekly, and monthly batch processing activities.
• Coordinate with business users, offshore teams, and vendors for issue resolution.
• Validate data loads and reconciliation between source and target systems.
• Monitor job scheduling and workflow execution using Control-M.
• Perform SQL-based data analysis and troubleshooting.
• Develop and maintain Unix shell scripts to automate support activities.
• Ensure adherence to SLA commitments and incident management processes.
• Participate in release deployments, validation, and post-deployment support.
• Prepare operational documentation, runbooks, and support reports.
• Drive continuous improvement initiatives to enhance operational efficiency and data quality.

Kenntnisse

ETL Tools

Data Warehousing

Production Support

SQL

Shell Scripting

Unix/Linux

Control-M

Root Cause Analysis

Incident Mgmt

Tools

Neoxam DataHub

Informatica PowerCenter

IDMC

Databricks

Jobbeschreibung

We are seeking an experienced Onsite Support Engineer with strong expertise in ETL tools, data warehousing, and production support.

Key Responsibilities

• Provide onsite support for data integration and data warehouse applications.


• Monitor, troubleshoot, and resolve production issues related to ETL processes and data pipelines.


• Analyze data quality issues and perform root cause analysis.


• Support daily, weekly, and monthly batch processing activities.


• Coordinate with business users, offshore teams, and vendors for issue resolution.


• Validate data loads and reconciliation between source and target systems.


• Monitor job scheduling and workflow execution using Control-M.


• Perform SQL-based data analysis and troubleshooting.


• Develop and maintain Unix Shell scripts to automate support activities.


• Ensure adherence to SLA commitments and incident management processes.


• Participate in release deployments, validation, and post-deployment support.


• Prepare operational documentation, runbooks, and support reports.


• Drive continuous improvement initiatives to enhance operational efficiency and data quality.

Required Technical Skills: ETL & Data Integration

• Neoxam DataHub (Preferred)


• Informatica PowerCenter/IDMC


• ETL Development or Support

Data Engineering & Analytics

• Databricks


• Data Warehousing Concepts


• Data Analysis and Reconciliation


• SQL (Intermediate to Advanced)

Scheduling & Monitoring

• Control-M Job Scheduling


• Batch Monitoring and Workflow Management

Operating Systems & Scripting

• Unix/Linux Administration


• Shell Scripting

Production Support

• Incident Management


• Problem Management


• Root Cause Analysis (RCA)


• Change & Release Management


• Application Monitoring

Preferred:

• Investment Management / Asset Management


• Insurance / Capital Markets


• Financial Data Processing