ZS Associates Business Technology Solutions Associate Consultant Interview Questions & Experience Guide

Interview Preparation
,
1

ZS Associates Business Technology Solutions Associate Consultant Interview Questions & Experience Guide

2

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: Dwarkadas J Sanghvi College of Engineering, Mumbai

Application Process: Applied via campus placement at Dwarkadas J Sanghvi College of Engineering, Mumbai, in August 2024.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Quantitative, logical reasoning, data interpretation, and verbal ability questions.
    • Your Approach: Focused on solving problems methodically and managing time efficiently.
    • Outcome: Cleared the round successfully.

  • Round 2 - English Proficiency:

    • Questions Asked:
      1. Grammar check question.
      2. Speaking and communication assessment.
    • Your Approach: Practiced grammar rules beforehand and spoke clearly during the communication assessment.
    • Outcome: Performed well and advanced to the next round.

  • Round 3 - Technical Round:

    • Questions Asked:
      1. How to copy a table in SQL?
      2. How to copy only the contents of a table in SQL?
    • Your Approach: Explained the SQL commands clearly and provided examples where necessary.
    • Outcome: Answered confidently and moved forward in the process.

Preparation Tips:

  • Don’t be nervous; stay calm and composed during the interview.
  • Brush up on aptitude topics, grammar rules, and SQL commands.

Conclusion:
The overall interview experience was smooth and well-structured. The key was to stay confident and articulate answers clearly. For future candidates, I’d recommend thorough preparation in aptitude, English proficiency, and technical skills relevant to the role.

3

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: (Not specified)

Application Process: I applied via the company website and was interviewed in December 2023.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: A mix of technical and general aptitude questions. Technical topics included Cloud, SQL, Python, and Data Warehousing. General aptitude focused on problem-solving.
    • Your Approach: I reviewed my technical knowledge and practiced problem-solving questions to prepare.
    • Outcome: Passed to the next round.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. A technical case study where I had to provide an end-to-end ETL solution using tools mentioned in my resume.
      2. SQL concepts like joins, case-when clause, fetch-offset clause, window functions, and CTEs.
    • Your Approach: For the case study, I structured my solution logically and explained my thought process clearly. For SQL, I demonstrated my understanding of the concepts with examples.
    • Outcome: Successfully cleared the round.

  • Round 3 - HR Round:

    • Questions Asked:
      1. Discussion about the role and the company culture.
      2. Basic HR questions like reasons for switching and motivation behind choosing the domain.
    • Your Approach: I kept my answers honest and aligned them with my career goals and the company’s values.
    • Outcome: Received positive feedback and moved forward in the process.

Preparation Tips:

  • Focus on SQL, Python, ETL, and Data Warehousing as these are key skills for the role.
  • Be confident and straightforward in your answers—avoid sugarcoating.
  • Treat the interview like a conversation to make it more engaging.

Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared, but I could have practiced more case studies to refine my approach. My advice to future candidates is to thoroughly understand the technical concepts and communicate clearly during the interview.

4

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: Netaji Subhas Institute of Technology (NSIT)

Application Process: Applied via campus placement at NSIT in February 2024.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Basic aptitude, logical reasoning, data interpretation, quantitative questions, and speaking skills.
    • Your Approach: Focused on solving the aptitude questions quickly and accurately, while ensuring clarity in the speaking section.
    • Outcome: Cleared the round successfully.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. SQL MCQs (15-20 questions).
      2. SQL query writing questions (2-3 questions) and 1 coding question in Python.
    • Your Approach: Reviewed SQL concepts and practiced query writing beforehand. For the Python question, ensured the logic was correct and the code was efficient.
    • Outcome: Advanced to the next round.

  • Round 3 - One-on-One Round:

    • Questions Asked:
      1. SQL query writing question.
      2. Guesstimate: Estimate the number of urinals in ZS office.
    • Your Approach: For the SQL question, wrote a structured query. For the guesstimate, broke down the problem logically and estimated based on office size and typical urinal distribution.
    • Outcome: Cleared the round and received positive feedback.

