Upload Button Icon Add office photos

Filter interviews by

The Smart Cube Interview Questions and Answers for Experienced

Updated 5 Feb 2024

The Smart Cube Interview Experiences for Experienced

Popular Designations

5 interviews found

Senior Manager Interview Questions & Answers

user image subhajit saha

posted on 5 Oct 2022

I applied via Naukri.com and was interviewed in Sep 2022. There were 5 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 - Coding Test 

Hacker rank test for 2 hours. Language of your choice and problem solving and sql and data structures

Round 3 - Technical 

(2 Questions)

  • Q1. Handling different types of data. Sql functions Design considerations Performance optimization
  • Ans. 

    Handling different types of data, SQL functions, design considerations, and performance optimization.

    • Understand the data types and their limitations

    • Use appropriate SQL functions for data manipulation

    • Consider normalization and denormalization for database design

    • Optimize queries and indexes for better performance

    • Use caching and partitioning for large datasets

    • Examples: DATE functions, JOINs, indexing, partitioning

  • Answered by AI
  • Q2. How to handle data skewness in spark. What are the different performance optimization techniques in hive
  • Ans. 

    Handling data skewness in Spark and performance optimization techniques in Hive

    • For data skewness in Spark, use techniques like partitioning, bucketing, and salting

    • In Hive, use techniques like partitioning, bucketing, and indexing for performance optimization

    • Other techniques include using appropriate data types, optimizing queries, and using compression

    • Example: In Spark, partitioning can be done based on a column with h...

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. Data skewness Stake holder Management Hands on capabilities
Round 5 - HR 

(1 Question)

  • Q1. More about culture and compensation and company policy

Interview Preparation Tips

Topics to prepare for The Smart Cube Senior Manager interview:
  • Python
  • Pyspark
  • SQL
  • Cloud
  • Devops
Interview preparation tips for other job seekers - Study hard and keep some real work experience handy.

Skills evaluated in this interview

Senior Manager Interview Questions asked at other Companies

Q1. 1. What you understand the requirement of shuttering material at project site?
View answer (19)

Visualiser Interview Questions & Answers

user image Anonymous

posted on 5 Feb 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. What is your strength and weaknesses?
Round 2 - One-on-one 

(1 Question)

  • Q1. How can you satisfy me for this job if you do not have the required education background?

Interview Preparation Tips

Interview preparation tips for other job seekers - Expect the Unexpected

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 28 Mar 2022

I applied via Recruitment Consulltant and was interviewed in Sep 2021. There were 3 interview rounds.

Round 1 - Coding Test 

Round 1 post shortlisting of the Resume was a Hacker Rank test and there were 5 questions:
2 programming questions of easy to Medium difficulty
and 3 Sql questions.

Round 2 - One-on-one 

(1 Question)

  • Q1. The Second round was One-on-One Technical Interview; When I appeared for it, due to covid restrictions; it was a Virtual Interview over a google meet video call. Questions were primarily on Database Manage...
Round 3 - HR 

