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

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

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

I appeared for an interview 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

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare excel

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

Operations Analyst Interview Questions Asked at Other Companies

asked in Accenture
Q1. What is the entry of interest received in advance?
asked in HCLTech
Q2. Diffence between P&L statement and PP reports, what comes in ... read more
asked in Accenture
Q3. What do mean by reconciliation and types?
Q4. Tell me something about different types of Regulations ?
Q5. Give a brief description about how DSM is calculated

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Telephonic round regarding salary discussions and further documentations.

Interview Preparation Tips

Round: Test
Experience: Aptitude Test

Simple mathematical problems and few reasoning related questions. Total 15 questions will be there and no negative markings.

Round: Test
Experience: Manager Round

They will ask tell me about yourself, why do you leaving the previous company, regarding stability etc.

They will also ask regarding cataloging and other catalog related questions like what the mandatory things to upload catalogs of Shirt, or bedsheets etc.

I applied via Approached by Company and was interviewed before Jun 2021. There were 2 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 

Knowledge of excel and team handling

Interview Preparation Tips

Topics to prepare for Udaan Operations Executive interview:
  • MS Office
  • Quality Control
Interview preparation tips for other job seekers - first introduced myself and then tell him about my qualifications and work experience.

I applied via Walk-in and was interviewed in May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself? How many years of experience do you have? Or rather You're a fresher. What was your job profile. If you're given a certain task how would be able to handle it. Do you know advanced ...

Interview Preparation Tips

Interview preparation tips for other job seekers - Simple just don't hesitate to answer even if certain things that you don't know say it no without getting nervous just maintain your body language . That's it.

I applied via Approached by Company and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Self Introduction about family members

Interview Preparation Tips

Interview preparation tips for other job seekers - Working Hard n Getting Success ?% Worth in Work With Smartly working

I applied via Walk-in and was interviewed in Aug 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Experience
  • Q2. Expected salary

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep Good knowledge in Logistics and Operations Field

I applied via Naukri.com and was interviewed before Nov 2021. There were 2 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. What's your name and
  • Q2. Tell me your self and what do you want in future

Interview Preparation Tips

Interview preparation tips for other job seekers - Take responsibility and honest your work do any work with confidence

I applied via Job Fair

Round 1 - HR 

(1 Question)

  • Q1. Operation executive job is best job
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself.
  • Q2. Operation executive job is best

Interview Preparation Tips

Interview preparation tips for other job seekers - Operation executive job is best job.in a logistic.
Round 1 - One-on-one 

(1 Question)

  • Q1. What are your qualifications?

Interview Preparation Tips

Interview preparation tips for other job seekers - Please dont apply job in this company.They will kick you out any time. Read the reviews before joining

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 Aptitude Test, HR and Resume Shortlist.
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 Operations Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 431 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 329 Interviews
Zepto Interview Questions
3.5
 • 226 Interviews
BlackBuck Interview Questions
3.8
 • 179 Interviews
Tata 1mg Interview Questions
3.6
 • 147 Interviews
Digit Insurance Interview Questions
3.9
 • 143 Interviews
Paisabazaar.com Interview Questions
3.4
 • 139 Interviews
Urban Company Interview Questions
3.4
 • 135 Interviews
Ninjacart Interview Questions
3.9
 • 96 Interviews
View all
Collegedunia Operations Analyst Salary
based on 114 salaries
₹2 L/yr - ₹7 L/yr
24% 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.0

Skill development

3.5

Work-life balance

3.7

Salary

2.9

Job security

3.2

Company culture

3.5

Promotions

3.1

Work satisfaction

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

₹3 L/yr - ₹12.8 L/yr

Content Writer
180 salaries
unlock blur

₹1 L/yr - ₹6.5 L/yr

Operations Analyst
114 salaries
unlock blur

₹2 L/yr - ₹7 L/yr

Business Analyst
96 salaries
unlock blur

₹2.2 L/yr - ₹11.5 L/yr

Data Analyst
87 salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Explore more salaries
Compare Collegedunia with

Udaan

3.9
Compare

Swiggy

3.8
Compare

BlackBuck

3.8
Compare

Ninjacart

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