Upload Button Icon Add office photos

Filter interviews by

Carelon Global Solutions Senior Consultant Interview Questions and Answers

Updated 17 Sep 2021

Carelon Global Solutions Senior Consultant Interview Experiences

1 interview found

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

Interview Questionnaire 

2 Questions

  • Q1. Analytical function in sql
  • Ans. 

    Analytical functions in SQL are used to perform calculations on a set of rows and return a single result for each row.

    • Analytical functions are used to calculate running totals, moving averages, and rank functions.

    • They are used with the OVER() clause to define the window of rows to be used in the calculation.

    • Examples of analytical functions include ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD(), SUM(), AVG(), MAX(),

  • Answered by AI
  • Q2. Scenario based informatica questions

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was simple, they asked for some specific syntax, overall not so tough

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
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 - Coding Test 

Pure coding on DS Algo in your preferred language

Round 3 - Coding Test 

Coding round in your preferred language.

Round 4 - Technical 

(1 Question)

  • Q1. LLD HLD system Design
Round 5 - Technical 

(1 Question)

  • Q1. Design questions like you tube twitter etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through Leet code and educative content. Ome you tube c o n t e n t.
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. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - It's ok
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Core Java basics
  • Q2. Goat and Canible puzzle
  • Q3. Basic coding problem of multi threading

Interview Preparation Tips

Interview preparation tips for other job seekers - Hand on Microservices Sprint Boot
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 - Aptitude Test 

Normal Test with some questions

Round 3 - Technical 

(2 Questions)

  • Q1. Technical questions on current role
  • Q2. Roles and responsibilities on current role

Interview Preparation Tips

Interview preparation tips for other job seekers - It will be a cool interview. Rest easy and prepare qell
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jan 2023. 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 - Technical 

(3 Questions)

  • Q1. Casting related basic questions
  • Q2. Exhaust system related deep questions
  • Q3. GD & T basic questions
Round 3 - Technical 

(2 Questions)

  • Q1. Sheet metal /casting design considerations
  • Ans. 

    Considerations for sheet metal and casting design

    • Thickness of the material affects strength and cost

    • Design for manufacturability to minimize waste and cost

    • Consider material properties like ductility and heat resistance

    • Include features for easy assembly and maintenance

    • Account for shrinkage in casting design

  • Answered by AI
  • Q2. Practically showing the cast part and ask to decide parting line, design methodology and details.
Round 4 - Assignment 

3D modelling cad test - one part was given and I had to make parametric part in Creo.

Interview Preparation Tips

Interview preparation tips for other job seekers - 3D modelling is critical.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Easy and simple interview

Round 2 - HR 

(2 Questions)

  • Q1. Experience related questions
  • Q2. Why this company
  • Ans. 

    I chose this company for its innovative approach to team leadership and commitment to employee growth.

    • Strong focus on employee development and growth opportunities

    • Innovative approach to team leadership and collaboration

    • Positive company culture and values alignment

    • Impressive track record of success and growth

    • Exciting projects and opportunities for professional advancement

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Oct 2022. There were 5 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 - Aptitude Test 

Written question answer, objective questions

Round 3 - Technical 

(3 Questions)

  • Q1. Technical round based on your experience
  • Q2. Relayed to desktop support
  • Ans. 

    Desktop support involves providing technical assistance to users for hardware and software issues.

    • Troubleshoot hardware and software issues

    • Install and configure computer systems

    • Provide technical support to end users

    • Maintain and update documentation

    • Train users on new technologies

  • Answered by AI
  • Q3. Relayed to active directory
  • Ans. 

    Active Directory is a directory service that stores information about objects on a network.

    • Active Directory is used to manage users, computers, and other resources on a network

    • It allows for centralized management of network resources

    • Group Policy can be used to enforce security settings and configurations across the network

  • Answered by AI
Round 4 - One-on-one 

(1 Question)

  • Q1. Last round with the manager and salary negotiation
Round 5 - HR 

(1 Question)

  • Q1. Final discussion with the HR Partner

Skills evaluated in this interview

Team Lead Interview Questions & Answers

Amdocs user image Vibhavaree Laturkar

posted on 26 Jun 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Write java coding for solutions providesd?

Round 2 - Technical 

(2 Questions)

  • Q1. What is sql? And what is use on select?
  • Ans. 

    SQL is a programming language used for managing and manipulating databases. The SELECT statement is used to retrieve data from a database.

    • SQL stands for Structured Query Language

    • It is used to communicate with databases to perform tasks such as querying, updating, and deleting data

    • The SELECT statement is used to retrieve data from a database

    • Example: SELECT * FROM table_name WHERE condition;

  • Answered by AI
  • Q2. Diff between inner join and outer join?
  • Ans. 

    Inner join returns only the rows that have matching values in both tables, while outer join returns all rows from both tables.

    • Inner join is used to retrieve rows from both tables that have matching values based on a specified condition.

    • Outer join is used to retrieve all rows from both tables, with matching rows from both tables where available.

    • Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id =...

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Detail about roal

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Success stories in previous organisation
  • Q2. How would you see urself in next 5yrs
  • Ans. Answer that comes with positive note is eager to grow up the ladder, if not a suitable candidate for any company
  • Answered Anonymously

Carelon Global Solutions Interview FAQs

What are the top questions asked in Carelon Global Solutions Senior Consultant interview?

Some of the top questions asked at the Carelon Global Solutions Senior Consultant interview -

  1. Analytical function in ...read more
  2. Scenario based informatica questi...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Oracle Interview Questions
3.7
 • 863 Interviews
Google Interview Questions
4.4
 • 841 Interviews
Amdocs Interview Questions
3.7
 • 517 Interviews
Zoho Interview Questions
4.3
 • 512 Interviews
KPIT Technologies Interview Questions
3.4
 • 290 Interviews
SAP Interview Questions
4.2
 • 284 Interviews
Adobe Interview Questions
3.9
 • 235 Interviews
Salesforce Interview Questions
4.0
 • 230 Interviews
View all
Carelon Global Solutions Senior Consultant Salary
based on 20 salaries
₹7.4 L/yr - ₹29 L/yr
8% less than the average Senior Consultant Salary in India
View more details

Carelon Global Solutions Senior Consultant Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

4.0

Salary

5.0

Job security

5.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Senior Software Engineer
3.3k salaries
unlock blur

₹9.5 L/yr - ₹28 L/yr

Software Engineer
3.3k salaries
unlock blur

₹5 L/yr - ₹16.5 L/yr

Claims Associate
2.4k salaries
unlock blur

₹1 L/yr - ₹6 L/yr

Associate Software Engineer
1.4k salaries
unlock blur

₹3 L/yr - ₹9.5 L/yr

Associate
1k salaries
unlock blur

₹1.8 L/yr - ₹6 L/yr

Explore more salaries
Compare Carelon Global Solutions with

Oracle

3.7
Compare

Amdocs

3.7
Compare

Automatic Data Processing (ADP)

4.0
Compare

24/7 Customer

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