Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by ProSquad Consulting Team. If you also belong to the team, you can get access from here

ProSquad Consulting Verified Tick

Compare button icon Compare button icon Compare
5.0

based on 5 Reviews

Filter interviews by

ProSquad Consulting Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

Functional Testing Senior Consultant Interview Questions & Answers

Deloitte user image Anonymous

posted on 4 Feb 2025

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed in Jan 2025.

Round 1 - HR 

(2 Questions)

  • Q1. Current CTC, Expected CTC, Notice Period, Skill set
  • Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
Round 2 - Technical 

(10 Questions)

  • Q1. Introduction, Current role and responsibilities
  • Q2. List out the achievements in current project, Tools used
  • Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
  • Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
  • Q5. Explain Software Testing Life Cycle, Defect Life Cycle
  • Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
  • Q7. What kind of links and labels can be tagged to a bug in jira?
  • Q8. Have you done shell scripting? What does grep, href commands do in unix?
  • Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
  • Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...

Interview Preparation Tips

Interview preparation tips for other job seekers - Not a good experience. Some recruiters are very arrogant and have no respect for the people interviewing with them. They consider as themselves dummy kings, because they are working in Deloitte USI. I interacted with 4-5 recruiters for one opening (from Gurgaon / Hyderabad). One HR even said to me that I was not the only person interviewing with them, they have bunch of people to chose, also various other things were said in a very unprofessional and rude manner. She had no ethics of talking to an experienced resource, when I escalated this to the seniors, they immediately apologized for her behavior and I was then handled by another Senior HR

I applied via referral in Deloitte USI but to save their referral bonus (I guess), they rejected my profile on the portal and called me through Naukri.com. When I asked them the reason, they said its for a different profile them. however it was for the same one.
Also on their career site, it was not mentioned that role is of fixed term hire (for 2 years), but HR disclosed it later, during the conversation. (another discrepancy)

During my initial conversation, HR clearly said there won't be any night shifts and I would have to work from client's location in Gurgaon office. Although it is 2 year contractual role.
But during my technical interview, the person clearly said to me that I would have to relocate to Bangalore for working from client's secured ODC in office. Also there would be rotational/ night shifts (without any extra pay). Basically they were looking for someone who would devote his 24X7 time to the company for a minimal salary and does not demand for work life balance or weekends off

Neither the HR nor the interviewer opened their web camera during the video call. But HR kept asking me to keep my camera open, even during the waiting time
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I was interviewed in Jan 2025.

Round 1 - Group Discussion 

Programming questions related to Python and React.

Round 2 - Group Discussion 

Programmatical problem related to Python and React

Round 3 - HR 

(1 Question)

  • Q1. Salary Discussion
Round 4 - Aptitude Test 

Programming Problems related to react and python.

Round 5 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, Memory Management, Multiprocessing, multithreading, GIL, React Components
Round 6 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Round 7 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Round 8 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Round 9 - One-on-one 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy, Django ORM, Class Inheritance

Interview Preparation Tips

Interview preparation tips for other job seekers - In the name of the client Round, the internal team will contact you to conduct interview calls known as Preparation Call Round before the Client Round, aimed at creating a positive impression for the client. Typically, no additional rounds follow the HR round, but they conducted five more rounds while merely reiterating the aforementioned details, which led me to cancel my own job application.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed in Jan 2025.

Round 1 - One-on-one 

(5 Questions)

  • Q1. Basics of Python, Flask, ReactJs, RestApi Development
  • Q2. Python - Difference between is and ==
  • Q3. React - useEffect vs useState
  • Q4. Authentication in RestApi
  • Q5. React - Pure Component and Higher order components
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - Technical 

(5 Questions)

  • Q1. What is the SQL query using PIVOT to transform the given input table into the expected output?
  • Q2. What is the process flow for implementing an incremental load?
  • Q3. What are the steps involved in query optimization?
  • Q4. What is the process flow of Slowly Changing Dimension Type 2 (SCD 2), and what are the associated post commands?
  • Q5. Difference Between dimension tables and fact tables.Which one loaded firs?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Dec 2024.

Round 1 - Technical 

(6 Questions)

  • Q1. What is spark,explain its ecosystem
  • Q2. What are transformations, and how many types of transformations exist?
  • Q3. Explain about spark job process and its planning
  • Q4. What are the concepts of coalesce and repartition in data processing?
  • Q5. Explain about oom and driverhead memory
  • Q6. What is data skewness
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via campus placement at National Institute of Technology (NIT), Warangal and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Normal to medium level general aptitude questions

Round 2 - Technical 

(2 Questions)

  • Q1. Types of building contract
  • Q2. Type of soil for each buildings
Round 3 - One-on-one 

(2 Questions)

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

Interview Preparation Tips

Topics to prepare for WSP Due Diligence Analyst interview:
  • Building contracts
  • Soil Mechanics
