PwC Associate Interview Questions, Process, and Tips

Aptitude was about moderate level there were some aptitude question some of were general reasoning ,english,IT fundamental question and there was one codin question as well which was of decent level i would say.

Q1. Tell me something about yourself
View 2 more answers
Q2. Explain me your projects
Add your answer
Q3. How will you design you college website.
Add your answer
Q4. What are the key features you will put in your college website.
Add your answer
Q5. Do you know about stlc explain something about stlc.
Ans. 
STLC stands for Software Testing Life Cycle. It is a process followed to ensure quality in software development.
• STLC involves planning, designing, executing and reporting of tests.

• It includes various stages like requirement analysis, test planning, test design, test execution, and test closure.

• Each stage has its own set of deliverables and objectives.

• STLC helps in identifying defects early in the development cycle, red...read more
Answered by AI
Add your answer
Q6. Explain the whole cycle of stlc.
Add your answer
Q7. What is normalization and explain all normal forms.
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and dependency.
• First Normal Form (1NF) - Eliminate duplicate columns from the same table.

• Second Normal Form (2NF) - Create separate tables for sets of values that apply to multiple records.

• Third Normal Form (3NF) - Eliminate fields that do not depend on the primary key.

• Fourth Normal Form (4NF) - Eliminate multi-valued dependencies.

• Fifth ...read more
Answered by AI
Add your answer
Q8. Write a query to fetch second highest salary in sql
Ans. 
Query to fetch second highest salary in SQL
• Use ORDER BY and LIMIT to select the second highest salary

• Assuming the table name is 'employees' and salary column name is 'salary':

• SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Answered by AI
Add your answer
Q9. Do you have any question for me .
Add your answer

Q1. Where do you see yourself in 5 years?
Add your answer
Q2. Tell me about yourself.
Add your answer
Q3. Are you willing to do internship with us .
Add your answer
Q4. Do you have any questions for me .
Add your answer

45 questions, duration 1 hour

Q1. Based on the projects.
Add your answer
Q2. Based on the skills you mentioned in your resume.
Add your answer

Q1. Based on the extra skills
Add your answer
Q2. Puzzles and aptitude questions
Add your answer

Q1. Why you want to join PWC
Add your answer
Q2. How you will handle criticism.
Add your answer

Q1. Pandas data frame manipulation questions, First was to change value of cell based certain conditions. Difference between iloc and loc with an example
Add your answer
Q2. Guesstimate: no of airplane that took off and land in Mumbai airport
Ans. 
Approximately 700 airplanes take off and land at Mumbai airport daily.
• Consider the average number of flights per day at Mumbai airport

• Factor in peak travel times and seasonal variations

• Take into account the types of aircrafts that operate at the airport
Answered by AI
Add your answer
Q3. Case Study : A retailer client is loosing his revenue from business, analyze the cause of decline.
Ans. 
The retailer client is experiencing a decline in revenue, analyze the cause.
• Conduct a thorough analysis of the retailer's financial statements to identify any trends or patterns in revenue decline.

• Evaluate the competitive landscape to see if new competitors have entered the market or existing competitors have gained market share.

• Assess the retailer's marketing and advertising strategies to determine if they are effecti...read more
Answered by AI
Add your answer

A case study statement along with large data set was provided, it had 6 sub problems where I was open to take assumption and do whatever analysis with the given data and was expected to come up with strategy/solution to solve those 6 sub problems.

I was given 3 days to solve this case study and was asked to present the solution on ppt or power bi dashboard. Use of any programming language like python, sql was allowed for data analysis.

3 days deadline was strictly followed.

Case study round was taken by Senior Manager at PwC. He initially asked many questions on my work experience, projects previous firm, domain specific question.

Case study solution for above 6 sub problems was extensively discussed. He thoroughly examined the solution right from data analysis codes(sql, python) to end visualization and strategy to solve those problem.

Q1. Tell me about Articleship Experience.
Add your answer
Q2. Recent M&A and how that transaction was structured.
Add your answer
Q3. Recent budget amendments
Add your answer

There were 45 questions to be solved in less than an hour, which included verbal and quantitative aptitude.

Q1. Explain about project and questions related to the project were asked
Add your answer

Q1. Overview on form 1120 Accrued concept Depreciation concept
Add your answer