Preparation Tips:

  • Focus on SQL concepts and query writing, as it was a significant part of the interview.
  • Practice aptitude questions, especially logical reasoning and data interpretation.
  • Brush up on basic Python coding for any technical rounds.
  • For guesstimate questions, practice breaking down problems logically.

Conclusion:
The interview process was well-structured and tested both technical and analytical skills. Preparing thoroughly for SQL and aptitude questions helped a lot. The guesstimate round was unexpected but manageable with logical thinking. Overall, it was a great learning experience, and I would advise future candidates to focus on these areas.

5

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: [Not specified]

Application Process: I applied through campus placement in July 2024.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Easy aptitude questions were included in this round.
    • Your Approach: I focused on solving the questions quickly and accurately, ensuring I didn’t spend too much time on any single problem.
    • Outcome: Cleared this round successfully.

  • Round 2 - Verbal Round:

    • Questions Asked: Easy verbal questions were asked.
    • Your Approach: I answered the questions confidently, ensuring clarity and correctness in my responses.
    • Outcome: Advanced to the next round.

  • Round 3 - Coding Test:

    • Questions Asked: SQL and one DSA (Data Structures and Algorithms) question were asked.
    • Your Approach: For SQL, I wrote optimized queries, and for the DSA question, I used an efficient algorithm.
    • Outcome: Cleared this round as well.

  • Round 4 - Technical Round:

    • Questions Asked: SQL questions and puzzle questions were asked.
    • Your Approach: I tackled the SQL questions with clear logic and solved the puzzles systematically.
    • Outcome: Successfully cleared the technical round.

Preparation Tips:

  • Practice aptitude and verbal reasoning questions to build speed and accuracy.
  • Brush up on SQL queries and DSA concepts, as they are frequently tested.
  • Solve puzzles to improve logical thinking and problem-solving skills.

Conclusion:
Overall, the interview process was smooth and well-structured. The questions were manageable with proper preparation. I would advise future candidates to focus on SQL, DSA, and puzzles, as these are key areas tested in the technical rounds. Confidence and clarity in communication also play a crucial role in the verbal and technical rounds.

6

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: [Location not specified]

Application Process: I was interviewed in June 2024. The process included 4 rounds: Aptitude Test, Technical, Behavioral, and HR.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Aptitude and coding questions (1-1.5 hours duration).
    • Your Approach: I focused on solving the aptitude questions quickly and efficiently, ensuring I had enough time for the coding part. For coding, I practiced common problems beforehand.
    • Outcome: Cleared the round successfully.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. SQL deep dive with data modelling.
      2. Data warehousing questions and concepts.
    • Your Approach: I revised SQL concepts and data warehousing fundamentals thoroughly. For the data modelling question, I structured my answer logically, explaining my thought process clearly.
    • Outcome: Advanced to the next round.

  • Round 3 - Behavioral Round:

    • Questions Asked:
      1. Scenario-based questions.
      2. Case studies and guesstimates.
    • Your Approach: I prepared by recalling past experiences and framing them in the STAR (Situation, Task, Action, Result) format. For guesstimates, I practiced breaking down problems into smaller, manageable parts.
    • Outcome: Moved forward to the HR round.

  • Round 4 - HR Round:

    • Questions Asked: Salary negotiation.
    • Your Approach: I researched industry standards and was prepared to justify my expectations based on my skills and experience.
    • Outcome: Final offer discussion.

Preparation Tips:

  • Focus on the projects mentioned in your resume and previous experience.
  • Brush up on SQL, data warehousing, and data modelling concepts.
  • Practice scenario-based and behavioral questions using the STAR method.
  • For guesstimates, work on structuring your answers logically.

