Upload Button Icon Add office photos

Johnson & Johnson

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Johnson & Johnson Data Analyst Interview Questions and Answers

Updated 31 Jul 2024

Johnson & Johnson Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 31 Jul 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What time intelligence functions can be used for ytd and qtd analysis
  • Ans. 

    Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.

    • YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

    • QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

    • Thes...

  • Answered by AI
  • Q2. Difference between import and direct query
  • Ans. 

    Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.

    • Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

    • Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

    • Import is suitable for smaller datasets, while direct query is better for large da

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions regarding Sas and aptitude questions and previous company project details

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident on projects and technical knowledge in sas

I applied via Recruitment Consulltant and was interviewed before May 2021. 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 Resume tips
Round 2 - Technical 

(3 Questions)

  • Q1. Questions related to Data analytics and SharePoint for my role.
  • Q2. Previous projects and their solutions.
  • Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)
Round 3 - Interview 

(1 Question)

  • Q1. Related to professional life and assurance to work.
Round 4 - HR 

(1 Question)

  • Q1. Salary details and candidature check.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well with you technical rounds. It will be medium level (not to easy or difficult in cracking the interview).
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why did you choose to work at Pfizer?
Round 2 - One-on-one 

(1 Question)

  • Q1. Tell me about your project
Round 3 - Group Discussion 

Time management and organization skills

Data Analyst Interview Questions & Answers

Bayer user image Virendra Chavhan

posted on 23 Mar 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Coding questions on python
  • Q2. Version control system GitHub questions
  • Q3. Web scraping questions
Round 2 - Technical 

(1 Question)

  • Q1. Behavioral questions on senarioy
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Data management
  • Q2. Excel pivot, Vlookup

Interview Preparation Tips

Interview preparation tips for other job seekers - know more about the role in JD
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

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

Round 1 - One-on-one 

(1 Question)

  • Q1. About Sql, project and work we did
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2023. There were 6 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 Resume tips
Round 2 - Aptitude Test 

Basic questions based on sql theories and excel

Round 3 - Assignment 

Assignment to solve excel sheets using advanced excel functions

Round 4 - Technical 

(1 Question)

  • Q1. Common interview questions, index match, self join, SQL theoretical questions ( types of join, union and union all , delete and truncate difference), data modelling using excel, count if, case study.
Round 5 - Technical 

(1 Question)

  • Q1. Previous experience and personal questions and tools knowledge
Round 6 - HR 

(1 Question)

  • Q1. Salary discussion round

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared

Data Analyst Interview Questions & Answers

Merck user image Nishant Deswal

posted on 19 Sep 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

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

I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Logical reasoning numerical English sum

Round 2 - Coding Test 

Python power bi sql tablue

Interview Preparation Tips

Topics to prepare for Merck Data Analyst interview:
  • Python
  • SQL
  • Power Bi
  • Tablu
Interview preparation tips for other job seekers - No
Contribute & help others!
anonymous
You can choose to be anonymous

Johnson & Johnson Interview FAQs

How many rounds are there in Johnson & Johnson Data Analyst interview?
Johnson & Johnson interview process usually has 1 rounds. The most common rounds in the Johnson & Johnson interview process are Technical.
How to prepare for Johnson & Johnson Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Johnson & Johnson. The most common topics and skills that interviewers at Johnson & Johnson expect are Analytics, Tableau, Analytical skills, Commercial Operations and Communication Skills.
What are the top questions asked in Johnson & Johnson Data Analyst interview?

Some of the top questions asked at the Johnson & Johnson Data Analyst interview -

  1. What time intelligence functions can be used for ytd and qtd analy...read more
  2. Difference between import and direct qu...read more

Recently Viewed

LIST OF COMPANIES

Harsha Engineers

Locations

INTERVIEWS

PepsiCo

No Interviews

INTERVIEWS

BuyerForesight

No Interviews

DESIGNATION

SALARIES

GSPANN Technologies

SALARIES

Johnson & Johnson

INTERVIEWS

GSPANN Technologies

No Interviews

INTERVIEWS

DSR Multi Speciality Hospital

No Interviews

SALARIES

BuyerForesight

SALARIES

GSPANN Technologies

Tell us how to improve this page.

Johnson & Johnson Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Data Analyst Interview Questions from Similar Companies

View all
Johnson & Johnson Data Analyst Salary
based on 69 salaries
₹3 L/yr - ₹13 L/yr
24% more than the average Data Analyst Salary in India
View more details

Johnson & Johnson Data Analyst Reviews and Ratings

based on 11 reviews

4.3/5

Rating in categories

4.1

Skill development

4.3

Work-life balance

3.9

Salary

3.0

Job security

3.9

Company culture

3.4

Promotions

4.2

Work satisfaction

Explore 11 Reviews and Ratings
District Manager
119 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate District Manager
108 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Medical Representative
107 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Field Manager
101 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Sales Manager
85 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Johnson & Johnson with

Procter & Gamble

4.1
Compare

GlaxoSmithKline Pharmaceuticals

4.1
Compare

Novartis

4.1
Compare

Pfizer

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