Interview Experience – ProcDNA | Business Analyst

Batch: 2027 | Branch: ECE | Total Rounds: 4

Process Snapshot 📝

• Eligibility / Shortlisting:

  • A CGPA cutoff of 6.74 was applied, which is quite reasonable.

  • This was followed by a 1-hour online assessment covering English, Logic, and Quantitative Ability.

  • Candidates then proceeded to a business case study round.

  • Finally, there were two rounds of interviews.

• Application Route & Timeline Start: On-campus. The Online Assessment (OA) was on August 5th, with the remaining three rounds occurring on August 11th.

Round-by-Round Breakdown 🎯

Here's a detailed look at each stage:

Round 1: Online Assessment (OA)

• Focus: English, Logical Aptitude, and Quantitative Ability.

• Format: 1-hour test conducted on the college premises.

Round 2: Business Case Study

• Focus: Measured observation, calculation, and mathematical ability.

• Format: A pen-and-paper plus calculator test lasting one hour.

Round 3: Technical Interview - I

• Discussion:

  • Your thought process from the business case study, including follow-up questions.

  • SQL concepts (window functions and joins are particularly important).

  • A brief overview of projects listed on your resume.

  • A guesstimate problem.

  • A mathematical puzzle (refer to GeeksforGeeks for practice).

Round 4: Technical Interview - II

• Discussion: Similar to Round 3, but with slightly tougher questions.

• Key Activity: I was asked to demonstrate your project live on your laptop.

Difficulty, Topics, and Interview Focus 🧠

• Difficulty Across Rounds:

  • OA: Medium. Questions were easy, but time management was the real challenge.

  • Business Case Study: On the tougher side.

  • First Interview: Easy to Moderate.

  • Last Interview: Moderate.

• Most Asked Topics: SQL, projects, and puzzles (mathematical and guesstimates).

• What Interviewers Focused On: All mentioned topics were given equal importance.

Coding and Project Discussion 💻

• Coding Question Patterns / Constraints / Expected Approach:

  • For SQL, concentrate on

    code

    1JOINs

    ,
    code

    1WINDOW FUNCTIONS

    , and
    code

    1GROUP BY

    clauses.

• Project Deep-Dive (architecture, trade-offs, scaling, debugging):

  • Yes, in the final interview, the interviewer delved into alternative technologies, their pros and cons, and the underlying libraries used in my projects.

HR and Behavioral 🤔

• HR/Behavioral Questions:

  • A key question was about my motivation for pursuing a Business Analyst role, given that my projects were primarily in AI and SDE.

  • Tip: Personalize your answer based on your own career aspirations.

Final Outcome ✅

• Verdict: Selected

Mistakes to Avoid ⚠️

• Ensure good time management, especially in the business case study round. Be confident during the interview and show no shame in telling the interviewer that you don’t have an answer to a particular question.

Preparation Strategy 🚀

• What Helped Most (resources/mocks/plan):

  • Puzzles & Guesstimates: GeeksforGeeks (GFG).

  • SQL: Any good YouTube video.

  • Projects: Use AI tools for proper explanations and understanding of your projects.

• 7-Day Priority Plan for Juniors:

  • Focus on SQL.

  • Review and understand your projects thoroughly.

  • Practice puzzles.

Optional Offer Details

• Role: Business Analyst

• Location: Kharadi, Pune

Quick Checklist for Students ✔️

• CGPA: Maintain a reasonable CGPA (e.g., above 6.74).

• Online Assessment: Practice English, Logic, and Quant for speed.

• Business Case Study: Develop strong observation, calculation, and mathematical skills.

• SQL: Master

  code

  1JOINs

  ,
  code

  1WINDOW FUNCTIONS

  , and
  code

  1GROUP BY

  .

• Projects: Understand your projects deeply, including alternatives and underlying tech.

• Puzzles & Guesstimates: Practice regularly from resources like GFG.

• Behavioral: Prepare answers for why you want a specific role, especially if it differs from your project focus.

• Time Management: Crucial for both assessments and interviews.