Interview preparation tips for other job seekers - Answering to situational questions wisely is very important
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected
Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain projects worked on and benefits
  • Q2. What is agile , SDLC, user stories
  • Ans. 

    Agile is a project management methodology focused on iterative development, SDLC is the software development life cycle, and user stories are short descriptions of a feature told from the perspective of the end user.

    • Agile is a project management approach that emphasizes flexibility, collaboration, and customer feedback.

    • SDLC is the process of planning, creating, testing, and deploying software applications.

    • User stories ...

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. How will to create a new market in vietnam for LC/BG
  • Ans. 

    To create a new market in Vietnam for LC/BG, we can start by conducting market research, building relationships with local businesses and government agencies, and offering tailored financial solutions.

    • Conduct market research to understand the needs and preferences of Vietnamese businesses

    • Build relationships with local banks, businesses, and government agencies to establish credibility and trust

    • Offer tailored financial ...

  • Answered by AI
  • Q2. What is acceptance criteria
  • Ans. 

    Acceptance criteria are conditions that a product must satisfy to be accepted by a user, customer, or stakeholder.

    • Acceptance criteria are typically defined during the planning phase of a project.

    • They are used to determine whether a product or feature is complete and functioning as expected.

    • Acceptance criteria are often written in a specific format, such as 'Given X, when Y, then Z.'

    • They help ensure that the product mee...

  • Answered by AI

Skills evaluated in this interview

Analyst Interview Questions & Answers

Citco user image Dhiraj Dhande

posted on 8 Jan 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. What is Derivatives
  • Q2. What is financial Markets
  • Q3. V Lookup, X Lookup, H lookup
  • Q4. Experience in SQL And Power bi
  • Q5. Internship Experience
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Nov 2024.

Round 1 - Aptitude Test 

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

Round 2 - Coding Test 

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

Round 3 - Technical 

(4 Questions)

  • Q1. What is rest api's
  • Ans. 

    REST APIs are a set of rules and conventions for building and interacting with web services.

    • REST stands for Representational State Transfer

    • Uses standard HTTP methods like GET, POST, PUT, DELETE

    • Data is transferred in JSON or XML format

    • Stateless communication between client and server

    • Example: GET request to retrieve data from a server

  • Answered by AI
  • Q2. What is components
  • Ans. 

    Components in software development are modular, reusable parts of a system that perform specific functions.

    • Components are building blocks of a software system

    • They are designed to be modular and reusable

    • Each component performs a specific function or set of functions

    • Examples include buttons, forms, navigation bars in a web application

  • Answered by AI
  • Q3. Some related to github
  • Q4. Explain about api testing
  • Ans. 

    API testing involves testing the functionality, reliability, performance, and security of APIs.

    • API testing ensures that the API functions as expected and meets the requirements.

    • It involves testing the input parameters, output, authentication, error codes, and response time.

    • Tools like Postman, SoapUI, and JMeter are commonly used for API testing.

    • API testing can be done manually or automated using scripts.

    • Common types of...

  • Answered by AI
Round 4 - HR 

(2 Questions)

  • Q1. Explain about your project
  • Ans. 

    Developed a web application for online food ordering and delivery service

    • Used React.js for front-end development

    • Implemented Node.js and Express.js for back-end functionality

    • Integrated payment gateway for secure transactions

  • Answered by AI
  • Q2. What is the logical problem involving 2 rooms, 3 bulbs, and 3 switches?

Interview Preparation Tips

Interview preparation tips for other job seekers - try to learn basic concepts of frontend and backend technologies

Skills evaluated in this interview

Senior Data Scientist, AAG Interview Questions & Answers

Bain & Company user image Anonymous

posted on 29 Jul 2024

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jun 2024. There were 6 interview rounds.

Round 1 - Coding Test 

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

Round 2 - Technical 

(1 Question)

  • Q1. Mostly resume based, went deep into projects and asked basics of ML algorithms, ML Ops and OOPS concepts
Round 3 - Technical 

(1 Question)

  • Q1. Resume based questions, basics of Machine Learning, and small case study (problem formulation and feature brainstorming)
Round 4 - Technical 

(1 Question)

  • Q1. Different types of ML models, how they work, differences among them. Types of performance metrics, pros and cons of them, etc.
  • Ans. 

    Different types of ML models, how they work, differences among them, types of performance metrics, pros and cons.

    • Types of ML models include linear regression, decision trees, support vector machines, neural networks, etc.

    • ML models work by learning patterns from data to make predictions or decisions.

    • Differences among models include complexity, interpretability, scalability, and performance.

    • Performance metrics for ML mod...

  • Answered by AI
Round 5 - Case Study 

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

Round 6 - Case Study 

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).

Interview Preparation Tips

Interview preparation tips for other job seekers - - I would say do not waste your time on this. Just keep it running in the backend.
- I made the mistake of spending too much time on this alongside my busy job. Even though all the interviews went very well, I did not receive the job offer and they just sent me a simple rejection template email after I invested 2 months of my time and had given 6 rounds of interviews.
- I don't know how the culture at the company is, if it is not decent enough to send me the feedback (even after requesting it) given that I invested so much of my time and even the interviewers were impressed with my interviews.

Skills evaluated in this interview

Tell us how to improve this page.

ProSquad Consulting Reviews and Ratings

based on 5 reviews

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 5 Reviews and Ratings
Compare ProSquad Consulting with

VISION

4.0
Compare

TechSci Research

2.6
Compare

Wazir Advisors

3.8
Compare

Zipgrid

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview