First round phone interview with the HR, then technical round with Python and SQL tests, finally it's the case study round with the manager, coupled with a few behavior questions