Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Collegedunia Team. If you also belong to the team, you can get access from here

Collegedunia Verified Tick

Compare button icon Compare button icon Compare
2.7

based on 550 Reviews

Filter interviews by

Collegedunia Operations Analyst Interview Questions, Process, and Tips for Experienced

Updated 21 Jan 2022

Collegedunia Operations Analyst Interview Experiences for Experienced

1 interview found

I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. 1- Tell me about of your self
  • Q2. What do you know about collegedunia
  • Q3. Shortcut key for pivot filter
  • Ans. 

    Alt + Down Arrow

    • Press Alt key and Down Arrow key simultaneously

    • Shortcut key is used to open the filter drop-down menu for pivot tables

    • Can be used to quickly filter data in pivot tables

  • Answered by AI
  • Q4. Syntax for copying from one to another table in SQL
  • Ans. 

    Syntax for copying data from one table to another in SQL

    • Use INSERT INTO statement with SELECT subquery

    • Specify the source table and columns in SELECT subquery

    • Specify the destination table and columns in INSERT INTO statement

  • Answered by AI
  • Q5. Difference between Vlookup and Index match
  • Ans. 

    Vlookup searches for a value in the first column of a table and returns a corresponding value in the same row. Index match uses the index function to find a value in a table and match function to return a corresponding value in the same row.

    • Vlookup only works from left to right, while Index match can work in any direction.

    • Index match is more flexible and efficient for large datasets.

    • Index match can handle errors better...

  • Answered by AI
  • Q6. Shortcut key for pivot table
  • Ans. 

    The shortcut key for pivot table is Alt + D + P.

    • Press Alt key and then press D and P keys in sequence to create a pivot table.

    • This shortcut works in Microsoft Excel.

    • Pivot tables are used to summarize and analyze large amounts of data.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - They generally ask from every things that you have mentioned in your CV so please be carefull about what you wrote on it

Skills evaluated in this interview

Interview questions from similar companies

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

I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Group Discussion 

Full in depth process of Flipkart from inbound FC to till sorting centre Outbound , sorting centre indepth process,IPP improvement,kaizens,projects, process knowledge

Round 2 - HR 

(3 Questions)

  • Q1. Process knowledge
  • Q2. Salary discussion
  • Q3. Notice period and is ready to join company

Interview Preparation Tips

Topics to prepare for Swiggy Team Lead Operations interview:
  • Supply Chain Management
Interview preparation tips for other job seekers - Before attending interview kindly go through full process of your working profile
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Facility and team size handled ?
  • Ans. 

    Managed a facility with 200 employees and oversaw operations for a 500,000 square foot warehouse.

    • Managed a team of 200 employees

    • Oversaw operations for a 500,000 square foot warehouse

    • Handled facility operations efficiently

  • Answered by AI
  • Q2. Process improvement ideas implementation
Round 2 - One-on-one 

(1 Question)

  • Q1. Behavioural situation based quaetions

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay confident and provide accurate numbers to show your in depth knowledge
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Assignment 

Assignment related to local language to know our local language skills

Round 2 - HR 

(2 Questions)

  • Q1. How much you know about yout local language
  • Ans. 

    I am fluent in my local language and can communicate effectively in both spoken and written forms.

    • I am a native speaker of my local language

    • I have received formal education in my local language

    • I regularly use my local language in daily conversations and interactions

  • Answered by AI
  • Q2. How much you Can accomodate for your language
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
-

I applied via Recruitment Consulltant and was interviewed before Sep 2021. There were 4 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 - Work  process 

(2 Questions)

  • Q1. 5s must be follow
  • Q2. Always in discipline at operational work
Round 3 - Group Discussion 

All operational floor discussion

Round 4 - Group Discussion 

Floor handling, management, all inventory

Interview Preparation Tips

Interview preparation tips for other job seekers - My interview was very easy, asked only outbound and inbound process and also all operational floor management
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Operations related
  • Q2. Purchases related

