I applied online. The process took 1 week. I interviewed at Mphasis in Sept 2022
Interview
Through Video conferencing, the panel took interview from easy to varying degree of practical applicability. Focused on how good one is with basics of PowerBi (most of the duration), Couple of Q's on SQL and Basic Q's on Python
Interview questions [1]
Question 1
Q. What is Power Query Editor?
Q. What is significance for introduction of Power BI?
Q. Significance of Data Cleaning/Preprocessing/Wrangling?
Q. Diff b/w Star and Snowflake schema?
Q. Diff b/w Fact and Dimension Table?
Q. How Power BI Service functions - RLS- Challenges of Static, Gateway, Publishing Report, Sharing Report, Dashboard etc
It was 4 round process.
First one with recruiter to check overall fitment then second was with the project manager where the role and reponsibilities were discussed, third with team members for technical discussion on SQL and Tableau and then HR round for offer discussion.
