ProSquad Consulting Interview Questions and Answers

• Q1. Sql constrainsts, star schema, dml dcl commands
  Add Answer
• Q2. About cureent project and responsibilities
  Add Answer

• Q1. Current projects and resposibilities
  Add Answer
• Q2. Where vs having, reason for job change
  Add Answer

Normal to medium level general aptitude questions

• Q1. Types of building contract
  Add Answer
• Q2. Type of soil for each buildings
  Add Answer

• Q1. Assesment day GD for 2 rounds
  Add Answer
• Q2. All situational based questions
  Add Answer

45 questions, duration 1 hour

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

• Q1. Based on the extra skills
  Add Answer
• Q2. Puzzles and aptitude questions
  Add Answer

• Q1. Why you want to join PWC
  Add Answer
• Q2. How you will handle criticism.
  Add Answer

Some basic questions related to profit, time, and distance.

Identify the missing number in the array and remove the duplicate string from another string, then write the remaining portion.

• Q1. What is rest api's
  View Answers (1)
• Q2. What is components
  View Answers (1)
• Q3. Some related to github
  Add Answer
• Q4. Explain about api testing
  View Answers (1)

• Q1. Explain about your project
  View Answers (1)
• Q2. What is the logical problem involving 2 rooms, 3 bulbs, and 3 switches?
  Add Answer

• Q1. Tell me about yourself
  Add Answer
• Q2. Why you want to join kpmg?
  Add Answer
• Q3. What you understand about the job?
  Add Answer
• Q4. What is your work experience?
  Add Answer
• Q5. How will you see yourself within 5 years?
  Add Answer

The online assessment was broken into three individual rounds held separate days.
Online Assessment
Round 1: Aptitude test and Case Study round
Round 2: AI Communications Assessment test.
Round 3: Coding Round ( 1 DSA question + 2 SQL questions + 10-15 mcqs)

• Q1. Started off with some questions were based on resume and projects.
  Add Answer
• Q2. Questions on sql, a. joins , b. cross join, c. what is window function d. PL/SQL query e. SDLC f. Case study
  Add Answer

First round was a 1 hour online exam which had 2 sections. 1 was aptitude round which included questions like 'select the appropriate word that matches the goven word' , graph reading etc. 2nd round was technical - accounting entries , basics of SFM , FR

Video assessment - 8 questions were asked. Accrual , deferred entries, hedge fund definition , fund acconting definition , diff b/w management fee and performance fee. Question will be displayed. 1.5 mins reading time. and after should record the answer within given 2 mins time

• Q1. A telephonic interview. Basic HR quesitons - about present job , why job change , expected CTC
  Add Answer

• Q1. Online interview - around 40-45 mins. Mostly technical. Intro about yourself , questions from resume , what did you understand about the job description , accru...read more
  Add Answer

It was an hour-long coding round, asked questions on basic pandas slicing dicing, building simple regression model, handling class imbalance in SVM

• Q1. Mostly resume based, went deep into projects and asked basics of ML algorithms, ML Ops and OOPS concepts
  Add Answer

• Q1. Resume based questions, basics of Machine Learning, and small case study (problem formulation and feature brainstorming)
  Add Answer

• Q1. Different types of ML models, how they work, differences among them. Types of performance metrics, pros and cons of them, etc.
  View Answers (1)

Develop a solution for inventory optimization of a Shoe retailer. Forecast sales and plan inventory at a store level for a national seller.

Why you want to join the company, Simple case (how do you use analytics to clear stock of a particular seasonal product after the peak season).