I applied through a staffing agency. The process took 1 week. I interviewed at Cognizant (Calcutta) in Jul 2022
Interview
There were two rounds one technical and one managerial. SQL and Spark optimization related questions we asked. SQL questions are from joins while Spark is related to optimization. It was completely online. In the managerial round project related questions were asked, then how to overcome failure, how to handle stakeholders etc.
Quick phone call with recruiter and then technical interview with some behavioral questions. There were coding challenges, Sql question and optional question on cloud. Code challenge - palindrone, recursion. Sql question - joins, normalizing data.
Technical test and behavioral video assessment and then manager one hour interview with manager. The process was pretty, but did not get a job offer with them. Will try again! Seems like a good company to work with