Upload Button Icon Add office photos

Filter interviews by

The Smart Cube Senior Analyst Interview Questions and Answers for Experienced

Updated 20 Dec 2016

The Smart Cube Senior Analyst Interview Experiences for Experienced

1 interview found

I was interviewed in Dec 2016.

Interview Questionnaire 

3 Questions

  • Q1. Solve the given Case Study, data about a PE firms investments was given
  • Q2. Guesstimate question : About the market size for Grofers
  • Ans. 

    The market size for Grofers is estimated to be in the range of several billion dollars.

    • Grofers is a leading online grocery delivery platform in India.

    • It operates in multiple cities and has a large customer base.

    • The market for online grocery delivery has been growing rapidly in recent years.

    • Competitors like BigBasket and Amazon Pantry also contribute to the overall market size.

    • Factors like increasing internet penetratio...

  • Answered by AI
  • Q3. Discussion of the case study solved in the written round

Interview Preparation Tips

Round: Editorial Round (Written + Verbal)
Experience: The written round had 2 sub-parts
1) Solve the case-study
2) Write in 300 words about any current affairs Topic

The verbal communication round was pretty basic and it was just to see how confidently you communicate.

Round: Technical Interview
Experience: The 2nd technical round focussed on a case study based on a procurement supply chain for a e-commerce website tying up with a shoe vendor.

Round: HR Interview
Experience: They asked me about why would I be willing to join Smart Cube and why am I looking to make my career in market research.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Aptitude Test 

Excel Questions related to Pivot

Round 2 - Technical 

(2 Questions)

  • Q1. Guestimate was asked
  • Q2. Advanced Excel questions
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Basic questions on recruitment.
Round 3 - Technical 

(2 Questions)

  • Q1. Technical recruitment process question.
  • Q2. Xray search strings

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview would take a lot of time. They will take a week to schedule 1 round and another week. 2-3 weeks to complete all the interviews.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Feb 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me abou Your self
  • Q2. What is your weakness and strength
Round 3 - One-on-one 

(2 Questions)

  • Q1. What is your biggest fear of your workplace and how you overcome
  • Q2. What is PTP cycle
  • Ans. 

    PTP cycle stands for Procure-to-Pay cycle, which is the process of obtaining and paying for goods and services.

    • PTP cycle involves requisitioning, purchasing, receiving, and paying for goods and services.

    • It starts with the need for a product or service, followed by creating a purchase order, receiving the goods, and finally processing the payment.

    • Efficient PTP cycle helps in managing costs, controlling spend, and ensuri...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Only be confident and give your best

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Nov 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

General knowledge questions

Round 3 - One-on-one 

(2 Questions)

  • Q1. How do came to know about Willis
  • Q2. From one the friend working in this organisation

I applied via Referral and was interviewed in Aug 2021. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Share more about your professional experience.
  • Q2. Data Based Case Study to understand my experience with data.
  • Q3. Why I am looking for a job switch?
  • Q4. Do plan to do an MBA in the next 2 years?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be articulate. Try to leverage points that make you a stand out candidate.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Technical 

(4 Questions)

  • Q1. Most of the interview was focused around SQL combine with case study assessment.
  • Q2. Explanation of joins
  • Ans. 

    Joins are used in databases to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column between them

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • INNER JOIN returns rows when there is at least one match in both tables

    • LEFT JOIN returns all rows from the left table and the matched rows from th...

  • Answered by AI
  • Q3. Order of execution concept
  • Ans. 

    Order of execution concept refers to the sequence in which instructions are executed in a program.

    • Instructions are executed in the order they appear in the code unless specified otherwise.

    • Some programming languages have specific rules for order of execution, such as PEMDAS in mathematics.

    • Understanding order of execution is crucial for debugging and optimizing code.

    • Example: In Python, arithmetic operators follow the PEM

  • Answered by AI
  • Q4. Explanation on nulls
  • Ans. 

    Nulls are placeholders for missing or unknown values in a database.

    • Nulls represent the absence of a value in a database field.

    • Nulls are different from empty strings or zero values.

    • Nulls can cause issues in database queries if not handled properly.

    • Nulls can be used to indicate missing data or unknown values.

    • Nulls can be replaced with default values or handled using functions like COALESCE.

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

