In a first round they asked Basics of sql, dwh, informatica etc second round they asked sql, dwh, information relates to informatica, joins, subquery, case, cast, dwh, stage, datamart, unix, power bi, python basics

First applied through online job portal then applied through referral and in a week,interview got scheduled. Had 2 technical rounds Further there was Managerial round/or HR round Interviewer were knowledgeable. Only concern was punctuality, interviewer were not punctual in my case.

It was direct Online interview, they didn't even ask my expected CTC/ Notice period before interview. Which I was worried as my official NP was 90 days, was not sure of they agree for it. But they were ok with it.