Add office photos
Filter interviews by
YCP Consus Interview Questions, Process, and Tips
Updated
20 Sep 2023
1 YCP Consus Interview Experience
7 questions found
Sort by:
Popular
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed before Sep 2022.
4 Interview Rounds
1
Resume Shortlist Round
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
2
HR Round (1 Question)
- Q1. Why are you looking for a job at Consus Add Answer
3
Technical Round (5 Questions)
- Q1. What are the different types of joins View Answers (1)
- Q2. What is an ETL and how do you use it View Answers (1)
- Q3. What will be the query to find a value that doesn't have any relationship with any other table View Answers (1)
- Q4. What do you think can be done to improve on database performane View Answers (1)
- Q5. How many burgers are sold in one day in delhi View Answers (1)
4
HR Round (1 Question)
- Q1. What is the salary expectation Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Work on SQL knowledge
Skills evaluated in this interview
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about YCP Consus?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Nov 2024.
2 Interview Rounds
1
One-on-one Round (7 Questions)
- Q1. Explain your project Add Answer
- Q2. GCP bigquery architecture Add Answer
- Q3. Gcp object versioning Add Answer
- Q4. Gcp storage class types Add Answer
- Q5. Sql optimisation techniques Add Answer
- Q6. Sql coding date format and joins related questions Add Answer
- Q7. Partitioning and cluster by Add Answer
2
One-on-one Round (2 Questions)
- Q1. Advanced sql recursive cte and python code using lambda function to explode the list Add Answer
- Q2. Project explanation and daily activity and challenge faced in project Add Answer
Interview Preparation Tips
Topics to prepare for Tech Mahindra Gcp Data Engineer interview:
- SQL
- PYSPARK
- GCP
- PYTHON
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (7 Questions)
- Q1. Create one Spring boot controller from end to end. No need to create a spring boot project we just want to see the structure and end to end implementation. View Answers (3)
- Q2. Write a java 8 program to get the characters from a string whose count is 2 or more than 2
e.g. input: baseball , output: b, a, l. Add Answer
- Q3. Why you left your previous organization. Add Answer
- Q4. What is the functional interface Add Answer
- Q5. What are the OOPS concepts. and some questions related to inheritance. Add Answer
- Q6. Asked about the project mentioned in CV (Client project) and asked its architecture. Add Answer
- Q7. Various SQL join types Add Answer
2
HR Round (3 Questions)
- Q1. Are you ready to relocate to job location Add Answer
- Q2. Why are you leaving your previous organization. Add Answer
- Q3. Expectation about salary Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Do your basics strong, and keep hands on problems.
Interview experience
Excellent
Difficulty level
Hard
Duration
-
Result
-
3 Interview Rounds
1
One-on-one Round (6 Questions)
- Q1. What are the aml and kyc requirements? View Answers (1)
- Q2. Why should we hire you, briefly describe a scenario where you would showcase a different skill or talent compared with your fellow employees? View Answers (1)
- Q3. Strength and weakness? View Answers (1)
- Q4. Project and achievements? View Answers (1)
- Q5. Are you a team player? What do you do when you don’t get along with certain colleagues? How do you manage conflict resolution? View Answers (1)
- Q6. Provide a situation where you might have failed previously? What has that experience taught you? View Answers (1)
2
Aptitude Test Round
General English grammar knowledge and some calculations
3
HR Round (6 Questions)
- Q1. CTC and expected salary details? Add Answer
- Q2. No you cannot negotiate and end up taking what they give you! Add Answer
- Q3. No relocation time, do it during weekends Add Answer
- Q4. No target compensation or other benefits Add Answer
- Q5. If ur employed through agency or consultancy you will be always a contingent and treated less than permanent employees Add Answer
- Q6. 12 hours a day, 6 days a week, no social or life balance Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - The experience is good overall 120 candidates only 2 of us got selected but the politics is bad
Bhavna Gupta
Interview experience
Excellent
Difficulty level
Moderate
Duration
-
Result
-
I applied via Walk-in and was interviewed in Nov 2024.
4 Interview Rounds
1
HR Round (2 Questions)
- Q1. Walk me through your resume. About insurance process what is policy life cycle. Add Answer
- Q2. Tell me about your previous role. View Answers (1)
2
Aptitude Test Round
Yet to complete the test
3
One-on-one Round (2 Questions)
- Q1. Asked about Gallagher. Add Answer
- Q2. What do you know about Gallagher. View Answers (1)
4
One-on-one Round (2 Questions)
- Q1. Situation based questions were asked. Add Answer
- Q2. How would you built the trust with the stakeholders View Answers (1)
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via campus placement at Delhi College of Engineering (DCE), Delhi and was interviewed in Oct 2024.
3 Interview Rounds
1
Group Discussion Round
Shortlisted students were divided in group of 19
2
Case Study Round
Selected students from gd got the call for case study round
3
One-on-one Round (5 Questions)
- Q1. Questions were based on the case study and guesstimates Add Answer
- Q2. No. of aeroplane flying in the sky right now View Answers (1)
- Q3. How will u utilise 1 acre of land provided to u near ur college View Answers (1)
- Q4. How to start a starbuck franchisein ur town View Answers (1)
- Q5. Sql extraction of the given table and data View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - prepare case study and guesstimates well.
Skills evaluated in this interview
Vinay Gundam
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
I applied via Campus Placement
4 Interview Rounds
1
Coding Test Round
1 good coding question and 33 mcqs
2
Technical Round (2 Questions)
- Q1. Easy questions are asked Add Answer
- Q2. Like create a database of the collages composes of students and professors View Answers (1)
3
Technical Round (2 Questions)
- Q1. Some hr questions Add Answer
- Q2. Project discussions Add Answer
4
HR Round (1 Question)
- Q1. Hr questions about family Add Answer
Bhupendra Sonwane
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I was interviewed in Oct 2024.
3 Interview Rounds
1
Technical Round (2 Questions)
- Q1. SQL problem window function Add Answer
- Q2. SQL code like join and scenerio Add Answer
2
Technical Round (2 Questions)
- Q1. Design round for adf pipeline View Answers (1)
- Q2. Azure synapses and adf adb Add Answer
3
HR Round (2 Questions)
- Q1. Expected ctc and current ctc negotiations View Answers (1)
- Q2. Relocation and remote work until ofc open for Pune location Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be prepared for sql and problem solving
Senior Process Associate Interview Questions
Automatic Data Processing (ADP)
Anonymous
posted on 29 Jul 2024
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (5 Questions)
- Q1. Self intro , what is payroll, tax Add Answer
- Q2. What is excel Ai, chat GPT View Answers (1)
- Q3. Previous experience has to share Add Answer
- Q4. Excel questions Add Answer
- Q5. What do know about current affairs View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Only login and logout on time and nothing else "TOXIC manager ABHISHEK RAI" he is from Kolkata he joined as asst manager he does harassment in office
Dislikes
Abhishek rai from TCS he came to ADP as asst manager he every time asks about YEAR-END YEAR-END he did not give training only to me and assigned one superior he is muslim guy Syed Mudassar he gave training only 4 days and my tasks consists of 10 in that he gave one task training only there is no training room in meeting cabins if any cabin is empty there only on small moniter they will show task once or twice and he will handover live cases and tasks are one but live cases are plenty types I did not commit mistake also Abhishek rai was telling do you have any idea of SECURITY INCIDENT happened yesterday I said what he is telling you missed one case and that case was missed by that senior sitting beside me and he blamed on me if they don't like you they will ask us to voluntarily resign and leave if we don't they corner us and does harrassment untill you resign
And they collect money for birthday celebration in team and colleagues getting married for that 500 every month birthday and marriage gift seperate
Work Details
Work policy: In this company if at all you miss coming to office one day among three day then your ID will turn into red and you have to compensate one extra day in next week
Work days: Monday to Friday (Strict Timings)
Work related travel: This job involves travel within city.
Dislikes
Abhishek rai from TCS he came to ADP as asst manager he every time asks about YEAR-END YEAR-END he did not give training only to me and assigned one superior he is muslim guy Syed Mudassar he gave training only 4 days and my tasks consists of 10 in that he gave one task training only there is no training room in meeting cabins if any cabin is empty there only on small moniter they will show task once or twice and he will handover live cases and tasks are one but live cases are plenty types I did not commit mistake also Abhishek rai was telling do you have any idea of SECURITY INCIDENT happened yesterday I said what he is telling you missed one case and that case was missed by that senior sitting beside me and he blamed on me if they don't like you they will ask us to voluntarily resign and leave if we don't they corner us and does harrassment untill you resign
And they collect money for birthday celebration in team and colleagues getting married for that 500 every month birthday and marriage gift seperate
Work Details
Work policy: In this company if at all you miss coming to office one day among three day then your ID will turn into red and you have to compensate one extra day in next week
Work days: Monday to Friday (Strict Timings)
Work related travel: This job involves travel within city.
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via LinkedIn and was interviewed in Oct 2024.
1 Interview Round
1
Video Call Round (4 Questions)
- Q1. Tell about yourself Add Answer
- Q2. Please summarize your experience with analytical or programming tools (e.g. Excel, Python, R, SQL, etc) (1 min 30 s) View Answers (1)
- Q3. Describe your experience in working in a cusomer support/service or client-facing role (1 min) Add Answer
- Q4. Why should we hire you (1 min) Add Answer
Skills evaluated in this interview
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.
What are the top questions asked in YCP Consus interview?
Tell us how to improve this page.
Interview Questions for Popular Designations
People are getting interviews through
based on 1 YCP Consus interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Interview Questions from Similar Companies
YCP Consus Reviews and Ratings
based on 45 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 |
|
Strategic Sourcing Consultant
10
salaries
| ₹4.2 L/yr - ₹8.4 L/yr |
|
Consultant
9
salaries
| ₹4 L/yr - ₹9 L/yr |
|
Senior Consultant
8
salaries
| ₹7 L/yr - ₹13.3 L/yr |
Explore more salaries
Compare YCP Consus with
Infosys
Compare
Tech Mahindra
Compare
WNS
Compare
IQVIA
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- YCP Consus Interview Questions
Share an Interview