6 years relevant experience in working with MS SQL Server – 2008/2008R2/2012 is mandatory. Very Strong experience in RDBMS concepts, DB design, modeling of OLTP/DW systems. Hands-on experience in MS SQL Server Programming. Should be able to understand/design the datamodel. Should have experience in datamodel tools e.g ERWIN. Understand the star schema and snowflake schema. Creating tables, views, stored procedures and functions. Creating indeces ...