Conclusion:
The interview process was comprehensive, testing both technical and behavioral skills. What worked well for me was thorough preparation and staying calm during the rounds. If I could do anything differently, I would practice more case studies to improve my guesstimate skills. For future candidates, I’d advise focusing on your resume details and being confident in your answers.

7

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: [Location not specified]

Application Process: Applied via campus placement in July 2024.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Basic aptitude questions.
    • Your Approach: Focused on solving the questions systematically within the given time.
    • Outcome: Cleared the round.

  • Round 2 - Communication Assessment:

    • Questions Asked:
      1. Verbal question (details not specified).
      2. Topic-based verbal assessment.
    • Your Approach: Ensured clarity and coherence in responses.
    • Outcome: Cleared the round.

  • Round 3 - Coding Test:

    • Questions Asked:
      • 3 SQL questions.
      • 1 coding question.
    • Your Approach: Prioritized solving the SQL questions first and then tackled the coding problem.
    • Outcome: Cleared the round.

Preparation Tips:

  • Brush up on basic aptitude concepts.
  • Practice verbal communication and topic-based speaking.
  • Focus on SQL and coding fundamentals for the technical round.

Conclusion:
Overall, the interview process was smooth and well-structured. The key was to stay calm and manage time effectively during each round. For future candidates, I’d recommend practicing aptitude and communication skills thoroughly, along with SQL and coding basics.

8

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Application Process: The application process involved three interview rounds, starting with an aptitude test followed by two technical rounds.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Reasoning, English, and Guesstimates.
    • Your Approach: Focused on logical reasoning and practiced guesstimate problems beforehand to improve accuracy.
    • Outcome: Cleared the round successfully.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. Puzzles related to maths.
      2. “Why do you want to join consulting?”
    • Your Approach: For the puzzle, broke it down step-by-step and explained the logic clearly. For the consulting question, highlighted my interest in problem-solving and working with clients.
    • Outcome: Advanced to the next round.

  • Round 3 - Technical Round:

    • Questions Asked:
      1. Detailed explanation of SQL joins.
      2. Discussion about a project in detail.
    • Your Approach: Explained different types of SQL joins with examples and walked through my project, emphasizing my role and the challenges faced.
    • Outcome: Successfully cleared the round.

Preparation Tips:

  • Practice aptitude questions, especially reasoning and guesstimates.
  • Brush up on SQL concepts, particularly joins.
  • Be prepared to discuss your projects in detail, focusing on your contributions and learnings.
  • For consulting roles, articulate your interest in problem-solving and client interactions clearly.

Conclusion:
The interview process was structured and tested both technical and problem-solving skills. Practicing puzzles and SQL concepts beforehand helped a lot. For future candidates, focus on clarity in explanations and confidence in your answers.

9

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: Jaypee Institute of Information Technology, Noida

Application Process: Applied via campus placement at Jaypee Institute of Information Technology, Noida in September 2023.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Outcome: Shortlisted based on resume.

  • Round 2 - Aptitude Test:

  • Questions Asked: Basic aptitude questions.

  • Your Approach: Focused on time management to complete the test efficiently.

  • Outcome: Cleared the round.

  • Round 3 - English Aptitude Test:

  • Questions Asked: Basic English questions, essay writing, listening, and speaking skills assessment.

  • Outcome: Cleared the round.

  • Round 4 - Coding Test:

  • Questions Asked: Python and SQL query writing questions.

  • Outcome: Cleared the round.

  • Round 5 - Technical Round:

  • Questions Asked:

    • Introduce yourself.
    • 3 puzzle-based questions (similar to those on GeeksforGeeks).
    • 3 SQL query writing questions.
    • Behavioral questions.

  • Your Approach: Prepared puzzles from GeeksforGeeks and revised SQL concepts. Answered behavioral questions honestly.

  • Outcome: Cleared the round.

