PwC Consultant Interview Questions, Process, and Tips

Q1. Details about our professional background
Add your answer
Q2. Expected salary
Add your answer

Q1. Questions about our professional background, experience and basic technical questions
Add your answer

Q1. Excel based case study
Add your answer

Pharma case study with domain knowledge details were asked

Psychometric assessment

Q1. What are your weaknesses?
Add your answer
Q2. Mention a problem you encountered in a group project
Add your answer

Q1. Project overview
Add your answer
Q2. How to integrate data in EPBcS
Ans. 
Integrating data in EPBcS involves mapping data sources, defining data mappings, and setting up data integration processes.
• Map data sources to EPBcS data model

• Define data mappings between source systems and EPBcS

• Set up data integration processes to transfer data into EPBcS

• Use ETL tools like Informatica or Talend for data integration

• Ensure data quality and consistency during integration
Answered by AI
Add your answer
Q3. How to add data mappings
Ans. 
Data mappings can be added by defining the relationships between different data elements.
• Identify the source and target data elements that need to be mapped

• Create a mapping document specifying the relationships between the source and target data

• Implement the mappings using ETL tools or custom scripts

• Test the mappings to ensure data is accurately transformed
Answered by AI
Add your answer

THE TEST WAS FOCUSING ON ANALYTICAL SKILLS

Q1. THIS ROUND WAS FOCUSING ON OUR TECHNICAL KNOWLEDGE AND OUR FAMILARITIES WITH DIFFERENT SOFTWARE
Add your answer
Q2. YOUR INTEREST ANF FUTURE PLANS
Ans. 
I am interested in expanding my skills and knowledge in the field of technology and plan to pursue further education and certifications.
• Continuing education in technology

• Obtaining certifications in relevant areas

• Exploring new technologies and trends

• Networking with professionals in the industry
Answered by AI
Add your answer
Q3. GOOD AND WEAK POINTS
Add your answer

Q1. Tell me something about yourself.
Add your answer
Q2. Give a brief description of your work-ex.
Add your answer
Q3. Why consulting? Why PwC IT?
Add your answer
Q4. What is your opinion on the impact of US Presidential election results in India?
Ans. 
The US Presidential election results can have an impact on India's economy, foreign policy, and trade relations.
• The outcome of the election can affect the global economy, which in turn can impact India's economy.

• The foreign policy of the US towards India can change depending on the elected President and their priorities.

• Trade relations between the two countries can be affected by the policies of the new administration.

• ...read more
Answered by AI
Add your answer
Q5. What do you know about the possible acquisition of IndusInd Bank by Kotak Mahindra?
Ans. 
There have been rumors about Kotak Mahindra acquiring IndusInd Bank, but nothing has been confirmed yet.
• There have been talks about a possible merger or acquisition between the two banks.

• Kotak Mahindra is looking to expand its presence in the Indian banking sector.

• IndusInd Bank has been facing financial challenges and a merger could help stabilize its position.

• However, both banks have denied any such plans and no offic
Answered by AI
Add your answer

How would you go about integrating the IT divisions of two firms looking to go through a merger? What are the different components you would take into consideration?
Talked about the different buckets that should be considered. Applications, Infrastructure, Organization, Suppliers/Vendor Management, IT Culture, and IT Operations.

Faced further cross questioning on the applications bucket, in particular ERPs. Was asked how I would go about deciding between two different ERPs that were in use in the client and the target. Answered by mentioning points of difference between the two in terms of capabilities, pricing, etc.

A swimming pool manufacturer in the US is looking to acquire another pool manufacturer. The combined entity is also looking to launch an IPO in the future. Objectives are to assess risks, evaluate steps for IPO readiness, look at how to integrate, and to implement an overall IT transformation. Also tell me how you would order the three major tasks: IT Transformation, IPO, and IT Integration.
[Please note that I stands for Interviewer and C stands for Candidate]

Initially started with CPCC questions to get background on the two companies, the areas in which they operate, an idea of what their value chains look like, etc. This was similar for both companies.

C: What kind of products does the target manufacture? Does the target have any specific offerings that the client does not have currently?

I: The target makes vinyl-liner pools which the client does not. They also have a method of manufacturing these which are much faster than the manufacturing process of the client.

C: Right, so this is the reason the client is considering the acquisition. Would you like for me to dive deeper into the different synergies that can be achieved?

I: Yes, therefore the acquisition is being considered. Before moving further, tell me how you would order the three major tasks mentioned before.

C: Alright. Before I can decide can you tell me what is the timeline being considered for the IPO?

I: The client wants to launch the IPO in the next 5 years.

C: And what is the reason the client wants to perform this IT transformation? Do they have outdated systems or is it to streamline the IT division?

I: The client wants to perform the IT transformation because of a lack of uniformity in the applications it uses in its two divisions.

C: Then, I would put the IT transformation first to streamline the client's IT processes and make them more efficient and coherent before moving onto the acquisition and going forward with the IT integration, and then finally the IPO.

I: Alright great. How would you go forward with the IT integration? Look at this from a due-diligence perspective. What are the various considerations you would consider while merging the IT functions?

C: I would look at the following broad buckets when considering an IT integration: Applications (like ERP, CRM, etc.), Infrastructure (Hardware infra like servers, Infrastructure software like OS etc.), Organization (it is size and structure, capabilities, location, etc.), Suppliers/Vendor Management, IT Culture, and IT Operations.

There was slight deep diving into the Applications, Infrastructure and Organization buckets. Questions were around how the integration would happen.

There was also a question on IPO readiness from an IT perspective. What kind of IT requirements would be most important for making the client IPO ready? I had given an answer with mentions of financial and accounting software, and specialized software to prepare and publish financial reports, before time ran out.

Following on from the Kotak IndusInd discussion (in HR questions), how would you go about integrating the IT functions of both banks?
Started with a standard M&A IT checklist. Listed out the different components of the IT divisions that need to be looked at before a merger - Applications, Infrastructure, Organization, Suppliers/Vendor Management, IT Culture, and IT Operations.

I was asked about the Applications and Infrastructure buckets - the various components that would come under these, and the criteria I would use to evaluate how integration was to happen.

I was also asked about cloud transformation - What IT components of a bank could be moved to the cloud, and what could not? Why?