Upload Button Icon Add office photos

Filter interviews by

YCP Consus Consultant Interview Questions, Process, and Tips

Updated 20 Sep 2023

YCP Consus Consultant Interview Experiences

1 interview found

Consultant Interview Questions & Answers

user image Anonymous

posted on 20 Sep 2023

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

I applied via Naukri.com and was interviewed before Sep 2022. 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 - HR 

(1 Question)

  • Q1. Why are you looking for a job at Consus
Round 3 - Technical 

(5 Questions)

  • Q1. What are the different types of joins
  • Ans. 

    Different types of joins include inner join, outer join, left join, and right join.

    • Inner join: Returns rows when there is a match in both tables

    • Outer join: Returns all rows when there is a match in one of the tables

    • Left join: Returns all rows from the left table and the matched rows from the right table

    • Right join: Returns all rows from the right table and the matched rows from the left table

  • Answered by AI
  • Q2. What is an ETL and how do you use it
  • Ans. 

    ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database or data warehouse.

    • Extract: Data is extracted from different sources such as databases, files, APIs, etc.

    • Transform: Data is cleaned, standardized, and transformed into a format suitable for analysis.

    • Load: The transformed data is loaded into a target...

  • Answered by AI
  • Q3. What will be the query to find a value that doesn't have any relationship with any other table
  • Ans. 

    Use a LEFT JOIN to find values without relationships in other tables.

    • Use a LEFT JOIN to join the table with other tables

    • Filter the results where the relationship is NULL

  • Answered by AI
  • Q4. What do you think can be done to improve on database performane
  • Ans. 

    Improving database performance can be achieved through optimization of queries, indexing, hardware upgrades, and regular maintenance.

    • Optimize database queries by avoiding unnecessary joins and using appropriate indexes

    • Regularly monitor and tune the database for optimal performance

    • Consider hardware upgrades such as increasing memory or storage capacity

    • Implement caching mechanisms to reduce the load on the database serve

  • Answered by AI
  • Q5. How many burgers are sold in one day in delhi
  • Ans. 

    It is difficult to provide an exact number as it varies depending on the specific location and day of the week.

    • Burger sales can vary greatly depending on the popularity of the restaurant, day of the week, and time of year.

    • Fast food chains like McDonald's or Burger King may sell thousands of burgers in a day.

    • Local burger joints may sell a few hundred to a thousand burgers in a day.

    • Special events or promotions can also i...

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. What is the salary expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - Work on SQL knowledge

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL, BI Reporting related questions asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Good..

Consultant Interview Questions & Answers

Infosys user image Vandana Lekhi

posted on 29 Nov 2020

I applied via Recruitment Consultant

Interview Questionnaire 

3 Questions

  • Q1. Are you prepared for full- time work or freelance ? Can you travel ? How much salary is your expectation ?
  • Q2. I can only commit myself for freelance work with flexible hours . Cannot travel . Reasonable salary is welcome .
  • Q3. What will be the mode of payment for my freelance work ?

Interview Preparation Tips

Interview preparation tips for other job seekers - In any interview honesty is essential while the employer conducts it . One's limitations should be disclosed along with expectations . For example my service to street dogs , cats , birds and squirrels in the colony does not permit me to engage in full-time work . Getting a good work place is more important than aiming for a high salary .

I applied via Referral and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basics of Middleware
  • Q2. Everything you are doing as a routine and your tasks tell them and with confidence

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and never loose hope

I applied via Company Website and was interviewed in Sep 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Specific to SAP HANA Architecture and troubleshooting

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics should be clear and should have broader view with respect to scenario base questions.

I appeared for an interview in Jun 2016.

Interview Questionnaire 

2 Questions

  • Q1. General questions related to Windows administration
  • Q2. Questions about lack of past with experience.

Interview Preparation Tips

Round: Technical Interview
Experience: Some questions regarding active directory and file sharing
Tips: Keep it real and answer what you know. Donot argue unless interviewer demands discussion.

Round: HR Interview
Experience: Some questions regarding active directory and file sharing
Tips: Keep it real and answer what you know. Donot argue unless interviewer demands discussion.

Round: HR Interview
Experience: I didn't have work experience of a company.
Tips: Will if you have reached hr stage and don't have certain document tell the truth. And explain why you don't have it. If you can arrange the doc, great. If you can't clearly state the same. And tell about the references you can share.

