Virtusa

Consultant

  • New York, NY
  • full time
  • Posted 3 months ago
  • Staffing / consulting
Apply on Virtusa's site ↗Checked today on the employer's career site. We never take applications.
<html><body><p>JOB DESCRIPTION</p><p>Monitor, support, and maintain enterprise data pipelines and ETL workflows</p><p>Perform advanced SQL analysis for troubleshooting, reconciliation, and operational reporting</p><p>Investigate and resolve production data issues, failures, latency, and data discrepancies</p><p>Conduct root cause analysis across databases, ETL jobs, APIs, and downstream systems</p><p>Support daily operational health checks, incident management, and SLA adherence</p><p>Analyze large datasets to identify anomalies, trends, and data quality issues</p><p>Collaborate with business users, application teams, and platform engineering teams to resolve data-related incidents</p><p>Execute data validation, reconciliation, and integrity checks across multiple systems</p><p>Optimize SQL queries and data processing performance</p><p>Support batch and near real-time data movement processes</p><p>Build and maintain operational dashboards, alerts, and monitoring solutions</p><p>Assist with deployment validation, release support, and production readiness activities</p><p>Create operational runbooks, troubleshooting guides, and support documentation</p><p>Drive automation initiatives for monitoring, alerting, and issue remediation</p><p>Required Skills</p><p>Strong SQL expertise including</p><p>Complex joins and subqueries</p><p>Query tuning and optimization</p><p>Window functions</p><p>Stored procedures</p><p>Data analysis and reconciliation</p><p>Hands-on experience supporting ETL/ELT processes and workflows</p><p>Experience with ETL tools/platforms such as</p><p>Azure Data Factory</p><p>SSIS</p><p>Strong analytical and troubleshooting skills in production support environments</p><p>Experience investigating data quality, transformation, and integration issues</p><p>Knowledge of relational and cloud databases</p><p>SQL Server</p><p>Azure SQL</p><p>Familiarity with monitoring and observability tools</p><p>Understanding of data lifecycle management and operational support processes</p></body></html>

Similar open jobs

All H-1B consultant jobs in New York →