Upload Button Icon Add office photos

Filter interviews by

Cervello Analyst Interview Questions and Answers

Updated 11 Jun 2024

Cervello Analyst Interview Experiences

1 interview found

Analyst Interview Questions & Answers

user image Anonymous

posted on 11 Jun 2024

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Difficult for a fresher if not well versed with advanced sql concepts
Was pen & paper based

Round 2 - Technical 

(4 Questions)

  • Q1. Medium to hard level sql & python theory questions
  • Q2. Few easy to medium level python codes
  • Q3. Multiple medium to difficult level sql problems
  • Ans. 

    The interview question involves solving multiple medium to difficult level SQL problems.

    • Understand the problem statement clearly before starting to write SQL queries.

    • Break down the problem into smaller parts if necessary.

    • Use SQL functions and operators effectively to solve the problems.

    • Test your queries with sample data to ensure they are working correctly.

  • Answered by AI
  • Q4. Lasted for around 90 minutes
Round 3 - Technical 

(2 Questions)

  • Q1. Advanced questions on sql & python
  • Q2. Few weird questions which were personality and choice based

Interview Preparation Tips

Interview preparation tips for other job seekers - Generally a difficult and tiring process of hiring. But the benefits later on if you get selected are great.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via campus placement at Bharati Vidyapeeth's College of Engineering for Women, Pune and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Permutations, probability etc

Round 2 - Technical 

(5 Questions)

  • Q1. Dbms ,oops , dsa
  • Q2. Write SQL query for joining two tables
  • Ans. 

    SQL query for joining two tables

    • Use the JOIN keyword to combine rows from two or more tables based on a related column between them

    • Specify the columns to be retrieved using SELECT statement

    • Use ON keyword to specify the join condition

  • Answered by AI
  • Q3. Analysis questions consists comparison
  • Q4. Array indexing, sorting array
  • Q5. Reverse the string
  • Ans. 

    Reverse a given string

    • Use a loop to iterate through the characters of the string and build a new string in reverse order

    • Alternatively, you can use built-in functions like reverse() or StringBuilder in some programming languages

  • Answered by AI
Round 3 - Group Discussion 

Basic GD topic was there

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be urself and give 100%

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. R&D systems design mostly asked

Analyst Interview Questions & Answers

ElectrifAi user image shubham gupta

posted on 17 Apr 2016

Interview Questionnaire 

7 Questions

  • Q1. How to assigning the new task to employees based on their past performance
  • Ans. 

    Assign tasks based on past performance by analyzing employee's strengths and weaknesses.

    • Analyze employee's past performance data

    • Identify their strengths and weaknesses

    • Assign tasks that align with their strengths

    • Provide training or support for areas of weakness

    • Regularly review and adjust task assignments based on performance

    • Consider employee preferences and career goals

  • Answered by AI
  • Q2. Some Probability problems
  • Q3. Some basic HR questions
  • Q4. Write a 10 digit largest number with some constraint (I didn’t remember the exact constraint but it’s a standard question)
  • Q5. Guesstimate the number of viewers to a sports blog
  • Ans. 

    Assuming the blog covers popular sports, the number of viewers can range from a few thousand to millions depending on the quality of content and marketing strategies.

    • Consider the popularity of the sports covered in the blog

    • Evaluate the quality of content and frequency of updates

    • Assess the marketing strategies used to promote the blog

    • Look at the engagement level of the blog's social media accounts

    • Take into account the c

  • Answered by AI
  • Q6. Guesstimate how much a thief, who operate on shopping can earn in a year
  • Ans. 

    A thief operating in shopping can earn anywhere from a few thousand to millions of dollars per year depending on their tactics and location.

    • The thief's location and the type of stores they target will greatly impact their earnings

    • Factors such as the thief's level of experience, skill, and risk-taking behavior will also play a role in their earnings

    • Some thieves may work alone while others may operate in organized groups...

  • Answered by AI
  • Q7. The probability of a car passes the highway in a subset time if the probability of a car passing in one hour given

