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
Data Engineering & Analytics
Scheduling & Monitoring
Operating Systems & Scripting
Production Support
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
Rate:
Not specified
Location:
Holmdel
IR35 Status:
Outside
Remote Status:
Hybrid
Industry:
Data & Analytics
Seniority Level:
Not Specified