(1 Question)

  • Q1. This was taken with Director which focused mainly on behaviour, career plans and other relevant scenario and ethics.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be throughout in SQL and show an apt for learning new things.

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before Aug 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself.
  • Q2. What salary do you expect?
Round 3 - One-on-one 

(7 Questions)

  • Q1. Please introduce yourself.
  • Q2. Tell me about your skills.
  • Q3. Tell me about your achievements apart from mentioned in the resume.
  • Q4. What is the quality rate of your team?
  • Q5. Why do you want leave your previous organisation?
  • Q6. Do you know about order management?
  • Ans. 

    Yes, order management refers to the process of receiving, tracking, and fulfilling customer orders.

    • Order management involves receiving and processing customer orders

    • It includes tracking inventory levels and ensuring timely delivery

    • Order management systems can automate the process and improve efficiency

    • Examples of order management software include SAP, Oracle, and Salesforce

    • Effective order management is crucial for cust

  • Answered by AI
  • Q7. Do you have any question for me?

Interview Preparation Tips

Interview preparation tips for other job seekers - Do your best with showing enthusiasm and don't get nervous.

I applied via Recruitment Consulltant and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. 1.Core Java Collections 2.JDBC questions 3.DevOps Interview questions. 4.Microsoft Azure 5.SQL questions on Joins Constraints Views Proc Functions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for Core Java SQL and Basic Azure
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Aptitude Test 

Questions related to your domain

Round 3 - HR 

(1 Question)

  • Q1. Why are you looking for a change?
Round 4 - One-on-one 

(2 Questions)

  • Q1. Questions related to your Previous job profile.
  • Q2. Why do you want to change job

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident about your answers

The Smart Cube Interview FAQs

How many rounds are there in The Smart Cube Senior Analyst interview for experienced candidates?
The Smart Cube interview process for experienced candidates usually has 2 rounds. The most common rounds in the The Smart Cube interview process for experienced candidates are One-on-one Round, Technical and Resume Shortlist.
How to prepare for The Smart Cube Senior Analyst interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at The Smart Cube. The most common topics and skills that interviewers at The Smart Cube expect are Python, Primary Research, Client Management, Data Management and SQL.
What are the top questions asked in The Smart Cube Senior Analyst interview for experienced candidates?

Some of the top questions asked at the The Smart Cube Senior Analyst interview for experienced candidates -

  1. Guesstimate question : About the market size for Grof...read more
  2. Guesstimate questions were asked - calculate the number of pens that a company ...read more
  3. If you are to estimate the number of cars in a country, how would you do ...read more

Tell us how to improve this page.

The Smart Cube Senior Analyst Salary
based on 280 salaries
₹6.2 L/yr - ₹16 L/yr
34% more than the average Senior Analyst Salary in India
View more details

The Smart Cube Senior Analyst Reviews and Ratings

based on 40 reviews

3.3/5

Rating in categories

2.9

Skill development

3.3

Work-Life balance

2.8

Salary & Benefits

3.7

Job Security

3.5

Company culture

3.0

Promotions/Appraisal

3.2

Work Satisfaction

Explore 40 Reviews and Ratings
Senior Analyst
280 salaries
unlock blur

₹6.2 L/yr - ₹16 L/yr

Assistant Manager
195 salaries
unlock blur

₹10 L/yr - ₹24 L/yr

Analyst
107 salaries
unlock blur

₹5 L/yr - ₹11.4 L/yr

Manager
89 salaries
unlock blur

₹13 L/yr - ₹32 L/yr

Research Analyst
87 salaries
unlock blur

₹5.5 L/yr - ₹8.2 L/yr

Explore more salaries
Compare The Smart Cube with

Fractal Analytics

4.0
Compare

Mu Sigma

2.7
Compare

AbsolutData

3.6
Compare

LatentView Analytics

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview