I interviewed at CGI (Casablanca, Greater Casablanca)
Interview
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.
Interview questions [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.
I applied through a recruiter. I interviewed at CGI (Bengaluru) in Feb 2022
Interview
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.
Interview questions [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.
