I applied through a staffing agency. I interviewed at Cognizant
Interview
Had a virtual technical interview. No official email received on clearing the technical round.
HR called directly after 2-3 weeks of technical interview and offer was rolled out in next 15 days
Entire process took nearly 1 month.
Interview questions [1]
Question 1
Remove duplicates in SQL, SCD type 2 flow, Dynamic lookup, Department wise highest salary query in SQL, How to consider list of files in Informatica PC
I joined CTS as a fresher, so interview was bit easy. They asked me about my college project and some basic C programming questions and most of my interview is one college project
Was very tough. They mostly asked about informatica BDM and hive and some of the questions on scenario based on informatica and sql. They were more looking for the experience in Hadoop and hive and informatica