F2F interview. 1sr round concentrating on sql and pyspark. 2nd round project specific round concentrating on scenario's, technical and mangerial questions. 2nd round can be interviewed for multiple projects.
Being f2f and near to walk in, about 300 candidates appeared for interview and only one person got selected.
Interview questions [1]
Question 1
Sql queries and same should be written in pyspark
Scenario based adf, adb and pyspark
I applied through other source. I interviewed at Cognizant (Sydney)
Interview
Quite technical in terms of interview. Interviewer is also tech savvy which is good filtering candidates as they go. Also a good opportunity to prep and brush up skills that aligns with the job description.
It was an easy interview. First round was around case solving and behavioral question. Second round was with Reporting Manager, it revolved around fitment and willingness to join the role