There were two interviews
One was sql based ,the other one was more of a personal interview. It was of medium level ,not so difficult to crack,prepare beforehand ,the interview would be done smoothly
first they conducted the aptitude round followed by coding and technical round. questions were easy and overall difficulty level was moderate.
the whole process was of one month including result declaration.
Written exam(Aptitude (English Qnatitative Aptitude and Reasoning + Technical based on the ),Coding(SQL 15 questions) ,Technical Interview based on coding ,HR Interview (Some scenario based questions with some HR questions)