Preparation Tips:

  • Practice time management for aptitude tests.
  • Revise SQL and Python for coding rounds.
  • Solve puzzles from GeeksforGeeks for technical rounds.
  • Prepare for behavioral questions by reflecting on past experiences.

Conclusion:
Overall, the interview process was smooth and well-structured. Time management was crucial in the aptitude test, and technical preparation from GeeksforGeeks helped in the technical round. For future candidates, focus on SQL, Python, and puzzles, and ensure your resume is concise and impactful.

10

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Application Process: The application process involved multiple rounds, including an aptitude test, case study, technical round, and HR round.

Interview Rounds:

  • Round 1 - Aptitude Test:

  • Questions Asked: General aptitude questions covering quantitative and logical reasoning.

  • Your Approach: Practiced previous aptitude questions and focused on time management during the test.

  • Outcome: Cleared the round successfully.

  • Round 2 - Case Study Round:

  • Questions Asked: A case study was provided to analyze and solve.

  • Your Approach: Structured the problem, identified key issues, and proposed a logical solution.

  • Outcome: Advanced to the next round.

  • Round 3 - Technical Round:

  • Questions Asked:

    • Resume walkthrough.
    • Guesstimation question.

  • Your Approach: Explained my resume clearly and logically approached the guesstimation question by breaking it down into smaller parts.

  • Outcome: Cleared the technical round.

  • Round 4 - HR Round:

  • Questions Asked:

    • What are your strengths and weaknesses?
    • Tell me about yourself.
    • General HR questions.

  • Your Approach: Prepared answers in advance, focusing on honesty and relevance to the role.

  • Outcome: Successfully cleared the HR round.

Preparation Tips:

  • Practice guesstimation questions and revise SQL concepts.
  • Work on structuring case studies logically.
  • Prepare for common HR questions in advance.

Conclusion:
The interview process was thorough but manageable with proper preparation. Practicing aptitude questions and case studies beforehand was very helpful. For future candidates, I’d recommend focusing on logical problem-solving and clear communication during interviews.

11

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: (Not specified)

Application Process: I applied via a referral and was interviewed in April 2021.

Interview Rounds:

  • Round 1 - Technical Interview:

  • Questions Asked: Questions were primarily focused on SQL and ETL (Extract, Transform, Load) concepts, as the interview was for the ETL domain. Some puzzles, guesstimates, and HR-related questions were also included.

  • Your Approach: I focused on explaining my understanding of SQL joins (self-join and inner join) and ETL processes. For puzzles and guesstimates, I tried to break them down logically.

  • Outcome: I passed this round.

  • Round 2 - Technical Interview:

  • Questions Asked: Questions included SQL self-join and inner join scenarios of moderate difficulty. There was also a question about SQL Server Integration Services (SSIS).

  • Your Approach: I demonstrated my knowledge of SQL joins and SSIS by providing clear examples and explanations.

  • Outcome: I advanced to the next round.

  • Round 3 - Technical/HR Interview:

  • Questions Asked: This round included questions about performance tuning and query optimization in SQL, along with some HR-related queries.

  • Your Approach: I discussed techniques for optimizing SQL queries and shared my experiences relevant to the HR questions.

  • Outcome: I successfully cleared this round.

Preparation Tips:

  • Be thorough with SQL queries, as they are crucial for ZS Associates.
  • Practice puzzles and guesstimates to improve problem-solving skills.
  • Prepare for domain-specific questions based on the role you are applying for (e.g., ETL, data analysis).

Conclusion:
Overall, the interview process was challenging but well-structured. I felt confident in my SQL skills, which helped me perform well. For future candidates, I recommend focusing on SQL and practicing puzzles to build logical thinking. Being clear and concise in your answers is also key.

12

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: [Not specified]

