AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Collegedunia
Compare
Filter interviews by
Collegedunia Sr Education Counsellor Interview Questions and Answers for Freshers
Collegedunia Sr Education Counsellor Interview Experiences for Freshers
1 interview found
Anonymous
I applied via Updazz and was interviewed in May 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. Introduction
- Q2. Previous job role
- Q3. Why I left previous job. How will my previous job help me in my current job.
- Q4. Why do you choose counseling as career
- Q5. Demo
Interview Preparation Tips
Interview questions from similar companies
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
I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. How can you reduce the delivery time of the order?
- Ans.
Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.
Analyze the supply chain and identify bottlenecks
Implement automation tools to streamline processes
Improve communication between departments and with customers
Use data analytics to forecast demand and plan accordingly
Consider outsourcing or partnering with third-party logistics providers
Invest in tec...
- Q2. Questions based on Case Studies
Interview Preparation Tips
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Mainly about sql, previous job role
Interview Questionnaire
1 Question
- Q1. How much work experience
- Ans.
The amount of work experience is an important factor in determining the suitability of a candidate for the Business Analyst role.
Work experience helps in developing a deep understanding of business processes and industry trends.
It allows the candidate to gain practical knowledge and skills in data analysis, problem-solving, and project management.
Having relevant work experience demonstrates the ability to work effectiv...
Interview Preparation Tips
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How can you understand the supply of restaurant in a particular area of a city ?
- Ans.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.
Basic RCA question to diagnose falling numbers in a matrix.
Basic left join, right join, sub query, ranking etc.
Interview Preparation Tips
- RCA
- Joins
- Subquery
I applied via LinkedIn and was interviewed in Mar 2022. There were 5 interview rounds.
The test was based on SQL and the questions were similar to medium difficulty level questions in leetcode.
(3 Questions)
- Q1. Describe different types of joins
- Ans.
Different types of joins are used in database queries to combine data from multiple tables.
Inner join: Returns only the matching records from both tables.
Left join: Returns all records from the left table and the matching records from the right table.
Right join: Returns all records from the right table and the matching records from the left table.
Full outer join: Returns all records when there is a match in either the ...
- Q2. 2 tables were given and I was asked to tell the number of rows in output based on different types of joins.
- Q3. Calculated the rows based on joins and told the answer.
(4 Questions)
- Q1. Describe your previous experience
- Ans.
I have 3 years of experience as a Business Analyst in the IT industry.
Worked on gathering and analyzing business requirements
Created functional specifications and user stories
Conducted stakeholder interviews and facilitated meetings
Performed data analysis and created reports
Collaborated with cross-functional teams to implement solutions
Utilized tools like JIRA and Confluence for project management
Improved business proc
- Q2. Shared the details regarding my experience
- Q3. A SQL based puzzle based on window functions where I had to find 4 consecutive empty seats in a theater.
- Q4. Solved using lag function.
The interviewer asked about my previous experience along with a few situation based questions and then gave me a case study to find out possible reasons for a decrease in the cancellations between order dispatch and order delivery.
Interview Preparation Tips
- SQL
- Problem solving
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Oct 2022. There were 4 interview rounds.
SQL Assignment: Decent SQL questions were provided, Answers were provided with detailed approach. Time-in out sql problem, cohorts problem was there
(1 Question)
- Q1. Partition functions,creating dynamic buckets and sql puzzles were the highlights
Case study to understand the problem-solving aptitude was asked. Focus was more on the approach rather than the final outcome
Interview Preparation Tips
I applied via Inkedin and was interviewed in Sep 2023. There were 3 interview rounds.
Sql and python,numpy,pandas
(1 Question)
- Q1. Analyst skills,data handlling
Tell us how to improve this page.
Collegedunia Interviews By Designations
- Collegedunia Content Writer Interview Questions
- Collegedunia Business Development Manager Interview Questions
- Collegedunia Management Trainee Interview Questions
- Collegedunia Education Counsellor Interview Questions
- Collegedunia Data Researcher Interview Questions
- Collegedunia Freelance Content Writer Interview Questions
- Collegedunia Operations Executive Interview Questions
- Collegedunia Operations Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Education Counsellor Interview Questions
- Academic Counsellor Interview Questions
- Counsellor Interview Questions
- Admission Counsellor Interview Questions
- Student Counsellor Interview Questions
- Senior Academic Counsellor Interview Questions
- Senior Counsellor Interview Questions
- Career Counsellor Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Collegedunia Sr Education Counsellor Reviews and Ratings
based on 2 reviews
Rating in categories
|
Business Development Manager
222
salaries
|  ₹4 L/yr - ₹12.1 L/yr |
|
Content Writer
182
salaries
| ₹1 L/yr - ₹6.5 L/yr |
|
Operations Analyst
112
salaries
| ₹2 L/yr - ₹8 L/yr |
|
Business Analyst
98
salaries
| ₹2.2 L/yr - ₹11.5 L/yr |
|
Data Analyst
87
salaries
| ₹2 L/yr - ₹9 L/yr |
Udaan
Swiggy
BlackBuck
Ninjacart
- Home >
- Interviews >
- Collegedunia Interview Questions >
- Collegedunia Sr Education Counsellor Interview Questions for Fresher
