Celebal Technologies Associate Consultant Interview Questions and Answers

Basic gocube test

Q1. Company work expectation and past experience questions
Add your answer

Q1. The Question was based on applying statistical knowledge by providing a real life scenario of sampling and how to best choose the sample size without making it computationally expensive
Add your answer
Q2. The Question was about the domain knowledge and what are the real hurdles we face in live project while trying to pitch aftersales to a new stakeholder
Add your answer

It happened in Mettel platfrom, where there were 3 sections like any normal test but mostly focused on the role we are applying for

Q1. The question was based on the case study , where the team wants to explore the opportunity to expand the market share of drug
Add your answer
Q2. Advanced SQL functions(Data Extractions), and Data manipulations on live DB
Add your answer

Logical qns totally-easy to moderate

Coding in tech tools as interviewed

Q1. About resume points
Add your answer
Q2. Qns on tech tools used
Ans. 
I have experience using a variety of tech tools including Microsoft Office Suite, Google Analytics, and Salesforce.
• Microsoft Office Suite (Word, Excel, PowerPoint)

• Google Analytics for data analysis

• Salesforce for CRM management
Answered by AI
Add your answer

Duration 1 hr around 60 questions

Q1. Find anagrams in a sentence
Ans. 
Identify anagrams within a given sentence
• Split the sentence into individual words

• Compare each word to every other word to find anagrams

• Store anagrams in an array of strings
Answered by AI
Add your answer
Q2. Find lca of a binary tree
Ans. 
The lowest common ancestor (LCA) of a binary tree is the shared ancestor of two nodes farthest from the root.
• Start from the root and recursively search for the nodes in the left and right subtrees.

• If one node is found in the left subtree and the other in the right subtree, then the root is the LCA.

• If both nodes are found in the left subtree, then the LCA is in the left subtree. Same for the right subtree.

• Repeat the pro
Answered by AI
Add your answer

Q1. Find duplicates in a string
Ans. 
Use a hash set to find duplicates in a string efficiently.
• Create a hash set to store characters as you iterate through the string.

• If a character is already in the hash set, it is a duplicate.

• Return the duplicates as an array of strings.
Answered by AI
Add your answer
Q2. Find the sum of the digits in a reverse order
Ans. 
To find the sum of digits in reverse order, reverse the number and then add the digits together.
• Reverse the given number

• Separate each digit of the reversed number

• Add all the digits together to get the sum
Answered by AI
Add your answer

Q1. Basic Understanding ML , SQL Python and case study related questions
Add your answer

Q1. Basic sql python and ML Question
Add your answer

Q1. How to deal with problems that come daily along the way
Ans. 
To deal with daily problems, it is important to stay calm, prioritize tasks, seek help when needed, and learn from each experience.
• Stay calm and composed to think clearly and make rational decisions

• Prioritize tasks based on urgency and importance

• Seek help from colleagues or supervisors when facing complex problems

• Learn from each experience to prevent similar problems in the future
Answered by AI
Add your answer