Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
+ Contribute
notification
notification
Login
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.9

based on 536 Reviews

Filter interviews by

Collegedunia Operations Analyst Interview Questions, Process, and Tips

Updated 21 Apr 2023

Top Collegedunia Operations Analyst Interview Questions and Answers

Collegedunia Operations Analyst Interview Experiences

2 interviews found

Operations Analyst Interview Questions & Answers

user image Anonymous

posted on 21 Jan 2022

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
    • Add your answer
  • Q2. What do you know about collegedunia
    • Add your answer
  • 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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer

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

Operations Analyst Interview Questions & Answers

user image ANKIT KUMAR Jha

posted on 21 Apr 2023

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

I was interviewed in Mar 2023.

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 - Aptitude Test 

Q- conditional formatting
Q- alter query of sql
Q- html tags
Q-vlookup question
Q-which is good vlookup or indexmatch
Q- countif function
Q- create view in sql
Q- problem solving question

Round 3 - HR 

(1 Question)

  • Q1. Salary discussion
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare excel

Top trending discussions

View All
Interview Tips & Stories
2w
amanchoudhari
Verified Icon
·
student at
Pune Institute of Computer Technology, Pune
SAP Labs Interview Experience | On-Campus | SAP Basis Consultant
I participated in SAP Labs' 2025 placement drive at Pune Institute of Computer Technology (PICT) for the SAP Basis Consultant role. The process included three rounds: an aptitude + CS fundamentals test, a group discussion (GD), and a technical + HR interview. In the GD, I confidently initiated the discussion on "Being Famous vs Being Knowledgeable," supporting my points with examples. During the interview, I discussed my resume, internship experience with Node.js, PostgreSQL, and Prisma ORM, and machine learning models like Random Forest Regression. I also explained my problem-solving approach and adaptability to new technologies. I was one of the five students selected, and it was a great learning experience. My advice to future aspirants: Be thorough with your resume, practice aptitude and CS fundamentals, and work on communication skills. #Experiences #interviewexperiences #Experiences-QnA
Got a question about Collegedunia?
Ask anonymously on communities.

Interview questions from similar companies

Operations Manager Interview Questions & Answers

Zepto user image Anonymous

posted on 8 Dec 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Ask about supply chain and operations
    • Add your answer
  • Q2. Coding , big query and sql
    • Add your answer
Round 2 - Assignment 

Demand planning and capacity pla

Team Lead Operations Interview Questions & Answers

Swiggy user image Anonymous

posted on 15 Nov 2024

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
    • Add your answer
  • Q2. Salary discussion
    • Add your answer
  • Q3. Notice period and is ready to join company
    • Add your answer

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

Head Operations Interview Questions & Answers

Blinkit user image Anonymous

posted on 30 Jul 2024

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
    Add your answer
  • Q2. Process improvement ideas implementation
    • Add your answer
Round 2 - One-on-one 

(1 Question)

  • Q1. Behavioural situation based quaetions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay confident and provide accurate numbers to show your in depth knowledge

Operations Associate Interview Questions & Answers

ShareChat user image Anonymous

posted on 11 Sep 2024

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
    Add your answer
  • Q2. How much you Can accomodate for your language
    • Add your answer

Senior Operations Manager Interview Questions & Answers

Stanza Living user image Anonymous

posted on 17 Dec 2024

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

I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Assignment 

General aptitude and work experience.

Senior Associate Operations Interview Questions & Answers

BlackBuck user image Anonymous

posted on 19 Jan 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Intime truck placement

Round 2 - Technical 

(5 Questions)

  • Q1. Customer payment details
    • Add your answer
  • Q2. Fleet owners data
    • Add your answer
  • Q3. Local Supply partners
    • Add your answer
  • Q4. Local drivers and brokers
    • Add your answer
  • Q5. PS audition truck accident issues
    • Add your answer

Team Lead Operations Interview Questions & Answers

Udaan user image Anonymous

posted on 28 Sep 2022

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
    • Add your answer
  • Q2. Always in discipline at operational work
    • Add your answer
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

Operations Manager Interview Questions & Answers

Dunzo user image Anonymous

posted on 10 Aug 2024

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

Test Was hard as per industry standards

Round 2 - Coding Test 

Questions were asked from DSA

More about working at Collegedunia

Collegedunia Interview FAQs

How many rounds are there in Collegedunia Operations Analyst interview?
Collegedunia interview process usually has 3 rounds. The most common rounds in the Collegedunia interview process are Resume Shortlist, Aptitude Test and HR.
How to prepare for Collegedunia Operations Analyst interview?
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, Python, SQL and Business Intelligence.
What are the top questions asked in Collegedunia Operations Analyst interview?

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

  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.

Collegedunia Interviews By Designations

Interview Questions for Popular Designations

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

Fast track your campus placements

Delhi College of Engineering (DCE), Delhi Placement Questions
1 Interview
National Institute of Technology (NIT), Warangal Placement Questions
1 Interview
Birla Institute of Management Technology (BIMT) Placement Questions
1 Interview
Nehru Institute of Engineering and Technology, Coimbatore Placement Questions
1 Interview
Sri Venkateswara College of Engineering and Technology, Chittoor Placement Questions
1 Interview
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
Collegedunia Salaries in India
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