Senior ETL Data SQL SSIS

Virtusa

Job Location:

Chennai - India

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

Design build and maintain scalable data pipelines using SSIS and SQL Server for enterprise data processing.
Develop and optimize Databricks (PySpark / Spark SQL) pipelines for large-scale data transformation and analytics.
Work on batch and near-real-time data ingestion transformation and loading (ETL/ELT) across multiple source systems.
Strong hands-on experience with SQL stored procedures and performance tuning in SQL Server environments.
Integrate legacy ETL (SSIS) processes with modern cloud-based data platforms (Databricks / Lakehouse architecture).
Experience working with P&C Insurance data domains such as Policy Claims Billing Underwriting and Loss data.
Understand insurance lifecycle processes and data flows across core insurance systems.
Support data migration and modernization initiatives from on-premise to cloud platforms (Azure/AWS preferred).
Ensure data quality validation reconciliation and governance across all pipelines.
Monitor and troubleshoot ETL jobs ensuring high availability reliability and performance.
Collaborate with business analysts actuaries and downstream BI/reporting teams to deliver data solutions.
Work closely with data architects and engineers to define scalable data models and standards.
Implement logging error handling and auditing frameworks for data pipelines.
Participate in Agile ceremonies code reviews and production deployment activities.
Ensure compliance with insurance regulatory audit and data security requirements.

Required Experience:

Senior IC