Job Title: Onsite Support Engineer L2 – Data & ETL Platform
Location: Holmdel, NJ
Work Arrangement: Remote allowed for 12 PM – 9 PM EST shift; Onsite for normal shift
long term Contract
Job Overview
We are seeking an experienced L2 Support Engineer – Data & ETL Platform with strong expertise in ETL tools, data warehousing, and production application support.
The ideal candidate will have hands-on experience supporting critical data integration platforms, troubleshooting ETL processes, monitoring data pipelines, and resolving production incidents. The candidate will work closely with business users, offshore teams, and technology stakeholders to ensure smooth data operations, maintain data quality, and meet SLA commitments.
Onsite Support Engineer L2 (Data & ETL Platform)
Role Summary
We are seeking an experienced Onsite Support Engineer with strong expertise in ETL tools, data warehousing, and production support. The candidate will be responsible for supporting critical data integration platforms, troubleshooting data issues, monitoring data pipelines, coordinating with business and technology teams, and ensuring 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.
• 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
• Informatica PowerCenter/IDMC
• ETL Development or Support Data Engineering & Analytics (Any ETL tool, preferably Informatica)
• 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
• Financial Data Processing
• Neoxam DataHub (Preferred)