(5 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?
  • Q4. What are your strengths and weaknesses?
  • Q5. Tell me about yourself.

Interview Preparation Tips

Topics to prepare for The Smart Cube Data Engineer interview:
  • Azure
  • AWS
  • Spark
  • pyspark
  • python
  • SQL
Interview preparation tips for other job seekers - If your basics and fundamentals are good, you will have a great advantage. If you have previously worked on Cloud, Airflow, Python, Spark and ETL Data Warehouse, you would definitely have an advantage.

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a GameYou and your friend Ninjax are playing a game of coins. Ninjax place the 'N' number of coins in a straight line. The rule of the game is as follows: 1. Each coin has a value associated with it. 2. It’s a two-playe... read more
View answer (6)

Manager Interview Questions & Answers

user image Anonymous

posted on 23 May 2020

I applied via Recruitment Consultant and was interviewed in Nov 2019. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. I had a total of six rounds while applying for position of Manager. The first round was a telephonic interview involving questions about current job profile, projects and one case example. Second round wa...
  • Q2. First round was a written and verbal communication round with editorial team. I was asked to write a 250word summary of any current news topic. This was followed by an informal face to face discussion with...
  • Q3. The final two rounds with group manager and AVP involved Guesstimates on the market size for smart meters in india. There were also random Guesstimates related to supply chain, sourcing strategies etc. for...

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to have decent written and oral comm skills. Good knowledge of sourcing procurement concepts is an added advantage

Manager Interview Questions asked at other Companies

Q1. There is a chairman of a conglomerate. He has been on the post for 10 years, and is extremely dominating. He treats the various business heads like children, not letting them take any major decision. While the chairman has negatives, he bel... read more
View answer (2)

The Smart Cube interview questions for popular designations

 Senior Analyst

 (6)

 Data Analyst

 (5)

 Research Analyst

 (3)

 Analyst

 (2)

 Data Engineer

 (2)

 Assistant Manager

 (1)

 Intern

 (1)

 Manager

 (1)

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.

Top The Smart Cube Senior Analyst Interview Questions and Answers

Q1. If you are to estimate the number of cars in a country, how would you do it?
View answer (2)

Senior Analyst Interview Questions asked at other Companies

Q1. Explain 3 statement financial model Calculating discount rate Could you walk me through the DCF model? Other valuation methods. What PE is ideal? What is the other matrix to value the company? Difference between IRR and CAGR. What is Bond Y... read more
View answer (1)

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via LinkedIn and was interviewed in Oct 2023. There were 5 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic getting to know you and your career aspirations and what do you know about glg.
Round 2 - One-on-one 

(3 Questions)

  • Q1. What do you know about GLG?
  • Ans. 

    GLG is a professional learning platform connecting business experts with clients seeking industry insights.

    • GLG stands for Gerson Lehrman Group.

    • It is a platform that connects clients with experts in various industries for insights and advice.

    • Experts on GLG provide consultations, conduct research, and participate in events.

    • Clients include businesses, investors, and professionals seeking industry knowledge.

    • GLG has a globa...

  • Answered by AI
  • Q2. What are the products GLG offers?
  • Ans. 

    GLG offers expert network services connecting clients with industry professionals for insights and advice.

    • Expert network services connecting clients with industry professionals

    • Access to insights and advice from experts in various fields

    • Customized research projects and consultations

    • On-demand phone consultations and in-person meetings

    • Examples: market research, competitive analysis, due diligence

  • Answered by AI
  • Q3. Tell me something about yourself?
Round 3 - One-on-one 

(1 Question)

  • Q1. Panel Interview, mostly same questions as round 2, but you will be grilled more.
Round 4 - Case Study 

Be prepared, the case studies would mostly revolve around the position you have applied.

Round 5 - One-on-one 

(1 Question)

  • Q1. Stakeholder Interaction Round

Interview Preparation Tips

Topics to prepare for Gerson Lehrman Group Senior Associate Operations interview:
  • GLG History and what it does.
Interview preparation tips for other job seekers - Be confident, align yourself with the job. Think about what the challenges you would face in the role. Ask questions, research and research, at the end of the day let your confidence shine. Typical behavioral and what you know about GLG questions.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jun 2024.

Round 1 - Case Study 

Guesstimate given, brief about past experience, financial questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare guesstimates well

Senior Recruitment Business Partner - APAC Projects Interview Questions & Answers

Korn Ferry user image Anonymous

posted on 22 Nov 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Recruitment metrics
  • Q2. Offer to hiring ratio

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep it technical
Know your data
Talk to the point
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. About basic accounting and bank reconciliation.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Indeed and was interviewed in May 2023. There were 5 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 - Technical 

(1 Question)

  • Q1. Basics of python, SQL and pyspark
Round 3 - Technical 

(1 Question)

  • Q1. Questions on Python, SQL
Round 4 - Case Study 

PySpark questions to solve

Round 5 - Technical 

(1 Question)

  • Q1. Architectural questions

Interview Preparation Tips

Interview preparation tips for other job seekers - They expect you hold knowledge on everything from architecture to basics

The Smart Cube Interview FAQs

How many rounds are there in The Smart Cube interview for experienced candidates?
The Smart Cube interview process for experienced candidates usually has 3-4 rounds. The most common rounds in the The Smart Cube interview process for experienced candidates are HR, Coding Test and One-on-one Round.
How to prepare for The Smart Cube 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, SQL, Project Management, Business Research and Client Management.
What are the top questions asked in The Smart Cube interview for experienced candidates?

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

  1. How to handle data skewness in spark. What are the different performance optim...read more
  2. Handling different types of data. Sql functions Design considerations Performa...read more
  3. Guesstimate question : About the market size for Grof...read more
How long is the The Smart Cube interview process?

The duration of The Smart Cube interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.7
 • 223 Interviews
Tiger Analytics Interview Questions
3.7
 • 216 Interviews
Fractal Analytics Interview Questions
4.0
 • 201 Interviews
Axtria Interview Questions
3.0
 • 113 Interviews
C5i Interview Questions
4.1
 • 43 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
Analytic Edge Interview Questions
3.3
 • 5 Interviews
Crayon Data Interview Questions
3.6
 • 4 Interviews
View all

The Smart Cube Reviews and Ratings

based on 207 reviews

3.6/5

Rating in categories

3.3

Skill development

3.8

Work-life balance

3.1

Salary

3.8

Job security

3.8

Company culture

3.0

Promotions

3.4

Work satisfaction

Explore 207 Reviews and Ratings
Senior Analyst
259 salaries
unlock blur

₹6.5 L/yr - ₹16 L/yr

Assistant Manager
195 salaries
unlock blur

₹10 L/yr - ₹24 L/yr

Analyst
106 salaries
unlock blur

₹5 L/yr - ₹11.4 L/yr

Manager
89 salaries
unlock blur

₹13 L/yr - ₹32 L/yr

Research Analyst
86 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
Did you find this page helpful?
Yes No
write
Share an Interview