Application Process: I applied through campus placement and was interviewed before March 2023.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: The test included regular aptitude questions covering topics like quantitative ability, logical reasoning, and verbal ability.
    • Your Approach: I brushed up on basic aptitude topics beforehand and practiced timed mock tests to improve speed and accuracy.
    • Outcome: I cleared this round successfully.

  • Round 2 - Case Study (Mini Case Study):

    • Questions Asked: This was a proctored mini case study round where we were given a business scenario to analyze.
    • Your Approach: I focused on structuring my thoughts clearly, identifying key issues, and proposing logical solutions. I also made sure to communicate my reasoning effectively.
    • Outcome: I advanced to the next round.

  • Round 3 - Case Study (Soap Company Problem):

    • Questions Asked: This round involved a detailed case study about a soap company, where we had to analyze business challenges and suggest strategies.
    • Your Approach: I broke down the problem into smaller parts, considered market trends, and proposed data-driven solutions. I also practiced active listening to address any follow-up questions.
    • Outcome: The round was challenging, but I gave my best effort.

Preparation Tips:

  • Prepare for guesstimates as they are often part of case study rounds.
  • Practice structuring case studies clearly and concisely.
  • Brush up on basic aptitude topics and time management for the written test.

Conclusion:
Overall, the interview process was rigorous but well-structured. The case study rounds tested both analytical and communication skills. I would advise future candidates to focus on problem-solving frameworks and practice mock case studies to build confidence. Also, don’t underestimate the importance of clear and concise communication during the interviews.

13

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Application Process: I applied via the company website and was interviewed before November 2020.

Interview Rounds:

  • Round 1 - Technical Interview:
    • Questions Asked:
      • Basic SQL commands.
      • MDM (Master Data Management) related questions.
    • Your Approach: I focused on explaining my understanding of SQL commands and how they apply to data management. For the MDM questions, I highlighted my experience with data governance and quality.
    • Outcome: I was hired for the role of MDM + ETL developer.

Preparation Tips:

  • Be confident during the interview.
  • Brush up on basic SQL commands and MDM concepts if applying for a similar role.

Conclusion:
The interview was straightforward, and confidence played a key role in my success. Make sure to prepare well for technical questions related to the role you’re applying for.

14

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Application Process: I applied through a recruitment consultant and was interviewed in June 2021.

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked:
      • About ETL, Data Warehousing, and Informatica.
      • Scenario-based questions.
      • SQL-related questions.
    • Your Approach: I focused on explaining my understanding of ETL processes and data warehousing concepts, along with practical scenarios. For SQL, I ensured my answers were clear and concise.
    • Outcome: Cleared this round and moved to the next stage.

  • Round 2 - HR Interview:

    • Questions Asked: General HR questions about my background, experience, and fit for the role.
    • Your Approach: I highlighted my relevant skills and experiences, aligning them with the job requirements.
    • Outcome: Successfully cleared this round.

  • Round 3 - Final Interview with ZS Team:

    • Questions Asked: More in-depth technical and scenario-based questions, along with behavioral aspects.
    • Your Approach: I combined technical knowledge with real-world examples and maintained a confident demeanor.
    • Outcome: Received positive feedback and moved forward in the process.

Preparation Tips:

  • The interview was moderate in difficulty.
  • Focus on ETL, Data Warehousing, and SQL concepts.
  • Be prepared for scenario-based questions.
  • Practice explaining your thought process clearly.

Conclusion:
Overall, the interview process was well-structured. The initial rounds were handled by a third-party company, followed by direct interviews with the ZS team. I found that being thorough with technical concepts and staying calm during scenario-based questions helped me perform well. For future candidates, I’d recommend brushing up on data-related technologies and practicing mock interviews to build confidence.

15

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: Indian Institute of Information Technology (IIIT), Guwahati

