HR reached out and asked housekeeping ques regarding relocation and visa sponsorship. Then had a phone interview with the hiring manager on overall resume. Then flew for the onsite interview- had 1-1's with couple of other team leads for stakeholder expectations. Had one SQL round for queries. I remember I was asked a self join query