I applied through a recruiter. I interviewed at CRISIL (Mumbai) in Jun 2015
Interview
Technical question asking and give the answer one by one. try to explain each and every thing.
more focus on Partition base , performance tuning. and complex query and focus on collection like Varray, index by table, bulk collect etc.