Application Process: Applied via campus placement at IIIT Guwahati before July 2023.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Logical, verbal, and quantitative questions.
    • Your Approach: Focused on solving logical puzzles and quantitative problems quickly while ensuring accuracy.
    • Outcome: Cleared the round successfully.

  • Round 2 - Coding Test:

    • Questions Asked: SQL questions and 1 coding question.
    • Your Approach: Prioritized writing efficient SQL queries and debugging the coding question thoroughly.
    • Outcome: Advanced to the next round.

  • Round 3 - One-on-One Interview:

    • Questions Asked: “Tell me about yourself.”
    • Your Approach: Gave a concise introduction highlighting my academic background, relevant skills, and interest in the role.
    • Outcome: Successfully cleared the round.

Preparation Tips:

  • Practice logical reasoning and quantitative aptitude questions from standard resources.
  • Brush up on SQL queries and basic coding problems.
  • Prepare a clear and concise self-introduction for the interview round.

Conclusion:
The interview process was smooth and well-structured. The aptitude and coding rounds tested foundational skills, while the one-on-one round was more conversational. Practicing beforehand and staying calm during the interview helped me perform well. For future candidates, I’d recommend focusing on problem-solving speed and clarity in communication.

16

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: Not specified

Application Process: I applied for the role in November 2020. The exact application method (e.g., campus placement, online application, referral) was not specified.

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked: Scenario-based questions related to clients.
    • Your Approach: I focused on understanding the client’s needs and provided solutions based on my technical knowledge.
    • Outcome: Successfully cleared this round.

  • Round 2 - HR Interview:

    • Questions Asked: “One negative point about the company you noticed while exploring the company.”
    • Your Approach: I answered honestly, mentioning “No work-life balance” as a point I had come across.
    • Outcome: Moved to the next round.

  • Round 3 - Case Study:

    • Questions Asked: Not specified.
    • Your Approach: Analyzed the case thoroughly and presented a structured solution.
    • Outcome: Cleared this round.

  • Round 4 - Final Interview:

    • Questions Asked: Not specified.
    • Your Approach: Focused on aligning my skills with the company’s expectations.
    • Outcome: Final selection.

Preparation Tips:

  • Be confident during the interview.
  • Research the company thoroughly before the interview to understand its work culture and values.

Conclusion:
Overall, the interview process was rigorous but well-structured. Being honest and confident helped me navigate the rounds successfully. For future candidates, I recommend preparing well for scenario-based questions and case studies, as they play a crucial role in the selection process.

17

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Location: [Not specified]

Application Process: Applied via campus placement before May 2023.

Interview Rounds:

  • Round 1 - Case Study Round:

    • Questions Asked: Data-related case study with basic SQL-related answers.
    • Your Approach: Focused on analyzing the data provided and applying basic SQL concepts to derive insights.
    • Outcome: Successfully cleared the round.

  • Round 2 - One-on-one Round:

    • Questions Asked:
      1. Detailed discussion about the case study from Round 1, along with additional SQL-related questions while analyzing the data.
      2. In-depth conversation about previously worked projects, covering both breadth and depth.
    • Your Approach: Prepared to explain my projects thoroughly and linked them to the skills required for the role. Also, brushed up on SQL concepts to handle follow-up questions.
    • Outcome: Cleared the round and advanced further in the process.

Preparation Tips:

  • Focus on SQL basics and data analysis techniques.
  • Be ready to discuss your past projects in detail, highlighting relevant skills like project planning, data modeling, and problem-solving.
  • Practice case studies to improve analytical thinking.

Conclusion:
The interview process was structured and focused on both technical and project-related skills. The case study round tested my analytical abilities, while the one-on-one round delved deeper into my experience. Preparing SQL and project details in advance helped me perform well. For future candidates, I’d recommend thorough preparation in these areas to ace the interview.

18

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Application Process: I applied through the company website and was interviewed before September 2023.

