I applied through a recruiter. The process took 2 months. I interviewed at Cognizant (Chennai) in Mar 2016
Interview
The Written round consists of two major sections namely General Aptitude Test and Verbal Ability Test. General Aptitude Test, has mathematical reasoning part and logical reasoning part and verbal ability Test. Technical Round and HR Round : The students who clear the written round are called for Technical Interview.
Interview questions [1]
Question 1
Informatica scenario based questions and data warehousing concept
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