There was an online technical interview and a complete virtual onsite interview 1) The round was about SQL and python was given a link to write SQL 2) Exclusive questions on python, ETL and AWS (less AWS) ex: find number largest in a list, remove duplicates, etc. 3) Data modeling and Datawarehouse concepts was a given question and told to model it. 4) Project manager round: to discuss team, goals, and project. All had a coding hire link and interview went well, The recruiter response time is very very bad, they don't give you a proper reply and don't respond to calls I was very frustrated by the recruiter and never wanted to be contacted either from a recruiter or from this company. Thanks