Upload Button Icon Add office photos

Filter interviews by

Shopclues Senior Analyst Interview Questions and Answers

Updated 1 Sep 2023

Shopclues Senior Analyst Interview Experiences

1 interview found

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

I applied via Referral and was interviewed before Sep 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 - HR 

(1 Question)

  • Q1. Introduction about ur self
Round 3 - One-on-one 

(1 Question)

  • Q1. About experience & all things.

Interview questions from similar companies

Interview Questionnaire 

19 Questions

  • Q1. How was your day?-Tell me about yourself
  • Ans. 

    My day was productive and fulfilling. As for myself, I am a driven and detail-oriented individual with a passion for problem-solving.

    • I tackled several challenging tasks at work and made significant progress on each of them.

    • I also took some time to exercise and clear my mind, which helped me stay focused throughout the day.

    • As for myself, I have a background in engineering and enjoy using my analytical skills to find cre...

  • Answered by AI
  • Q2. How to optimize the code that you had written in aptitude test - It was a discussion, he helped me in solving the problem
  • Ans. 

    Optimizing code involves identifying and removing bottlenecks to improve performance.

    • Identify the parts of the code that are taking the most time to execute

    • Use efficient algorithms and data structures

    • Minimize the number of function calls and loops

    • Avoid unnecessary calculations or operations

    • Use caching or memoization to avoid repeating calculations

    • Profile the code to measure performance improvements

  • Answered by AI
  • Q3. Now write an optimized version of that code
  • Ans. 

    Optimized version of given code

    • Use efficient data structures and algorithms

    • Avoid unnecessary loops and conditions

    • Minimize function calls and variable assignments

  • Answered by AI
  • Q4. How was your day?-Tell me about yourself?
  • Ans. 

    My day was productive and fulfilling. As for myself, I am a driven and detail-oriented individual with a passion for problem-solving.

    • I tackled several challenging tasks at work and made significant progress on each of them.

    • I also took some time to exercise and clear my mind, which helped me stay focused throughout the day.

    • As for myself, I have a background in engineering and enjoy applying my analytical skills to a var...

  • Answered by AI
  • Q5. Which language do you prefer to code in? "Have you read The C Programming Language book by Dennis Retchie?" Which technical book have you read recently?.-So you like C, have you ever thought of bringing up...
  • Ans. 

    Yes, I prefer coding in C and have read The C Programming Language book. I have also explored the concept of Inheritance in C.

    • I find C to be a powerful and efficient language for system programming.

    • Yes, I have read The C Programming Language book by Dennis Retchie and found it to be a great resource.

    • Recently, I have been exploring the concept of Inheritance in C through various online resources and tutorials.

    • While C do...

  • Answered by AI
  • Q6. What is the reason behind inventing the concept of inheritance? Write a program and explain
  • Ans. 

    Inheritance allows a class to inherit properties and methods from another class.

    • Inheritance promotes code reusability and saves time and effort in programming.

    • It allows for the creation of a hierarchy of classes with shared characteristics.

    • For example, a class Animal can be inherited by classes such as Dog, Cat, and Bird, which share common properties and methods.

    • Inheritance can be implemented using the 'extends' keywo

  • Answered by AI
  • Q7. What is Liskov substitution principle?
  • Ans. 

    Liskov substitution principle is a principle in object-oriented programming that states that objects of a superclass should be able to be replaced with objects of its subclasses without affecting the correctness of the program.

    • Subtypes must be substitutable for their base types

    • Derived classes must not change the behavior of the base class

    • Violating the principle can lead to unexpected behavior and errors

    • Example: A squar...

  • Answered by AI
  • Q8. Explain OOPs concepts with a program for each
  • Ans. 

    Explanation of OOPs concepts with programs

    • Encapsulation: Wrapping data and functions into a single unit. Example: Class in Java

    • Abstraction: Hiding implementation details and showing only necessary information. Example: Abstract class in C#

    • Inheritance: Acquiring properties and behavior of a parent class. Example: Child class extending parent class in Python

    • Polymorphism: Ability of an object to take many forms. Example:

  • Answered by AI
  • Q9. Write a code for dynamic polymorphism
  • Ans. 

    Dynamic polymorphism is achieved through virtual functions and inheritance in object-oriented programming.

    • Create a base class with virtual functions

    • Create derived classes that override the virtual functions

    • Use pointers or references of the base class to call the virtual functions

    • The appropriate derived class function will be called based on the object being pointed to or referred to

  • Answered by AI
  • Q10. What is the drawback of global variables?
  • Ans. 

    Global variables can lead to unexpected changes and make debugging difficult.

    • Global variables can be accessed and modified from any part of the code, making it difficult to track changes.

    • They can cause naming conflicts if multiple variables with the same name are used in different parts of the code.

    • Using global variables can make it harder to test and debug code, as it can be difficult to isolate the cause of errors.

    • Th...

  • Answered by AI
  • Q11. Why using 'goto' is a bad programming practice?
  • Ans. 

    Using 'goto' can make code hard to read, maintain and debug.

    • Goto statements can create spaghetti code that is difficult to follow.

    • It can make it harder to understand the flow of the program.

    • It can also make debugging more difficult.

    • There are usually better alternatives to using goto, such as using loops or functions.

    • Some programming languages, such as Java and Python, do not even have a goto statement.

    • Using goto can al...

  • Answered by AI
  • Q12. Which is your favourite subject? Why? Name a book for that subject
  • Ans. 

    My favorite subject is history because it helps me understand the present and learn from the past.

    • I enjoy learning about different cultures and how they have evolved over time

    • I find it fascinating to study the causes and effects of major historical events

    • One of my favorite books on history is 'Guns, Germs, and Steel' by Jared Diamond

  • Answered by AI
  • Q13. Bring modularity in the code that you had written in aptitude test
  • Q14. Told me to make changes as per his wishes in that code-What is DRY in software engineering?
  • Q15. Gave a puzzle (find the heaviest ball amongst 8 balls in an optimized way). Tell the logic and write code for it.-write Create, Update, Delete, Insert, Select, Join SQL queries for a given problem
  • Q16. Asked me one sentence questions about the technologies that I had mentioned in resume... What is..... HTML, CSS, JQuery, JSP?
  • Q17. What are implicit objects in JSP?
  • Ans. 

    Implicit objects are pre-defined objects in JSP that can be accessed without being explicitly declared.

    • Implicit objects are created by the JSP container during the translation phase.

    • They can be accessed using predefined names such as request, response, session, application, out, pageContext, config, and exception.

    • For example, the request object can be used to retrieve parameters from a form or URL.

    • The session object ca...

  • Answered by AI
  • Q18. Name a web server and an application server
  • Ans. 

    Apache is a popular web server and Tomcat is a widely used application server.

    • Apache is an open-source web server that supports multiple operating systems and is known for its stability and security.

    • Tomcat is a Java-based application server that is used to deploy Java web applications and supports servlets and JSPs.

    • Other popular web servers include Nginx and Microsoft IIS.

    • Other popular application servers include JBoss...

  • Answered by AI
  • Q19. How to deploy web application on apache tomcat?-What is Collections in Java?
  • Ans. 

    To deploy a web application on Apache Tomcat, the application needs to be packaged as a WAR file and then deployed to the Tomcat server.

    • Create a WAR file of the web application

    • Copy the WAR file to the Tomcat webapps directory

    • Start the Tomcat server

    • Access the web application using the URL http://localhost:8080/

    • Collections in Java are classes that implement collections of objects, such as lists, sets, and

  • Answered by AI

