Solicité el puesto a través de una agencia de empleo. Acudí a una entrevista en Cognizant
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 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