MS BI SSIS-SSAS Consultant

Description

Job Description Minimum 5+ Yrs of experience in SQL Server 2005/2018 Good experience in TSQL/Stored Procedure creation, modifying and debugging using SQL Server 2005/2018 Very strong experience in tuning queries and stored procedures Experience using SQL Profiler and Windows Performance Manager for troubleshooting Very good working knowledge of MS SQL Server Query Engine, Execution Plan, Indexing and other performance tuning techniques Have experience with SSIS packages. Must have Experience developing various reports using SSRS. Proven ability to work in global environments and to collaborate affectivity with counterparts in remote offices. Resourceful, creative, responsible, flexible, able to work unsupervised and dedicated to quality of work. Required Specifications Should have good experience in SQL Server database development Proficient in MS SQL Server and latest versions Expertise in TSQL, stored procedures, user defined functions, triggers, joins, subqueries etc., Should have good technical and communication skill. Experience/Knowledge in SSIS, SSRS & SSAS would be an added advantage SQL+SSIS(SQL Server Integration Services) Developer Desired Specifications Should have good experience in deploying packages. Should have strong experience in configuring SSIS Packages and scheduling jobs. Proficient in MS SQL Server and latest versions Expertise in TSQL, stored procedures, user defined functions, triggers, joins, subqueries etc., SQL+SSRS(SQL Server Reporting Services) Developer Desired Specifications Should have good experience in SSRS Development, creating and fine tuning SQL reports Expertize in developing complex SQL queries; developing detailed SQL reporting specifications; aggregating, analyzing, validating, and/or reconciling data Proficient in designing basic reports, Sub Reports, Matrix, Drill down, and Drill through etc. Expertise in SQL Server 2018 & SSRS 2018 version Should have good technical and communication skill. Should have knowledge of SQL server (View, Store procedure, Functions, Cursors, Complex procedures).