The interview consisted of four sections: HR, technical, manager, and HR.
During the interview, the topics covered in the questions were those listed on my resume.
In our last interview, the manager and I discussed the projects I will be working on as well as the work environment.
Preguntas de entrevista [1]
Pregunta 1
Which BI tools have you used, and what are their good and bad sides?
Define OLTP and OLAP. What is the difference? What are their purposes?
Name some benefits of data denormalization.
Solicité el puesto a través de un captador. Acudí a una entrevista en CGI (Bengaluru) en feb 2022
Entrevista
There were a total of 3 rounds: technical, techno-managerial, and HR discussions. The interview process was very smooth, and it took 2 weeks. The technical round was more about practical questions, and the second round was scenario-based questions on Python, SQL, PBI, and real-time scenarios.
Preguntas de entrevista [1]
Pregunta 1
Technical Round: Power BI theoretical and practical questions like PBI components, power query, power pivot, how to create calculate column and measure, explain about sumx, rolling avg, variables and their syntax, etc.
SQL: theoretical and practical questions on window functions, joins, aggregates, etc.
