I applied online. The process took 6 weeks. I interviewed at Cognizant (Hyderābād) in Sep 2016
Interview
Basic Questions on the previous project overview and basic questionjs related to transformations and their properties. I was having 2 years of experience when i was interviewed so not much to expect and hence questions were easier.
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
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