SSIS Development & Data Integration

Design, develop, deploy, and maintain SSIS packages for ETL processes.

Create and optimize data integration workflows between multiple source and target systems.

Develop complex SQL queries, stored procedures, views, and database objects.

Troubleshoot and resolve ETL failures, data quality issues, and performance bottlenecks.

Implement automated data loading, validation, and reconciliation processes.

Data Validation & Data Quality

Perform source-to-target data validation and reconciliation.

Analyze data discrepancies and coordinate corrective actions.

Create validation frameworks and exception reporting processes.

Ensure data integrity, accuracy, and completeness across reporting environments.

Production Support

Provide L2/L3 support for SQL Server databases, ETL processes, and reporting systems.

Monitor daily ETL jobs and resolve production incidents within SLA timelines.

Perform root cause analysis (RCA) and implement preventive measures.

Support deployment activities and post-production validation.

New Project Development

Participate in new data warehouse, reporting, and integration projects.

Design scalable ETL solutions according to business and technical requirements.





Perform testing and collaborate with business teams during project execution.

Translate business requirements into technical specifications and development tasks.

SQL Server DBA Responsibilities

Monitor SQL Server performance, availability, and capacity.

Manage SQL Agent jobs, database backups, recovery, and maintenance plans.

Perform database security management, user access provisioning, and permissions administration.

Identify and resolve blocking, deadlocks, and performance issues.

Implement indexing, query tuning, and database optimization strategies.

Azure & Power BI Support

Assist with Azure-based data integration and cloud migration initiatives.

Support Azure SQL Database, Azure Data Factory, and related Azure services.

Develop and maintain Power BI reports and dashboards.

Collaborate with reporting teams to ensure data accuracy and reporting efficiency.

Required Skills

Technical Skills

Solid experience in Microsoft SQL Server (2016/2019/2022).

Expertise in SSIS (SQL Server Integration Services).

Advanced SQL programming, query optimization, and performance tuning.

📌 Lead Software Engineer (Toronto)
🏢 Virtusa
📍 Toronto