Upload Button Icon Add office photos

Filter interviews by

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

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

(3 Questions)

  • Q1. Type of Filters in Tableau.
  • Ans. 

    Tableau offers various types of filters including quick filters, context filters, and data source filters.

    • Quick filters allow users to easily filter data by selecting values from a list.

    • Context filters are applied before other filters, affecting the data visible to subsequent filters.

    • Data source filters limit the data available to Tableau by filtering data at the data source level.

    • Other types of filters include extract...

  • Answered by AI
  • Q2. Types of refresh in Tableau
  • Ans. 

    There are two types of refresh in Tableau: Extract Refresh and Data Source Refresh.

    • Extract Refresh: Refreshes the data in Tableau extract, which is a snapshot of data from the original data source.

    • Data Source Refresh: Refreshes the data directly from the original data source.

    • Examples: Extract Refresh is useful when working with large datasets to improve performance, while Data Source Refresh ensures real-time data upda

  • Answered by AI
  • Q3. Difference in Extract and live connection.
  • Ans. 

    Extract connection imports data into Tableau workbook while live connection directly connects to data source.

    • Extract connection creates a static snapshot of data in Tableau workbook.

    • Live connection directly queries data from the source in real-time.

    • Extract connection is useful for large datasets or when offline access is needed.

    • Live connection is beneficial for real-time data analysis and dynamic updates.

    • Example: Extra...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Jul 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

It was basic aptitude but it was online

Round 2 - Technical 

(1 Question)

  • Q1. Write python code for bizzbuss for prime or not prime\
  • Ans. 

    Python code for determining if a number is prime or not and applying bizzbuzz logic.

    • Write a function to check if a number is prime or not

    • Iterate through a range of numbers and apply bizzbuzz logic

    • Return 'prime' if the number is prime, 'bizz' if divisible by 3, 'buzz' if divisible by 5, and 'bizzbuzz' if divisible by both 3 and 5

  • Answered by AI

Skills evaluated in this interview

I applied via campus placement at Madras Institute of Technology, Chennai and was interviewed in Sep 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 - Aptitude Test 

Easy but time limit was the main issue to address

Round 3 - Coding Test 

Hard coding test on hacker earth platform no cameras and plagiarism tester will be on

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and precise ,so be yourself and consider good practice before test
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. In depth project based qiestions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Nov 2023. 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 - Technical 

(1 Question)

  • Q1. SQL related questions on snowflake and databricks
Round 3 - Technical 

(1 Question)

  • Q1. Database architecture and design related questions
Round 4 - Behavioral 

(1 Question)

  • Q1. Databricks experience, domain knowledge and mostly experience related questions.
Round 5 - HR 

(1 Question)

  • Q1. Expectations and how you would be a good fit. All general HR questions that you can find

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident about your skills and sale yourself well.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about your self
  • Ans. 

    I am a detail-oriented individual with strong data entry skills and a passion for accuracy.

    • Experienced in data entry tasks such as inputting information into databases

    • Proficient in using Microsoft Excel and other data entry software

    • Strong attention to detail and ability to maintain accuracy in high-volume data entry tasks

  • Answered by AI
  • Q2. Why we should hair you
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about your self
  • Ans. 

    I am a detail-oriented individual with strong data entry skills and a passion for accuracy.

    • Experienced in data entry tasks such as inputting information into databases

    • Proficient in using Microsoft Excel and other data entry software

    • Strong attention to detail and accuracy in data entry work

    • Ability to work efficiently under pressure and meet deadlines

  • Answered by AI
  • Q2. Why we should hire you
  • Ans. 

    I am detail-oriented, efficient, and have a strong background in data entry.

    • I have a proven track record of accurately entering data in a timely manner.

    • I am proficient in using data entry software and have a fast typing speed.

    • I have excellent attention to detail and can spot errors quickly to ensure data accuracy.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good environment
Round 1 - Billing 

Interview Preparation Tips

Interview preparation tips for other job seekers - Data entry operator
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Type of Filters in Tableau.
  • Ans. 

    Tableau offers various types of filters including quick filters, context filters, and data source filters.

    • Quick filters allow users to easily filter data by selecting values from a list.

    • Context filters are applied before other filters, affecting the data visible to subsequent filters.

    • Data source filters limit the data available to Tableau by filtering data at the data source level.

    • Other types of filters include extract...

  • Answered by AI
  • Q2. Types of refresh in Tableau
  • Ans. 

    There are two types of refresh in Tableau: Extract Refresh and Data Source Refresh.

    • Extract Refresh: Refreshes the data in Tableau extract, which is a snapshot of data from the original data source.

    • Data Source Refresh: Refreshes the data directly from the original data source.

    • Examples: Extract Refresh is useful when working with large datasets to improve performance, while Data Source Refresh ensures real-time data upda

  • Answered by AI
  • Q3. Difference in Extract and live connection.
  • Ans. 

    Extract connection imports data into Tableau workbook while live connection directly connects to data source.

    • Extract connection creates a static snapshot of data in Tableau workbook.

    • Live connection directly queries data from the source in real-time.

    • Extract connection is useful for large datasets or when offline access is needed.

    • Live connection is beneficial for real-time data analysis and dynamic updates.

    • Example: Extra...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Jul 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

It was basic aptitude but it was online

Round 2 - Technical 

(1 Question)

  • Q1. Write python code for bizzbuss for prime or not prime\
  • Ans. 

    Python code for determining if a number is prime or not and applying bizzbuzz logic.

    • Write a function to check if a number is prime or not

    • Iterate through a range of numbers and apply bizzbuzz logic

    • Return 'prime' if the number is prime, 'bizz' if divisible by 3, 'buzz' if divisible by 5, and 'bizzbuzz' if divisible by both 3 and 5

  • Answered by AI

Skills evaluated in this interview

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

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
120 salaries
unlock blur

₹5.9 L/yr - ₹13 L/yr

Associate District Manager
108 salaries
unlock blur

₹4 L/yr - ₹11 L/yr

Medical Representative
107 salaries
unlock blur

₹1.8 L/yr - ₹6 L/yr

Field Manager
101 salaries
unlock blur

₹10 L/yr - ₹22.3 L/yr

Area Sales Manager
85 salaries
unlock blur

₹6.2 L/yr - ₹22 L/yr

Explore more salaries
Compare Johnson & Johnson with

Procter & Gamble

4.2
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