Skills: Technical Analysis

Interview Questionnaire 

6 Questions

  • Q1. I was asked why Consulting,
  • Q2. About the Company,
  • Q3. What is the Current Exchange rate
  • Ans. 

    The current exchange rate varies depending on the currency pair and market conditions.

    • Exchange rates are constantly fluctuating based on supply and demand

    • Factors such as political events, economic data, and central bank decisions can impact exchange rates

    • For example, as of August 2021, the exchange rate for USD to EUR is approximately 0.85

  • Answered by AI
  • Q4. Taking cue from an earlier answer I was asked basics of Corporate Hedging
  • Q5. What is your view on the indian rupee vs dollar in the long run
  • Ans. 

    The Indian rupee is expected to depreciate against the dollar in the long run.

    • The Indian economy is heavily dependent on imports, which puts pressure on the rupee.

    • The US economy is expected to grow faster than India's, which will strengthen the dollar.

    • Political and economic instability in India can also weaken the rupee.

    • However, global events such as trade wars and geopolitical tensions can also impact the exchange rat...

  • Answered by AI
  • Q6. A problem was given and I had to give the solution- the problem was “A company has corporate cellphone connection for its employees. How would you ensure that you achieve the same at the least cost?”
  • Ans. 

    Negotiate with service providers for bulk discounts and limit data usage to essential business needs.

    • Negotiate with service providers for bulk discounts

    • Limit data usage to essential business needs

    • Consider implementing a BYOD (Bring Your Own Device) policy

    • Use mobile device management software to monitor and control usage

    • Encourage employees to use Wi-Fi instead of cellular data when possible

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: I was able to explain Why Consulting and also showed a keen interest in Government Consulting which Wipro was heavily into.

General Tips: A non-fish-market GD goes a long way in helping your chances
Skills: case analysis, group discussion
College Name: NA

Interview Questionnaire 

10 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am an experienced consultant with a strong background in problem-solving and client management.

    • Experienced consultant

    • Strong problem-solving skills

    • Client management expertise

  • Answered by AI
  • Q2. Why Consulting as a career
  • Ans. 

    Consulting offers diverse challenges, continuous learning, and the opportunity to make a significant impact.

    • Consulting provides exposure to various industries and business problems.

    • It offers the chance to work with talented professionals and learn from their expertise.

    • Consultants have the opportunity to make a tangible difference by solving complex issues and driving positive change.

    • The work is dynamic and ever-evolvin...

  • Answered by AI
  • Q3. I had Strategy & Finance as specialization, justify your specializations
  • Q4. I had 2 independent consulting assignments on CV, very detailed discussion of that
  • Q5. What profiles are you looking for, I said BFSI sector, they said very few profiles on offer in BFSI, said we can give you Software Product Sectors
  • Q6. Cases on market entry strategy
  • Q7. What is Freescale’s (my previous employer) condition right now, I told them a lot about freescale and the global chip manufacturing segment, specific growth, industry concentration everything
  • Q8. Asked whether I would be able to do such analysis in other sectors also if given opportunity. I had worked for e-commerce sector in projects gave specific numbers for that, he was very pleased with the ind...
  • Q9. Asked me about how to enter new markets and new product lines
  • Q10. Asked about how would a person decide whether to invest in particular market or not

Interview Preparation Tips

Round: Case Study Interview
Experience: Industry analysis for 2 sectors in fair depth and numerical figures intact ( Global Semiconductor Industry & Indian E-commerce Industry)

Better to read the JDs and remember profiles they are offering
Tips: They asked about CGPA and marks in 10th and 12th.

Skills: case analysis, Economics
College Name: NA

Interview Questionnaire 

