Interview Experience – Aspect Ratio | Data Analyst 📊

College: SCTRS PUNE INSTITUTE OF COMPUTER TECHNOLOGY Batch: 2027 | Branch: EnTC| Total Rounds: 2

Process Snapshot 🚀

• Eligibility / Shortlisting: The initial criteria required a minimum of 9.4 CGPA, and all branches were eligible. This was followed by an Online Assessment (OA) covering quantitative aptitude, English, and logical reasoning.

• Application Route & Timeline Start: The company visited our campus. The online test was conducted in the first week of August.

Round-by-Round Breakdown 🎤

Here's how the interview journey unfolded:

Round 1: Online Assessment (August 11th) 🧑‍💻

This was an hour long and was divided into 2 sections

the first was the verbal and logical reasoning part

the second was 8-10 quant questions and it was a pen paper test

Round 2:

FIRST INTERVIEW

This round lasted about an hour and covered:

• Resume Discussion: Questions based on the candidate's resume.

• Quantitative Problem Solving: Solving quantitative questions.

• Coding Questions: Coding challenges directly related to the previously solved quant questions.

• Data Analysis Basics: Discussion on "What is data analysis?"

Technical & Case Study Interview (August 18th) 📈

This interview also lasted about an hour, taking place 2-3 hours after Round 1. It focused on:

• SQL Queries: Specifically, queries involving

  code

  1JOIN

  operations.

• Java Programming: A Java program related to database interactions.

• Case Study: The majority of this round involved a detailed case study about a pharmaceutical company's costs.

Difficulty, Topics, and Interview Focus 🧠

• Difficulty Across Rounds: Medium. The case study was very detailed, and the quantitative questions were time-consuming.

• Most Asked Topics: Object-Oriented Programming (OOP), Quantitative Aptitude, and Database Management Systems (DBMS).

• What Interviewers Focused On: Strong problem-solving abilities and the approach to case studies.

Coding and Project Discussion 💻

• Coding Question Patterns / Constraints / Expected Approach: SQL queries primarily involved

  code

  1JOIN

  s, and optimization of these queries was discussed.

• Project Deep-Dive (architecture, trade-offs, scaling, debugging): No deep dive into projects was conducted.

HR and Behavioral ✨

• HR/Behavioral Questions: Not many; the focus was predominantly on problem-solving skills.

• Unexpected/Tricky Moments + Handling: During one quant question, I used an incorrect approach. When asked if I thought my answer was correct, instead of hiding my mistake, I openly admitted that I believed I had miscalculated. They offered me another chance for that question, and I was able to get it right the second time.

Final Outcome ✅

• Verdict: Selected

• Top Tips for Juniors: No specific tips provided in the verdict.

Mistakes to Avoid 🚫

• Be confident, but if you don't know something, own up to it honestly.

Preparation Strategy 📚

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

  • For puzzles, using the GeeksforGeeks (GFG) puzzle sheet was very helpful.

  • Quantitative aptitude was prepared while studying for GRE.

• 7-Day Priority Plan for Juniors:

  • Dedicate most of your time to quantitative aptitude and understanding case study patterns.

  • Spend 1-2 days specifically on SQL and OOP concepts.

Optional Offer Details 💰

• Role: Analyst

• Location: Viman Nagar

• Package: 12 LPA

Quick Checklist for Students ✅

• Maintain a high CGPA (e.g., 9.4+).

• Prepare thoroughly for Online Assessments (Quant, English, Logical Reasoning).

• Practice puzzles from resources like GFG.

• Strengthen your quantitative aptitude (GRE prep is a good benchmark).

• Familiarize yourself with case study patterns and problem-solving.

• Master SQL queries, especially

  code

  1JOIN

  s and optimization.

• Revise Object-Oriented Programming (OOP) and DBMS concepts.

• Practice honesty and confidence during interviews.