Upload Button Icon Add office photos

Filter interviews by

YCP Consus Interview Questions, Process, and Tips

Updated 20 Sep 2023

YCP Consus 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

Consultant Interview Questions asked at other Companies

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How important is for you to celebrate Christmas?
  • Ans. Basically here they wanted to know if you would be flexible enough to work on Christmas day. The reason because December happens to be a crucial month for year end and the workload is overwhelming. So the crux of the question is you only get one day leave for Christmas I.e Christmas day else you are asked to work. It may happen that your leaves are not approved at all the rest of the days depending on the situation. Ha
  • Answered Anonymously
  • Q2. How often have you been given negative feedback?

Interview Preparation Tips

Interview preparation tips for other job seekers - They want to know how flexible you are and will you be available for business as and when required. That includes stretched hours, overtime.

Interview Questionnaire 

4 Questions

  • Q1. What is Google sheets
  • Ans. 

    Google Sheets is a cloud-based spreadsheet program offered by Google as part of the Google Drive office suite.

    • Allows users to create and edit spreadsheets online

    • Offers collaboration features for real-time editing and commenting

    • Can import and export various file formats, including Microsoft Excel

    • Offers add-ons and scripts for automation and customization

    • Accessible from any device with internet connection

  • Answered by AI
  • Q2. What is the MDD & OMC of soil
  • Ans. 

    MDD & OMC are important parameters for soil compaction and moisture content.

    • MDD stands for Maximum Dry Density, which is the maximum density that can be achieved for a given soil compaction effort.

    • OMC stands for Optimum Moisture Content, which is the moisture content at which the maximum dry density can be achieved.

    • These parameters are important for determining the appropriate moisture content and compaction effort for...

  • Answered by AI
  • Q3. What is the velocity of steel
  • Ans. 

    The velocity of steel varies depending on the type and conditions.

    • The velocity of steel can range from 5000 to 6000 meters per second

    • The velocity of steel can be affected by factors such as temperature and pressure

    • The velocity of steel is important in industries such as construction and manufacturing

  • Answered by AI
  • Q4. What is the cube test result in 7 days
  • Ans. 

    The cube test result in 7 days depends on the purpose of the test and the specific cube being tested.

    • The cube test can refer to various tests in different fields such as construction, engineering, and materials science.

    • For example, in construction, the cube test is used to determine the compressive strength of concrete cubes after 7 days of curing.

    • The result of the cube test can vary depending on factors such as the ty...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It was just a aptitude test

Round 2 - Technical 

(2 Questions)

  • Q1. Basic regarding professional area
  • Q2. Project worked at and experienced
  • Ans. 

    Managed a team to implement a new customer relationship management system

    • Led a team of 5 employees to successfully implement a new CRM system

    • Coordinated with IT department to ensure smooth integration of the system

    • Provided training to staff on how to use the new system effectively

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Why i want to join the firm
  • Ans. 

    I want to join the firm because of its strong reputation, opportunities for growth, and alignment with my career goals.

    • Strong reputation in the industry

    • Opportunities for career growth and development

    • Alignment with my career goals and values

  • Answered by AI
  • Q2. Salary discussions

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Equipment layout details
  • Q2. Plot plan details and man and material movement path

Interview Preparation Tips

Interview preparation tips for other job seekers - Good knowledge on piping system, thickness calculations and materials are required

Equipment layout preparation as per oisd 118 and plot plan knowledge required.

I applied via Referral and was interviewed before Oct 2020. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. What is Non-PO?
  • Ans. 

    Non-PO refers to purchases made without a purchase order.

    • Non-PO purchases are made without a formal purchase order.

    • These purchases are typically made for urgent or small items.

    • Non-PO purchases may require additional approval or documentation.

    • Examples of Non-PO purchases include office supplies, travel expenses, and minor repairs.

  • Answered by AI
  • Q2. What does FB03 stand for in SAP?
  • Ans. 

    FB03 is a transaction code in SAP used to display financial accounting documents.

    • FB03 is used to view accounting documents such as invoices, credit memos, and payment receipts.

    • It allows users to search for documents based on various criteria such as document number, posting date, and company code.

    • FB03 also provides options to display document details, line items, and accounting entries.

    • It is commonly used by finance an...

  • Answered by AI
  • Q3. What are the types of Fixed Assets?
  • Ans. 

    Fixed assets can be categorized into tangible and intangible assets.

    • Tangible assets include property, plant, and equipment (PPE), such as buildings, machinery, and vehicles.

    • Intangible assets include patents, copyrights, trademarks, and goodwill.

    • Fixed assets are long-term assets that are not intended for sale and are used in the production of goods or services.

    • Fixed assets are recorded on the balance sheet and are subje...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the basics of accounting before going for an interview also refer to other ERPs for which the position is?

Skills evaluated in this interview

Senior Associate Interview Questions & Answers

WNS user image Abinasha Choudhury

posted on 21 Apr 2020

I applied via Walk-in and was interviewed in Oct 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Only questions related to their profile.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go interview with full preparation

Associate Interview Questions & Answers

WNS user image Anonymous

posted on 16 Feb 2022

I applied via Walk-in and was interviewed in Aug 2021. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. What are your salary expectations?
  • Q2. Tell me about yourself.
Round 2 - Aptitude Test 

The questions where about matrix

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a good experience. And I ahd a good experience in wns global services and learnt about insurance

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself.
  • Q2. Do you believe in Team Work or Individual work.
  • Q3. Tell me about previous experience & unforgettable movement in previous company .

Interview Preparation Tips

Interview preparation tips for other job seekers - Be positive about your previous companies experience.

I applied via Recruitment Consulltant and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - HR 

(4 Questions)

  • Q1. What are your salary expectations?
  • Q2. Why should we hire you?
  • Q3. What are your strengths and weaknesses?
  • Q4. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and be you .
Interview is not that difficult if you're confident...

YCP Consus Interview FAQs

How many rounds are there in YCP Consus 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.
How to prepare for YCP Consus 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 YCP Consus. The most common topics and skills that interviewers at YCP Consus expect are C++, Digital Asset Management, ESIC, Java and Linux Administration.
What are the top questions asked in YCP Consus interview?

Some of the top questions asked at the YCP Consus 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 Interview Process

based on 5 interviews

Interview experience

4.2
  
Good
View more

Interview Questions from Similar Companies

Infosys Interview Questions
3.6
 • 7.7k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
WNS Interview Questions
3.4
 • 1.1k Interviews
IQVIA Interview Questions
3.9
 • 472 Interviews
Atos Interview Questions
3.8
 • 381 Interviews
Goldman Sachs Interview Questions
3.5
 • 380 Interviews
TCE Interview Questions
3.8
 • 251 Interviews
View all

YCP Consus Reviews and Ratings

based on 48 reviews

3.0/5

Rating in categories

3.1

Skill development

3.5

Work-life balance

3.1

Salary

2.6

Job security

2.8

Company culture

2.7

Promotions

3.0

Work satisfaction

Explore 48 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