8 Questions

  • Q1. Why consulting?
  • Ans. 

    Consulting offers diverse challenges, continuous learning, and the opportunity to make a significant impact.

    • Consulting provides exposure to various industries and business problems.

    • It offers the chance to work with talented professionals and learn from their expertise.

    • Consultants have the opportunity to solve complex problems and make a tangible difference.

    • The work is dynamic and ever-changing, ensuring continuous lear...

  • Answered by AI
  • Q2. How can you add value to our organisation
  • Q3. Specifically why Wipro out of all the consulting firms. They were very keen on why wipro thing
  • Q4. What do you know about the Wipro group as a whole?
  • Ans. 

    Wipro is an Indian multinational corporation that provides information technology, consulting and business process services.

    • Founded in 1945 by M.H. Hasham Premji

    • Headquartered in Bangalore, India

    • Employs over 190,000 people worldwide

    • Provides services in various industries including healthcare, finance, retail, and more

    • Has a strong focus on sustainability and social responsibility

    • Acquired Appirio, a cloud services company

  • Answered by AI
  • Q5. Lengthy discussion on Work experience
  • Q6. Lengthy discussion on Summer internship project
  • Q7. The whole interview was based on operations and supply chain concepts
  • Q8. What theoretical concepts did you used to execute your project?

Interview Preparation Tips

Round: HR Interview
Experience: Convinced them very well that the role they are offering is very much in line with my previous work ex and summer internship.

General Tips: Try to hard sell yourself as much as you can. Try to steer the interview yourself and you need to talk a lot. They wanted numbers as in revenues, competitors and recent events about the company.
Skills: case analysis, Economics
College Name: NA

Interview Questionnaire 

6 Questions

  • Q1. I was asked basic questions like Tell me about yourself
  • Q2. Why consulting,
  • Q3. What do I know about Wipro Consulting
  • Ans. 

    Wipro Consulting is a global management consulting firm.

    • Offers services in strategy, operations, technology, and transformation.

    • Has a presence in over 50 countries.

    • Works with clients across various industries such as healthcare, financial services, and retail.

    • Part of Wipro Limited, a leading global information technology, consulting, and business process services company.

  • Answered by AI
  • Q4. What are the different processes
  • Q5. What is the strategy of Wipro Business Consulting
  • Ans. 

    Wipro Business Consulting's strategy is to provide end-to-end consulting services to clients across various industries.

    • Offering a range of consulting services including strategy, operations, technology, and organization

    • Focusing on digital transformation and innovation

    • Collaborating with clients to develop customized solutions

    • Leveraging Wipro's global presence and expertise

    • Examples of clients include a leading US healthc...

  • Answered by AI
  • Q6. Then I was asked what is there in your CV which I won’t find in others?

Interview Preparation Tips

Round: HR Interview
Experience: I was grilled about the Company

Skills: Group discussion, case analysis
College Name: NA

YCP Consus Interview FAQs

How many rounds are there in YCP Consus Consultant interview?
YCP Consus interview process usually has 4 rounds. The most common rounds in the YCP Consus interview process are HR, Resume Shortlist and Technical.
What are the top questions asked in YCP Consus Consultant interview?

Some of the top questions asked at the YCP Consus Consultant interview -

  1. What will be the query to find a value that doesn't have any relationship with ...read more
  2. What do you think can be done to improve on database perform...read more
  3. How many burgers are sold in one day in de...read more

Tell us how to improve this page.

YCP Consus Consultant Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Consultant Interview Questions from Similar Companies

BCG Consultant Interview Questions
3.7
 • 69 Interviews
Atos Consultant Interview Questions
3.8
 • 26 Interviews
TCE Consultant Interview Questions
3.8
 • 15 Interviews
View all
YCP Consus Consultant Salary
based on 9 salaries
₹4 L/yr - ₹9 L/yr
49% less than the average Consultant Salary in India
View more details

YCP Consus Consultant Reviews and Ratings

based on 4 reviews

1.9/5

Rating in categories

2.1

Skill development

4.0

Work-life balance

2.2

Salary

1.6

Job security

1.9

Company culture

1.4

Promotions

1.9

Work satisfaction

Explore 4 Reviews and Ratings
Associate Consultant
15 salaries
unlock blur

₹2.4 L/yr - ₹5.5 L/yr

Sourcing Consultant
11 salaries
unlock blur

₹4 L/yr - ₹8.1 L/yr

Consultant
9 salaries
unlock blur

₹4 L/yr - ₹9 L/yr

Senior Consultant
8 salaries
unlock blur

₹7 L/yr - ₹13.3 L/yr

Information Technology Recruiter
7 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Explore more salaries
Compare YCP Consus with

Wipro

3.7
Compare

Cognizant

3.7
Compare

Infosys

3.6
Compare

Tech Mahindra

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