Upload Button Icon Add office photos

LinkedIn

Compare button icon Compare button icon Compare

Filter interviews by

LinkedIn Senior Business Analyst Interview Questions and Answers

Updated 26 Feb 2024

LinkedIn Senior Business Analyst Interview Experiences

2 interviews found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Normal verification
Round 2 - Technical 

(2 Questions)

  • Q1. Questions related to sql
  • Q2. Windows function in sql
  • Ans. 

    The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.

    • The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.

    • Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

    • Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;

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

(1 Question)

  • Q1. Interview with stakeholders

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed before Oct 2022. There were 3 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 - Case Study 

The first round was with the consultancy manager and they screened my resume and felt it is good match for the role. The second round was taken by the Project Manager of LinkedIn and 3rd round from the assigned team's manager. Both the last two rounds included cases studies, Questions on the resume and previous experiences and the decision making on the situations.

There were few questions from my end to the interviewer on the 3rd round for which the interviewer(she) got irritated and asked me to check on the JD, the question was in relate to know the products of LinkedIn whereas the the details in related to the products of LinkedIn was not mentioned. Only the role and responsibilities were stated.

However she even escalated this to the consultancy. I felt the interviewer is so immature and impatient in handling situations and was skeptical of her handling the team and eventually it proved right.

She made me feel very degraded being a Contract role employee, even a small mistakes and even misunderstandings were notified to the consultancy and was been escalated. It clearly showed that there is lack of leadership qualities and taken for granted attitude. (The team is "Outsourcing and Strategy")

I wish no one should no face such situations and get departed for silly reasons, Everyone has their commitments, responsibilities and duties which will affected deeply in the midway.

Nonetheless every employee irrespective of Permanent or Contractual deserves respect, motivation and a good words from his/her hierarchy rather pointing out, escalations will take no where.

I was surprised that LinkedIn has such attitude issues with contract role employees (Some managers).

However, I wish whoever applying to any roles in LinkedIn do get a good manager at the first place and the rest all falls in its place eventually. All the best...!!!

Round 3 - One-on-one 

(1 Question)

  • Q1. Please refer the above

Interview Preparation Tips

Interview preparation tips for other job seekers - All the details has been stated in the first comment box

Senior Business Analyst Interview Questions Asked at Other Companies

asked in Sapiens
Q1. Difference between annuity and pension, types of annuity and pens ... read more
Q2. If you had to accommodate a CR in agile how would you do so?
asked in Brillio
Q3. If I tell you to prepare a TOC for a RFP what will you put into i ... read more
Q4. What are the different meetings that happen in Agile style develo ... read more
asked in EVRY India
Q5. Five concepts in artificial intelligence, In machine learnin ... read more

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Coding Test 

SQL based test, basic to advance concepts

I applied via Approached by Company

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 

Calculate running total

Round 3 - Technical 

(1 Question)

  • Q1. SQL coding questions, joins, unions, window functions

Interview Preparation Tips

Interview preparation tips for other job seekers - Practise the basics of SQL concepts: CTE, Window functions, Joins, Keys etc.
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn

Round 1 - Case Study 

What should be the metrics to track for ideal customers

Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Assignment 

They sent a hackerrank test which had only sql questions

Round 2 - Coding Test 

They asked for my last project and asked few sql questions. They also asked few statistics question which was not expected

Interview Preparation Tips

Interview preparation tips for other job seekers - Please brush up sql and statistics can also depend on interviewer
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in May 2023. There were 3 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 

(2 Questions)

  • Q1. Basic, personal indulgence
  • Q2. About experiences
Round 3 - Technical 

(2 Questions)

  • Q1. Sales funnel, market trends
  • Q2. Reasons for leaving the company
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Medium to hard level sql questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Messho is unprofessional and a company with bad work culture. People are rude and pathetic. Only if you are a fresher.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 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 - Technical 

(5 Questions)

  • Q1. SQL Theory - joins, order of execution, window functions
  • Q2. Hands-on SQL - handling corner cases, solving practical problems
  • Q3. Python/Excel (if on resume). Important functions and packages e.g. (VLOOKUP, pandas, etc.)
  • Q4. Data visualization - basic understanding of storytelling with data, when to use what visualization
  • Q5. Schema design (if having experience) - what factors to consider, normalization, fact vs transaction tables
Round 3 - Analytical 

(3 Questions)

  • Q1. Basic stats - central tendencies, distributions, skewness, outlier detection
  • Q2. Experiment design, hypothesis testing
  • Q3. Analytical case studies - how to solve problems and when to apply different approaches such as segmentation, clustering, forecasting, etc.
Round 4 - Case Study 

Open-ended case study to understand your approach and considerations. Use common sense, explain your thinking and be rigorous. Can come from any field but does not require field-intensive knowledge

Round 5 - Behavioral 

(3 Questions)

  • Q1. Personality questions, motivations, company culture fit
  • Q2. Can re-touch on anything from previous round
  • Q3. In-depth exploration of any project or skill on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure your SQL is up to par. Do plenty of practical problems and make sure your theory is brushed up. Later rounds are largely about common sense and analytical thinking which should be developed over time and with experience. Sample case studies will help but be sure to have solid foundations. Be sure to ask questions so you understand about the company and can also show what is important to you.

I applied via Recruitment Consultant and was interviewed in Jul 2019. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Aptitude test with 20 questions 1 hr, probability, data interpretation and hypothesis testing-linear/logistic/random forest regression assumptions

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong sql and excel skills, prepare your resume and puzzles / guestimates

LinkedIn Interview FAQs

How many rounds are there in LinkedIn Senior Business Analyst interview?
LinkedIn interview process usually has 3 rounds. The most common rounds in the LinkedIn interview process are One-on-one Round, Resume Shortlist and Case Study.
What are the top questions asked in LinkedIn Senior Business Analyst interview?

Some of the top questions asked at the LinkedIn Senior Business Analyst interview -

  1. Windows function in ...read more
  2. Please refer the ab...read more
  3. Questions related to ...read more

Tell us how to improve this page.

LinkedIn Senior Business Analyst Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more
LinkedIn Senior Business Analyst Salary
based on 5 salaries
₹11.3 L/yr - ₹19.3 L/yr
At par with the average Senior Business Analyst Salary in India
View more details

LinkedIn Senior Business Analyst Reviews and Ratings

based on 2 reviews

1.4/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

3.0

Salary

1.0

Job security

2.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 2 Reviews and Ratings
Software Engineer
88 salaries
unlock blur

₹17 L/yr - ₹70 L/yr

Trust and Safety Specialist
73 salaries
unlock blur

₹5.5 L/yr - ₹9 L/yr

Senior Software Engineer
63 salaries
unlock blur

₹29.6 L/yr - ₹91.8 L/yr

Software Developer
62 salaries
unlock blur

₹17.5 L/yr - ₹40 L/yr

Content Reviewer
37 salaries
unlock blur

₹3.6 L/yr - ₹9.9 L/yr

Explore more salaries
Compare LinkedIn with

Amazon

4.1
Compare

Flipkart

3.9
Compare

Udaan

3.9
Compare

BigBasket

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