three rounds of interview the first round consisted of questions on coding the second round included managerial questions the third round was a friendly hr where the questions were about the personal life and goals I would like to achieve in the nearest future

Easy, asked general questions based on resume. Need to know what you have written about yourself in your resume, might ask questions about that. Basic SQL and basic understanding of Supply Chain.