Interview Rounds:

  • Round 1 - Case Study Round:

    • Questions Asked: This round was conducted via HackerRank and included a case study followed by two technical rounds. The first technical round covered basic SQL and puzzles, while the second focused on advanced SQL.
    • Your Approach: I prepared by practicing SQL queries and solving puzzles to strengthen my problem-solving skills. For the case study, I focused on understanding the problem statement thoroughly before diving into solutions.
    • Outcome: I successfully cleared this round.

  • Round 2 - One-on-One Round:

    • Questions Asked:
      1. Difference between Rank, Dense Rank, and Row Number.
      2. A rolling sum question.
    • Your Approach: I explained the differences between the SQL functions clearly and demonstrated how to implement a rolling sum using window functions.
    • Outcome: I passed this round as well.

  • Round 3 - HR Round:

    • Questions Asked: Basic HR questions about my background, motivation, and fit for the role.
    • Your Approach: I answered honestly and aligned my responses with the company’s values and the role’s requirements.
    • Outcome: I cleared the HR round and received positive feedback.

Preparation Tips:

  • Focus on mastering SQL, especially window functions and common interview puzzles.
  • Practice case studies to improve problem-solving and analytical skills.
  • Be prepared to explain your thought process clearly during technical rounds.

Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared for the technical rounds, but I could have practiced more case studies to refine my approach. For future candidates, I recommend thorough preparation in SQL and problem-solving, along with a clear understanding of the company’s domain.

19

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Application Process: I applied via a referral and was interviewed before April 2023.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: The test included mathematical, logical reasoning, English, and case study questions.
    • Your Approach: I focused on solving the mathematical and logical reasoning sections first, as they were my strengths, and then moved on to the case study and English sections.
    • Outcome: Cleared this round successfully.

  • Round 2 - Case Study Round:

    • Questions Asked: A case study was shared to solve.
    • Your Approach: I analyzed the case study thoroughly, identified key problems, and proposed structured solutions.
    • Outcome: Advanced to the next round.

  • Round 3 - Case Study Discussion Round:

    • Questions Asked: The solved case study was discussed, and my approach to each question was evaluated in detail.
    • Your Approach: I explained my thought process clearly and justified my solutions with logical reasoning.
    • Outcome: Successfully cleared this round.

  • Round 4 - HR Round:

    • Questions Asked: Behavioral questions and guesstimates.
    • Your Approach: I answered behavioral questions using the STAR method and tackled guesstimates by breaking them down into smaller, manageable parts.
    • Outcome: Cleared the HR round and received the offer.

Preparation Tips:

  • Focus on preparing for case studies and guesstimates.
  • Brush up on mathematical, logical reasoning, and analytical skills.
  • Practice solving case studies under timed conditions to simulate the actual interview environment.

Conclusion:
Overall, the interview process was rigorous but well-structured. I felt well-prepared for the case study rounds, which were the most challenging. For future candidates, I’d recommend practicing case studies extensively and being clear and concise in your explanations during the discussion rounds. Good luck!

20

Company Name: ZS Associates

Position: Business Technology Solutions Associate Consultant

Application Process: I applied via Naukri.com and was interviewed before August 2023.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: The test included questions related to Maths, English, Pseudo codes, and Puzzles.
    • Your Approach: I focused on solving the puzzles and pseudo-code questions first, as they were more time-consuming, and then moved on to the Maths and English sections.
    • Outcome: Cleared the round successfully.

  • Round 2 - Case Study Round:

    • Questions Asked: The case study involved analyzing data and deriving insights from it.
    • Your Approach: I carefully read the case, identified key data points, and structured my analysis to highlight actionable insights. I also ensured my conclusions were backed by logical reasoning.
    • Outcome: Performed well and advanced to the next stage.

Preparation Tips:

  • Brush up on basic aptitude topics like Maths, English, and logical reasoning.
  • Practice pseudo-code questions to improve problem-solving speed.
  • Work on case studies to develop analytical and data interpretation skills.

Conclusion:
The interview process was well-structured and tested both technical and analytical abilities. I found the case study round particularly insightful. For future candidates, I’d recommend practicing puzzles and case studies thoroughly to perform well in these rounds.