🎯 Interview Experience

1. 🏢 Company & Role

• Company: ZS Associates
• Role: Business Technology Solutions Associate (BTSA)
• Batch/Year of Graduation: 2026
• Branch: IT

2. 🗓 Application Process

• How did I apply? Campus Placement
• Timeline: August
• Interview Dates: August

💬 Interview Rounds

Round 1: Aptitude & Quantitative Ability

• Type: MCQ-based Aptitude & Quant
• Description: Questions on logical reasoning, quantitative ability, and problem-solving. Time management was key.
• Difficulty Level: Medium
• Your Experience: A mix of easy and moderate questions. Aptitude practice beforehand helped a lot.

Round 2: Verbal & English Proficiency

• Type: Verbal Reasoning & English Communication
• Description: Focused on grammar, comprehension, and vocabulary. Some scenario-based questions were also included.
• Difficulty Level: Easy to Medium
• Your Experience: Straightforward if you’re comfortable with English. Reading comprehension required careful attention.

Round 3: Technical Assessment

• Type: Coding + SQL + DBMS MCQs
• Description:
  • 1 DSA question (coding, easy level)
  • 2 SQL queries (medium, including window functions)
  • 10 MCQs on DBMS & SQL (tested conceptual clarity and practical knowledge)
• Difficulty Level: Medium
• Your Experience: The DSA problem was solvable with clear logic. SQL required solid command over joins and window functions. The MCQs covered normalization, indexing, transactions, joins, and SQL functions.

🏢 Offline Interview Rounds

Interview 1: Technical Interview

• Topics Covered: Resume discussion, DBMS, SQL, DSA, Guesstimates, Puzzles
• Description:
  • SQL queries (medium to hard level)
  • DSA coding question (easy level)
  • Guesstimate questions (approach mattered more than numbers)
  • Puzzles (prepared from GeeksforGeeks “Top 100 Puzzles” helped a lot)
• Difficulty Level: Medium to Hard
• Your Experience: SQL and DBMS were deeply tested. Guesstimates and puzzles needed structured logical thinking.

Interview 2: Managerial Round

• Type: Situation-based + Behavioral Questions
• Description:
  • Situation-based problem solving
  • Questions on non-technical contributions (teamwork, leadership, extra-curriculars)
  • Behavioral and HR-style questions
• Difficulty Level: Medium
• Your Experience: Communication and mindset were evaluated more than technical knowledge. Highlighting teamwork and adaptability was important.

📊 Overall Experience & Tips

• Overall Interview Experience: Positive. A well-balanced process that tested aptitude, technical depth, and managerial skills.

What to Prepare?

• Aptitude & Quantitative ability
• SQL (joins, aggregates, window functions)
• DBMS fundamentals (normalization, transactions, indexing, keys)
• DSA basics & coding practice (easy–medium level)
• Puzzles & Guesstimates (GeeksforGeeks recommended)
• Behavioral & situation-based questions

Tips for Aspirants:

• Be thorough with SQL & DBMS concepts (since MCQs + queries are asked).
• Practice coding (arrays, strings, maps) daily.
• Prepare for guesstimates & puzzles (focus on structured reasoning).
• Revise your resume projects—expect in-depth technical questions.
• For managerial round, be ready to show teamwork, leadership, and adaptability.

Verdict: ✅ Selected