Interview Preparation Tips

Round: Resume Shortlist
Experience: There were 3 Job profiles open of opera solutions (Solution Analyst, Analytics Specialist, and Software Engineer). Students are asked to sign just for one profile. There was a test for analytics and software profile and direct interview for solution profile (Consultant profile).
Tips: Spend enough time before choosing the profiles. Spoke to senior who had a similar job and figure out your best suitable profile and prepare accordingly.

Round: Test
Experience: Opera solution conducts workshop for shortlisted candidates. In the workshop, they mostly tell about technical part behind big data management such as Mainframe and Hadoop. After the workshop, the test was conducted. The test had two sections, the first section contains objective questions around 20-25 (I did not remember the exact number). Objective questions were of aptitude type (moderate level of difficulty). The second section contains 5-6 subjective questions, mainly focus on probability again the moderate level of difficulty. 30 students were shortlisted for next round (interview round).
Tips: Start preparing as early you can. Practice problem daily does not wait for last few day. The main point of practice is to develop a habit of increasing accuracy and speed which is the crucial points of aptitude test.
For probability practice, there are online website and blogs you can take help from them. I have listed down some which are used. You should have some prior practice before setting for test otherwise, it would be difficult to do well in the test as some questions are tricky and difficult to solve in the first time.
For aptitude practice, you can refer TIME material, I think that is sufficient.

-----/
-----.shtml
-----
-----.html

Duration: 60 min minutes
Total Questions: 20+5

Round: Guesstimate Interview
Experience: The interviewer first goes through my resume and ask some basic question, not in depth. Then he asked me some puzzle (similar type of question asked in the subjective paper but with a high level of difficulty) and one guesstimate.
My interview last for 10-15 mins, the interviewer is very helpful and always try to calm and comfort me.
The interviewer gave me feedback and point out some area on which I can quickly look it for further interview.

Tips: I have assigned a buddy, IIT graduate having the same specialization. (Opera solutions follow buddy program similar of other consultant company). I personally found out buddy program very useful, you should contact your buddy or at least talk to him ones. The information you get from a buddy is very helpful of preparing for an interview. You get some aspect on which domain you need to work.

Round: Technical Interview
Experience: Next round was the telephonic interview with a senior analyst. The interviewer asked me some question from my resume especially on the technical project which involves some mathematics tool.
Then he asked some probability problems which are very tough.

Tips: The interviewer was interested in your approach only, how you’re tackling the problem. How much wide can you think? The interviewer is also ready to help you and try to figure out your strength. So be calm and speak with confidence.

Round: Stress Interview
Experience: The interviewer asked me some question from my resume in depth.
He asked one guesstimate and one probability question.

Round: Behavioural Interview
Experience: The interviewer started with questions like why this company, which other companies did I appeared for.
He asked me some quick calculation problems.

General Tips: Resume: Spend sufficient time on the resume as I was the initial step of shortlisting.
You be able to speak at any point in your resume in detail, hence you must be sure of what you are writing in it.

Puzzle: Practice Daily

Guesstimate: Practice with your sincere friends
Skills: Ability To Make Quick Calculations, Puzzle Solving Capability, Knowledge Of Your Resume Points, Guesstimation Cases, Probability And Statistics
College Name: IIT Bombay
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Sri Venkateswara College of Engineering, Chennai and was interviewed before Nov 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic Aptitude (prob, )

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic sql and exel
Round 3 - HR 

(1 Question)

  • Q1. Tell me about your self
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Apr 2023.

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 - Assignment 

Project assigned for creating new website

Round 3 - Technical 

(2 Questions)

  • Q1. Interview with reporting managers virtually
  • Q2. About the previous role
Round 4 - HR 

(1 Question)

  • Q1. HR asked about the previous job and all

