I applied in-person. I interviewed at Cognizant (Chennai) in Sept 2018
Interview
TCS tests your ability to write efficient SQL code for the BI developer role. Having an experience working with visualization tools such as Power BI, Tableau and knowledge in building Schemas is a big plus.
Interview questions [1]
Question 1
What is the difference between star and snowflake schemas? Which one would you choose if you have to build a schema?
What id the difference between group by and partition by in SQL?
Can you describe any query optimization techniques you have used?
I applied online. I interviewed at Cognizant (Newark, NJ)
Interview
Experienced in managing end-to-end interview processes, including candidate screening, technical evaluations, panel interviews, coordination of feedback, communication with stakeholders, and final selection to deliver a smooth, structured, efficient hiring experience.
Interview questions [1]
Question 1
They asked me to walk them through my experience and explain how my skills align with the role.”
The interview was average, Minal wanted to see how do we deal with certain scenarios and was asked what is the current project and day to day work and few other basic questions