Key Skills :
Strong database fundamentals
Knowledge of SSAS is good to have
Exposure to cube design/building and development of Data Warehousing and BI solutions using SQL Server preferably (2010 & 2012), MSBI
should have good exposure to databases like SQL Server 2008 and above
should have good communication (verbal and written) and presentation skills.
technically strong in SSIS, SSRS
Good to have exposure on SSAS and MDX.
Good knowledge off Database Design, Data warehousing / ETL concepts, data modeling
. Should have good knowledge on database and SQL Standards. Should be able write complex SQL queries for SQL Server
Strong Hands on experience in Stored Procedure / Function / SSIS packages.
Expertise in designing solutions, conduct reviews with the team to conform to design specifications and Coding standards.
Expertise in creating and maintaining various SDLC documentation viz. HL and LL Design documents.