There were 3 technical rounds and one telephonic interview. All the interviews were on Skype from Hyderabad office. The questions were tricky. 1. Basic MSBI concepts - indexes, SQL profiler, jobs, replication 2. Advanced SQL concepts - SSIS DFT, SQL tasks, Master package, Project/package deployment, SSIS checkpoint, Merge join, lookup, fuzzy lookup, cube concepts, Multi-dimensional modeling, star and snow-flake schema; role playing dimension, junk dimension, hierarchy 3. HTML5, CSS3, Javascript, Angular JS concepts

It was a fairly straightforward process that included a data structures and algorithms (DSA) based live coding round followed by an HR interview. Both rounds were of medium to difficult level, but I was able to successfully clear them.