I applied through a staffing agency. The process took 2 weeks. I interviewed at PwC (Bengaluru) in Aug 2024
Interview
Its pretty good and we can learn things from this.sql questions and basics of python
RDBMS Questions
Datawarehouse concepts
data mining
data cleansing
how to replace a string with another string by using replace
Interview questions [1]
Question 1
scd types,datawarehouse concepts,lead,lag,rank,dense rank,row number
On call technical round - more about your project , sql queries optimisation and in depth physical working of database.
Managerial round: discussion more around dimensional modelling, BI reporting and Complex queries
Interview questions [1]
Question 1
They asked me to optimise the dimensional model table and asked me how faster and efficient I can make them.
I applied online. The process took 5 days. I interviewed at PwC (Prague) in Oct 2024
Interview
They ask you to talk about yourself. Then they present the team and the company. They do it and never give you any feedback. There is no real description of the whole interview process.
Candidates applying for Senior Data Analyst roles take an average of 5 days to get hired, when considering 2 user submitted interviews for this role. To compare, the hiring process at PwC overall takes an average of 28 days.
Common stages of the interview process at PwC as a Senior Data Analyst according to 2 Glassdoor interviews include:
One on one interview: 67%
Phone interview: 33%
Here are the most commonly searched roles for interview reports -