Understood business requirements and mapping documents provided by the modelling team.
● Developed SSIS packages to extract, transform, and load data from SQL Server into EDW.
● Deployed SSIS packages and scheduled them via SQL Server Agent; monitored daily jobs and
resolved failures.
● Performed ADF pipeline monitoring, health checks, and resolved incidents to meet SLA timelines.
● Conducted pre-batch and post-batch validation on Azure SQL and on-premises EDW databases.
● Transferred data across Azure SQL DB and on-prem servers and coordinated with downstream ● Managed 50+ SQL servers and 500+ databases including space management and backup
strategies.
● Implemented MSSQL security – logins, user permissions, roles.
● Configured and troubleshot replication, log-shipping, mirroring, and SQL clusters.
● Built Power BI reports using Azure SQL Data Warehouse datasets.
● Prepared and maintained daily/weekly/monthly checklists and activity trackers.
- Data Analyst