It was a campus hiring. First step was the aptitude test. It was easy and pretty similar to what we get in CAT. Second phase was a quick interview on SCM concepts, DB related stuff, and anything under the sun. Third phase again was a 3 on 1 interview. This was the main make-or-break interview. They will try to grill you, but its ok. Final round was HR round, which was mostly timepass.

Online assessment, technical interview, hr interview . The whole process takes around 2 days. The package is 48000 for internship of 4 months. after that CTC is 950000. Sql questions are asked mostly as technical and aptitude also. Both are easy to intermediary level. But practice on easy questions with a little condition or twist is helpful for answering in less time.