Datawarehouse Developer

Must have at least 5 plus years prior hands-on experience developing SQL Server 2019 based applications using industry standards, specifically SQL Server Integration Services (SSIS) and one plus year with SQL Server Reporting Services (SSRS).


Primary responsibilities include writing packages, stored procedures, triggers, ad-hoc queries, process documentation. Troubleshoot and optimize the performance of packages and stored procedures. Must be detail oriented to succeed in this role.
Required Skills:

• Must have extensive experience with SQL Server Integration Services.
• Excellent knowledge of databases, data warehouse/modeling concepts and understanding of business intelligence.
• Strong knowledge of creating SSIS packages using transformation.
• Good knowledge of creating reports using SSRS.
• Must be proficient in scripting (VB.net, .NET, C#, VB Scripts).
• Must have extensive experience with Stored Procedures, Triggers, Views, and Functions.
• Experience building complex reports using Query/Report.
• Query performance analysis and tuning.
• Excellent problem solving and critical thinking skills.
• Excellent analytical skills, documentation, and ability to work in teams and/or independently.
• Fast learner and excellent documentation habits.

Technical Skills:
SQL Server 2012/2014/2019, SSIS, SSRS, Scripts (VB.net, .Net, C#, VB Scripts) Stored Procedures, Triggers, Views, Functions, Performance Tuning.

....