Posted 6h ago

Project Manager

@ Virtusa
Toronto, Ontario, Canada
OnsiteFull Time
Responsibilities:managing projects, designing databases, developing ETL
Requirements Summary:Strong SQL/T-SQL, SSIS, SSRS, Power BI; ETL, data testing, performance tuning, and database administration; experience configuring SQL Server Agent jobs.
Technical Tools Mentioned:SQL, SSIS, SSRS, Power BI, SQL Server Agent
Save
Mark Applied
Hide Job
Report & Hide
Job Description

Primary Skills
SQL, T-SQL

Secondary Skills
SSIS

JD

Database Development : Proficient in advanced SQL and T-SQL, with a strong understanding of database design and implementation.

ETL Development : Familiar with SSIS packages, focusing on data flow management and error handling techniques to ensure reliable data integration.

Testing : Hands on experience in setting up data on QA/UAT environments and perform unit testing.

Reporting Services : Knowledgeable in reporting tools such as SQL Server Reporting Services (SSRS) and Power BI, capable of creating insightful business reports.

Performance Tuning : Skilled in optimizing database performance through effective indexing, query optimization, and performance monitoring to enhance data retrieval efficiency.

Documentation : Committed to maintaining detailed documentation of database structures, ETL processes, and reporting solutions for future reference and compliance purposes.

Database Administration : Experienced in database management tasks, including backups, partitioning, and role configuration to ensure data integrity and security.

Job Management : Experienced in configuring jobs on SQL Server Agent and reporting tools, as well as monitoring their performance to ensure successful execution.