Onsite Support Engineer – Data & ETL Platform (Investments)

JOB DETAIL Job Title

Onsite Support Engineer – Data & ETL Platform (Investments)

Job Location

Holmdel, NJ (Onsite)

Job Duration

6+ Months Contract

Employment Type

W-2 Only

Job Summary

We are seeking a skilled Onsite Support Engineer to support data integration and data warehouse applications within the investments domain. The role involves monitoring ETL processes, troubleshooting data pipeline failures, performing SQL-based analysis, validating data loads, and coordinating with business users, offshore teams, and technology vendors to resolve production issues.

The ideal candidate will have hands-on experience with Informatica, Databricks, Control-M, Unix/Linux, and enterprise production support processes, with a strong focus on data quality, SLA compliance, and operational efficiency.

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 to resolve issues promptly.
• Validate data loads and perform reconciliation between source and target systems.
• Monitor job scheduling and workflow execution using Control-M.
• Perform SQL-based data analysis, validation, and troubleshooting.
• Develop and maintain Unix shell scripts to automate support activities.
• Ensure compliance with SLA commitments and incident management processes.
• Support release deployments, validation, and post-deployment activities.
• Prepare operational documentation, support runbooks, and incident reports.
• Drive continuous improvement initiatives to improve data quality and operational efficiency.

Required Skills and Qualifications

ETL and Data Integration

• Experience with Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC).
• Strong understanding of ETL development and production support.
• Familiarity with Neoxam DataHub is preferred.

Data Engineering and Analytics

• Experience with Databricks.
• Strong understanding of data warehousing concepts.
• Experience with data analysis, validation, and reconciliation.
• Intermediate to advanced SQL skills.

Scheduling and Monitoring

• Hands-on experience with Control-M job scheduling.
• Experience with batch monitoring and workflow management.

Operating Systems and Scripting

• Unix/Linux administration knowledge.
• Strong Unix shell scripting skills.

Production Support

• Experience with incident and problem management.
• Strong root cause analysis and troubleshooting skills.
• Knowledge of change and release management.
• Experience with application monitoring and production operations.

Preferred Qualifications

• Experience in investment management or asset management.
• Exposure to insurance or capital markets.
• Experience handling financial data processing and reconciliation.
• Familiarity with investment data platforms and related business processes.

Key Competencies

• ETL and Data Integration Support
• Informatica PowerCenter/IDMC
• Databricks and Data Warehousing
• SQL Analysis and Data Reconciliation
• Control-M Scheduling and Batch Monitoring
• Unix/Linux and Shell Scripting
• Production Incident Management
• Root Cause Analysis and Troubleshooting
• Release Management and SLA Compliance
• Investment and Financial Data Processing

Best Regards,

Akriti

IT Recruiter

Contact Details

( 732)-412-3421

Email

akriti.soni@applabsystems.com

4365 Route 1 South,

Suite 105

Princeton, NJ 08540

www.applabsystems.com