Minimum 5-7 Years of Rich Experience in developing solutions on SQL Server using TSQL, SSIS.
Should have Good Knowledge and implementation on database modelling techniques.
Should have hands on experience on ETL technologies like SSIS
Should have Good work experience on Creation of Sub Queries, Joins, Stored Procedures, Views, Functions, Cursors and Triggers etc.
Good to have Cube development techniques using SSAS. (Optional)
Should have Good work experience on working on recursive Datasets.
Should have good knowledge on Database optimization, Query optimization & Resolving performance issues of the queries.
Should be Good in Analytical thinking and should be able work independently on the assigned task
Should have Good Knowledge on database Deployment process
Should have worked on agile project implementations
Good to have - Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Good to have - Building Reporting solutions with architecture understanding.