ETL Engineer

Title:ETL Support Engineer
Location: Holmdel, NJ
Work Arrangement: Onsite preferred; remote work may be considered for exceptional candidates.

Employment Type: Contract

Role Summary

We are seeking an experienced Onsite Support Engineer with strong expertise in ETL tools, data warehousing, and production support. The candidate will support critical data integration platforms, troubleshoot data issues, monitor data pipelines, coordinate with business and technology teams, and ensure timely resolution of production incidents.

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 (RCA).

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

• Coordinate with business users, offshore teams, and vendors to resolve issues.

• Validate data loads and reconcile data 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 compliance with 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

• Informatica PowerCenter / IDMC

• ETL development and production support

• Neoxam DataHub – preferred

Data Engineering & Analytics

• Databricks

• Data warehousing concepts

• Data analysis and reconciliation

• Intermediate to advanced SQL

Scheduling & Monitoring

• Control-M job scheduling

• Batch monitoring and workflow management

Operating Systems & Scripting

• Unix/Linux

• Shell scripting

Production Support

• Incident and problem management

• Root cause analysis (RCA)

• Change and release management

• Application monitoring

Preferred Industry Experience

• Investment management or asset management

• Insurance or capital markets

• Financial data processing