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.
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
I applied through an employee referral. The process took 1 week. I interviewed at Capgemini (Mumbai) in Sep 2022
Interview
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.
