:
Minimum 7 years of experience
Good knowledge and understanding of Data warehouse
Valuable knowledge of SQL Server
Stored procedures,
functions
Triggers
Views
SQL jobs
Optimization/ performance tuning of procs/functions/views.
Excellent Command on SSIS and SSRS
Azure SQL concepts
Knowledge of Azure DevOps and GIT
Knowledge of Azure Data factory (ADF ) concepts and hands-on experience of working on ADF on one or more projects
Must Have & Desired Skills: Must have skills:
Development of current projects/enhancements in Data warehouse (SQL server Datawarehouse).
Implementation/enhancement of current Procs, functions, views, Triggers and jobs.
Creation,
scheduling and maintenance of nightly jobs using SQL Server Agent
Monitoring the nightly loads.
Development /enhancing of SSIS packages.
Excellent command on SSIS - Deep knowledge of SSIS package - Visual Studio 2017
Development /enhancing of SSRS reports.
Optimizing/ performance tuning the SQL objects
Excellent client communication skills
Ability to coordinate independently with Onsite client counterparts
Takes end-to-end ownership of deliverables
Follows all required processes and status updates including Azure DevOps status and timekeeping.
Desired Skills:
Azure Data Lake
Azure Data Bricks
Synapse
Microsoft Fabric.