Interview Preparation Tips

Interview preparation tips for other job seekers - Before joining any company or organization please make sure you have gone through the reviews. Otherwise you will be regret for the same.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

MCQs on Quants, Logical reasoning, English

Round 2 - Technical 

(1 Question)

  • Q1. Technical interview based on Internship projects and Basics of Java, Dot Net and SQL
Round 3 - HR 

(1 Question)

  • Q1. Based on resume
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Basic question related to your profile and Resume.
Round 3 - Assignment 

Focus on core tableau concepts and look and feel of the dashbaords.

Round 4 - Technical 

(1 Question)

  • Q1. Deep dive into joins, relationship, union, data blending, performance tuning, etc.
Round 5 - Behavioral 

(1 Question)

  • Q1. Case studies question like what will be your response and some basic technical questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very clear with your core concepts. have confidence in your answer
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. R&D systems design mostly asked

Interview Questionnaire 

1 Question

  • Q1. There is a number lock on a bag. It has numbers from 1-8. The lock can open if any 2 of 3 numbers in the bag is correct. You have to open the bag in minimum number of steps
  • Ans. 

    To open the number lock on the bag, you need to try combinations of three numbers, ensuring that at least two of them are correct.

    • Start by trying the combinations of the first two numbers with each of the remaining six numbers.

    • If none of these combinations work, move on to the next pair of numbers and repeat the process.

    • Continue this pattern until you find a combination that opens the lock.

  • Answered by AI

Interview Preparation Tips

Round: Puzzle Interview
Experience: A puzzle was asked first.
I was then given a case study : You own a telecom company. You have various customers. They have joined you 3 years ago,6 months ago and some recently. How do you define who is a good customer?

Round: Other Interview
Experience: It was only for 15 minutes. I was asked a question related to boy girl paradox. Then the job was offered.
Tips: Be cool and try to be less nervous. Do not try to speak about the things that you have no idea about

General Tips: Go to the interview with a cool mind. Take a trusted person with you if you are shortlisted on day 1.
College Name: IIT KANPUR

Cervello Interview FAQs

How many rounds are there in Cervello Analyst interview?
Cervello interview process usually has 3 rounds. The most common rounds in the Cervello interview process are Technical and Coding Test.
What are the top questions asked in Cervello Analyst interview?

Some of the top questions asked at the Cervello Analyst interview -

  1. Multiple medium to difficult level sql probl...read more
  2. Few weird questions which were personality and choice ba...read more
  3. Medium to hard level sql & python theory questi...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Cervello interview
Campus Placement
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Analyst Interview Questions from Similar Companies

Axtria Analyst Interview Questions
3.0
 • 32 Interviews
C5i Analyst Interview Questions
4.1
 • 6 Interviews
View all
Cervello Analyst Salary
based on 26 salaries
₹4.8 L/yr - ₹15 L/yr
49% more than the average Analyst Salary in India
View more details

Cervello Analyst Reviews and Ratings

based on 5 reviews

4.1/5

Rating in categories

3.5

Skill development

3.2

Work-Life balance

3.4

Salary & Benefits

2.2

Job Security

3.5

Company culture

3.5

Promotions/Appraisal

3.3

Work Satisfaction

Explore 5 Reviews and Ratings
Consultant
30 salaries
unlock blur

₹7.9 L/yr - ₹26 L/yr

Analyst
26 salaries
unlock blur

₹4.8 L/yr - ₹15 L/yr

Senior Consultant
12 salaries
unlock blur

₹18 L/yr - ₹44 L/yr

Data Engineer
8 salaries
unlock blur

₹5 L/yr - ₹10.1 L/yr

Business Analyst
6 salaries
unlock blur

₹9.2 L/yr - ₹13.3 L/yr

Explore more salaries
Compare Cervello with

Fractal Analytics

4.0
Compare

Mu Sigma

2.7
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

3.7
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
write
Share an Interview