Onsite ETL Production Support Engineer - Data Warehousing

TechDigital Group; Holmdel Township (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

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.

Qualifications

• 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.

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.

Skills

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

Job description

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.