- 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 new projects/enhancements in Data warehouse (SQL server Datawarehouse).
- Implementation/enhancement of new 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.