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