AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
YCP Consus Consultant Interview Questions, Process, and Tips
YCP Consus Consultant Interview Experiences
1 interview found
Anonymous
Selected
I applied via Naukri.com and was interviewed before Sep 2022. There were 4 interview rounds.
(1 Question)
- Q1. Why are you looking for a job at Consus
(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
- 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...
- 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
- 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
- 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...
(1 Question)
- Q1. What is the salary expectation
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
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
Vandana Lekhi
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
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
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
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
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
- 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...
- 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
Interview Preparation Tips
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
- 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...
- 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
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...
- 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
- 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
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.
- 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...
- Q6. Then I was asked what is there in your CV which I won’t find in others?
Interview Preparation Tips
Experience: I was grilled about the Company
Skills: Group discussion, case analysis
College Name: NA
YCP Consus Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Associate Consultant Interview Questions
- Senior Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- SAP Abap Consultant Interview Questions
- AST Consultant Interview Questions
- SAP Fico Consultant Interview Questions
- Show more
YCP Consus Consultant Interview Process
based on 1 interview
Interview experience
Consultant Interview Questions from Similar Companies
YCP Consus Consultant Reviews and Ratings
based on 4 reviews
Rating in categories
|
Associate Consultant
15
salaries
|  ₹2.4 L/yr - ₹5.5 L/yr |
|
Sourcing Consultant
11
salaries
| ₹4 L/yr - ₹8.1 L/yr |
|
Consultant
9
salaries
| ₹4 L/yr - ₹9 L/yr |
|
Senior Consultant
8
salaries
| ₹7 L/yr - ₹13.3 L/yr |
|
Information Technology Recruiter
7
salaries
| ₹2 L/yr - ₹3.5 L/yr |
Wipro
Cognizant
Infosys
Tech Mahindra
- Home >
- Interviews >
- YCP Consus Interview Questions >
- YCP Consus Consultant Interview Questions
