- Strong knowledge of MS SQL Server
- Hands-on experience with SSIS (SQL Server Integration Services)
- Experience in SSRS (SQL Server Reporting Services)
- Good understanding of ETL processes and Data Warehousing concepts
- Proficiency in writing SQL Queries, Stored Procedures, Views, and Functions
- Knowledge of Data Migration, Data Cleansing, and Data Validation
- Exposure to Power BI is an added advantage
Additional Responsibilities
- Knowledge of SSAS or Power BI
- Exposure to Azure Data Factory (ADF) will be an added advantage
Technical and Skilled Requirements
- Develop, deploy, and maintain SSIS packages for data integration and ETL processes
- Create and manage SSRS reports including tabular, matrix, drill-down, drill-through, and parameterized reports
- Design datasets, report schedules, and subscriptions
- Write optimized SQL queries, stored procedures, and functions
- Work with business stakeholders to gather reporting requirements
- Ensure data accuracy, performance, and timely report delivery