Interview Preparation Tips

Interview preparation tips for other job seekers - I can do anything about operation related
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 - One-on-one 

(2 Questions)

  • Q1. Operation related any one
  • Q2. Costumer service support

I applied via Referral and was interviewed in Sep 2022. There were 4 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic introduction and salry package
Round 2 - One-on-one 

(1 Question)

  • Q1. Self introduction Why dunzo About job role understanding Situation based questions to know how we solve issues About clg project and findings
Round 3 - One-on-one 

(1 Question)

  • Q1. Gave a number to do a survey and ask questions and create a small report
Round 4 - One-on-one 

(1 Question)

  • Q1. Same as first one on one and regarding the case study

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well about the job role and how the job works
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 

(2 Questions)

  • Q1. Flexibility with work hours.
  • Q2. Ready to relocate anywhere in the business PAN
Round 3 - One-on-one 

(2 Questions)

  • Q1. Knowledge about supply chain
  • Q2. Specific questions related to inbound inventory and outbound

Interview Preparation Tips

Interview preparation tips for other job seekers - Set confidence about your knowledge in SCM.
Be specific about your answers and negotiate with HR

I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 2 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 - One-on-one 

(3 Questions)

  • Q1. I am going for job ninjakart company
  • Q2. Very good job ninjakart
  • Q3. Nice job ninja kart

Interview Preparation Tips

Interview preparation tips for other job seekers - Opening job date and joining came fast me

Collegedunia Interview FAQs

How many rounds are there in Collegedunia Operations Analyst interview for experienced candidates?
Collegedunia interview process for experienced candidates usually has 3 rounds. The most common rounds in the Collegedunia interview process for experienced candidates are Aptitude Test, HR and Resume Shortlist.
How to prepare for Collegedunia Operations 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 Collegedunia. The most common topics and skills that interviewers at Collegedunia expect are Analytics, Data Analytics, Presentation Skills, Python and SQL.
What are the top questions asked in Collegedunia Operations Analyst interview for experienced candidates?

Some of the top questions asked at the Collegedunia Operations Analyst interview for experienced candidates -

  1. Syntax for copying from one to another table in SQ...read more
  2. Difference between Vlookup and Index ma...read more
  3. Shortcut key for pivot fil...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Collegedunia interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

BYJU'S Interview Questions
3.1
 • 2.2k Interviews
Swiggy Interview Questions
3.8
 • 415 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 317 Interviews
upGrad Interview Questions
3.8
 • 201 Interviews
Unacademy Interview Questions
3.0
 • 198 Interviews
Zepto Interview Questions
3.6
 • 178 Interviews
BlackBuck Interview Questions
3.8
 • 171 Interviews
Blinkit Interview Questions
3.8
 • 168 Interviews
Tata 1mg Interview Questions
3.7
 • 139 Interviews
View all
Collegedunia Operations Analyst Salary
based on 106 salaries
₹2 L/yr - ₹7 L/yr
25% less than the average Operations Analyst Salary in India
View more details

Collegedunia Operations Analyst Reviews and Ratings

based on 12 reviews

3.6/5

Rating in categories

3.1

Skill development

3.5

Work-Life balance

3.7

Salary & Benefits

2.9

Job Security

3.2

Company culture

3.5

Promotions/Appraisal

3.1

Work Satisfaction

Explore 12 Reviews and Ratings
Business Development Manager
236 salaries
unlock blur

₹3 L/yr - ₹12.2 L/yr

Content Writer
181 salaries
unlock blur

₹1 L/yr - ₹8 L/yr

Operations Analyst
106 salaries
unlock blur

₹2 L/yr - ₹7 L/yr

Business Analyst
88 salaries
unlock blur

₹3.3 L/yr - ₹12 L/yr

Education Counsellor
87 salaries
unlock blur

₹1 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Collegedunia with

Shiksha

3.2
Compare

Careers360

3.3
Compare

MeritNation

3.6
Compare

Toppr

3.4
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