Interview Preparation Tips

College Name: IIT MADRAS

Skills evaluated in this interview

Analyst Interview Questions & Answers

Flipkart user image Pratyaksh Karan

posted on 28 Mar 2015

Interview Preparation Tips

Round: Group Discussion
Experience: Nicely organized GD, civilized and intellectual GD group, discussion rich topic
Tips: Allow others to speak when they have something to say. Do try to push your way in if someone is talking too long or talking gibberish. Do not push your point too much, however, present logical arguments in favor. Try to draw similarities from what others say. Try to include all.

Round: HR Interview
Experience: Friendly HR interviewer. Non-direct questions but not too difficult.
Tips: Answer all questions honestly but be polite. Don't present too strong views, you are too young for that. Don't repeat content with different words, but be elaborate enough to let the interviewer know you.

Round: Guesstimate Interview
Tips: Read up some guesstimates and case studies before placements, discuss some with friends too. Open up your mind while guesstimating. Speak all that comes to your head, and vocally sift through them to get the logical and pursue-able approaches. The interviewer should get a complete idea of your analytical approach.

College Name: IIT Kharagpur
Motivation: First foray into corporate structure. Lots of opportunities. Diversified experiences.

Interview Questionnaire 

3 Questions

  • Q1. General HR questions, some based on the CV
  • Q2. A marketing specific question
  • Q3. Weight of an aircraft
  • Ans. 

    The weight of an aircraft is crucial for its performance and safety.

    • The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.

    • The weight of an aircraft is measured in pounds or kilograms.

    • The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.

    • Aircraft manufacturers provide maximum takeoff and la...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.

Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.

Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.

Round: Guesstimate Interview
Experience: A very commonly asked guesstimate problem. Ask as many questions as possible to clear out the situation for yourself and get enough hints to solve the problem. Break it down into smaller sections and solve each section individually.
Tips: Follow "case in point", Analytics Vidya and similar blogs and websites to practice more and more guesstimates.

