J'ai passé un entretien chez CGI (Casablanca, Grand Casablanca)
Entretien
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.
Questions d'entretien [1]
Question 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.
J'ai postulé via un recruteur. J'ai passé un entretien chez CGI (Bengaluru) en févr. 2022
Entretien
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.
Questions d'entretien [1]
Question 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.