It was a 2 round interview with the first round being Programming question and a set of SQL queries. In the second round, it was system design and a background of your skills and its relevance to the job to be done in the company. Both the rounds were pretty nice, with casual talk as well as testing your skills