General Tips: There are so many opportunities. You just need one. Be focused on that ONE.
Skill Tips: Take part in discussions among your friends. Read books and quora to get more content. Practice as many questions as possible for aptitude. Discuss problems and have critical analysis sessions to understand things with a company's perspective.
Skills: Communication , Aptitude, Business Acumen
College Name: IIT GUWHATI
Motivation: To learn the operations and Logistics of the e-commerce industry.
Funny Moments: There will be many while you'll be preparing with your friends. :D
All the best.

Interview Questionnaire 

1 Question

  • Q1. Question 1: General HR questions, some based on the CV Question 2: A marketing specific question

Interview Preparation Tips

Round: Test
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Duration: 40 minutes

Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Duration: 50 minutes

Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.

Skills: Communication And Confidence, Analytical Skills, Business Logic, Business Acumen
College Name: Institute of Management, Nirma University

I appeared for an interview before Nov 2019.

Interview Questionnaire 

6 Questions

  • Q1. Visualize a Uber database of drivers and riders(users) and write a SQL query to get the top 100 drivers by city.
  • Ans. 

    SQL query to get top 100 Uber drivers by city

    • Join drivers and users tables on city

    • Aggregate driver ratings and count of rides

    • Order by rating and count of rides

    • Limit to top 100

  • Answered by AI
  • Q2. How do you optimize the listing of Restaurants on Swiggy?
  • Ans. 

    Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

    • Analyze user behavior and preferences to understand their needs and preferences

    • Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

    • Optimize search functionality to ensure accurate and relevant results

    • Collaborate with restaurants to imp...

  • Answered by AI
  • Q3. What are the major differences between a Linear Regression and a Logistic Regression?
  • Ans. 

    Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

    • Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

    • Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

    • Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

    • Linear Regression is...

  • Answered by AI
  • Q4. What is the Bias Variance trade-off and name some models with high bias and low variance?
  • Ans. 

    Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

    • Bias-Variance trade-off is a fundamental concept in machine learning.

    • High bias models are simple and have low variance, but are inaccurate.

    • Low bias models are complex and have high variance, but can overfit the data.

    • Examples of high bias models are linear r...

  • Answered by AI
  • Q5. A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
  • Ans. 

    Possible reasons for a car manufacturer's decline in profits by 40% year over year

    • Decreased demand for cars due to economic downturn

    • Increased competition from other car manufacturers

    • Rising production costs and expenses

    • Decline in consumer confidence and spending

    • Changes in government regulations impacting the automotive industry

  • Answered by AI
  • Q6. If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the de...

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for the projects which you have worked upon. Practice case studies on varied businesses from a problem-solving perspective with an analytical approach.

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Mainly about sql, previous job role

Interview Questionnaire 

5 Questions

  • Q1.  I hevn't Got a callback Frm u yet
  • Q2. When will I get the call
  • Q3.  Y r u planing attent to my cv
  • Ans. 

    I am planning to attend to your CV to evaluate your qualifications and experience for the Business Analyst role.

    • To assess your skills and knowledge relevant to the job

    • To understand your work experience and achievements

    • To determine if you are a good fit for the company culture

    • To compare your qualifications with other candidates

    • To make an informed decision on whether to invite you for an interview

  • Answered by AI
  • Q4.  Plz is no XXXXX cllback
  • Q5.  Plz infom me this job
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. QL Question and Schema design

Shopclues Interview FAQs

How many rounds are there in Shopclues Senior Analyst interview?
Shopclues interview process usually has 3 rounds. The most common rounds in the Shopclues interview process are Resume Shortlist, HR and One-on-one Round.

Tell us how to improve this page.

Shopclues Senior Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Flipkart Interview Questions
4.0
 • 1.3k Interviews
Swiggy Interview Questions
3.8
 • 428 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
Myntra Interview Questions
4.0
 • 215 Interviews
Blinkit Interview Questions
3.7
 • 182 Interviews
BlackBuck Interview Questions
3.8
 • 178 Interviews
Spinny Interview Questions
3.7
 • 170 Interviews
FirstCry Interview Questions
3.6
 • 170 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
View all
Shopclues Senior Analyst Salary
based on 44 salaries
₹3 L/yr - ₹5.3 L/yr
48% less than the average Senior Analyst Salary in India
View more details

Shopclues Senior Analyst Reviews and Ratings

based on 12 reviews

4.4/5

Rating in categories

4.2

Skill development

4.6

Work-life balance

4.3

Salary

3.9

Job security

4.3

Company culture

3.9

Promotions

4.2

Work satisfaction

Explore 12 Reviews and Ratings
Software Engineer
50 salaries
unlock blur

₹4.5 L/yr - ₹11 L/yr

Senior Analyst
44 salaries
unlock blur

₹3 L/yr - ₹5.3 L/yr

Analyst
36 salaries
unlock blur

₹2.5 L/yr - ₹4.1 L/yr

Senior Software Engineer
27 salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Category Account Manager
24 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Explore more salaries
Compare Shopclues with

Amazon

4.1
Compare

Flipkart

3.9
Compare

Snapdeal

3.8
Compare

Paytm Mall

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview