Upload Button Icon Add office photos

Filter interviews by

Lividus Pharmaceuticals Data Engineer Interview Questions and Answers

Updated 17 Mar 2024

Lividus Pharmaceuticals Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Priyanshu Sharma

posted on 17 Mar 2024

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

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

Round 1 - Coding Test 

Question 1 find the median of running integer stream
Question 2 print matrix in spiral form
Question 3 implement LRU cache

Round 2 - Technical 

(1 Question)

  • Q1. Design system to capture clickstream data and design dashboard for reviews
  • Ans. 

    Design system to capture clickstream data and design dashboard for reviews

    • Implement a data pipeline to capture clickstream data from website or application

    • Store the clickstream data in a data warehouse or database for analysis

    • Design a dashboard using visualization tools like Tableau or Power BI to display clickstream data and reviews

    • Include key metrics such as click-through rates, page views, and user interactions in t...

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. Explain current project how will you handle upserts in streaming data without getting duplicates.
  • Ans. 

    Handling upserts in streaming data without duplicates by using unique identifiers and maintaining state.

    • Use unique identifiers in the incoming data to determine if a record is new or needs to be updated.

    • Maintain a state store to keep track of the latest version of each record.

    • Compare incoming data with the state store to identify duplicates and handle them accordingly.

    • Implement a deduplication mechanism to prevent dupl...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Piraamal finance jnlnm knkn

Round 2 - One-on-one 

(2 Questions)

  • Q1. What is sql? and where to use
  • Ans. 

    SQL is a programming language used for managing and manipulating relational databases.

    • SQL stands for Structured Query Language

    • Used to retrieve, update, and manage data in relational databases

    • Commonly used in data analysis, data manipulation, and data reporting

    • Examples: SELECT * FROM table_name, INSERT INTO table_name VALUES (value1, value2)

  • Answered by AI
  • Q2. Power bi description and its imp
  • Ans. 

    Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.

    • Power BI allows users to connect to a wide variety of data sources and create interactive reports and dashboards.

    • Users can easily share their insights with others and collaborate in real-time.

    • It offers features like data modeling, data preparation, and data visualization to help organizatio...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - nothing adsncxi nlck mn jfngv fjmogvhfdx
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Trigonometry, permutations and combinations

Round 2 - Coding Test 

Average python coding questions like palindrome

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

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why you wanted to join Stelis biopharma?
Round 2 - Technical 

(2 Questions)

  • Q1. What are dis advantages of data analytics? Difference between data science and data analyst?
  • Ans. 

    Disadvantages of data analytics include potential privacy concerns, data quality issues, and the need for skilled professionals. Data science involves more advanced techniques and focuses on predictive modeling.

    • Privacy concerns: Data analytics may involve handling sensitive information, raising privacy issues for individuals or organizations.

    • Data quality issues: Inaccurate or incomplete data can lead to incorrect analy...

  • Answered by AI
  • Q2. What data analysts do? What data scientists do?
  • Ans. 

    Data analysts analyze data to provide insights and make data-driven decisions. Data scientists use advanced techniques to extract knowledge from data.

    • Data analysts focus on analyzing data to identify trends, patterns, and insights.

    • Data analysts use statistical and data visualization tools to present findings to stakeholders.

    • Data scientists use advanced techniques like machine learning and predictive modeling to extract...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for OneSource Specialty Pharma Limited Data Analyst interview:
  • Data Analytics
Interview preparation tips for other job seekers - Online technical test link they hav provided

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Feb 2023. There were 2 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 - One-on-one 

(2 Questions)

  • Q1. Basic of core java,oracle, html,css,Javascript
  • Q2. My self introduction

Interview Preparation Tips

Topics to prepare for MSN Laboratories Softwaretest Engineer interview:
  • Core java,oracle,Ui technology
Interview preparation tips for other job seekers - I'm fresher. I completed degree b.s.c(mpcs) in 2022.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 4 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 - Aptitude Test 

Good and not that much difficult

Round 3 - Technical 

(1 Question)

  • Q1. Good, interview was gone very smooth and you should know about what you mentioned in resume
Round 4 - HR 

(1 Question)

  • Q1. They will ask about personal information and inform you about your role

Interview Preparation Tips

Interview preparation tips for other job seekers - Everything goes well and interview was also good they will check our confidence and communication skills
Round 1 - Assignment 

Tableau Developer

I was given an assignment where I had to build dashboard with final story within 1 hour

Round 2 - One-on-one 

(1 Question)

  • Q1. Why Novo? Why this role?
Round 3 - One-on-one 

(1 Question)

  • Q1. Director Round with department head
Round 4 - One-on-one 

(1 Question)

  • Q1. Affiliate Round with either US folks or Denmark folks
Round 5 - HR 

(4 Questions)

  • Q1. What is your family background?
  • Q2. What are your strengths and weaknesses?
  • Q3. Tell me about yourself.
  • Q4. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be true with respect to tour resume
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Maulana Azad National Institute of Technology (NIT), Bhopal and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

Maths, logical reasoning, 1.5 hrs

Round 3 - Technical 

(3 Questions)

  • Q1. About sql joins, python sets, lists, etc
  • Q2. Queries, union etc
  • Q3. Project related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - sharpen your sql basics and project detailing
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Naukri.com and was interviewed before Sep 2023. There were 3 interview rounds.

Round 1 - Coding Test 

3 sum, and search in pivot array

Round 2 - Technical 

(1 Question)

  • Q1. Basic OOPS concepts question
Round 3 - HR 

(1 Question)

  • Q1. Behavioral Questions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Easy questions , i was preprared as well, they wanted devops tools to be learnt

Interview Preparation Tips

Topics to prepare for OneSource Specialty Pharma Limited Data Analyst interview:
  • Devops

Lividus Pharmaceuticals Interview FAQs

How many rounds are there in Lividus Pharmaceuticals Data Engineer interview?
Lividus Pharmaceuticals interview process usually has 3 rounds. The most common rounds in the Lividus Pharmaceuticals interview process are Coding Test, Technical and Behavioral.
What are the top questions asked in Lividus Pharmaceuticals Data Engineer interview?

Some of the top questions asked at the Lividus Pharmaceuticals Data Engineer interview -

  1. Design system to capture clickstream data and design dashboard for revi...read more
  2. explain current project how will you handle upserts in streaming data without ...read more

Tell us how to improve this page.

Lividus Pharmaceuticals Data Engineer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Cipla Interview Questions
4.1
 • 481 Interviews
Lupin Interview Questions
4.2
 • 334 Interviews
Aurobindo Pharma Interview Questions
4.0
 • 237 Interviews
Hetero Interview Questions
3.9
 • 199 Interviews
Biocon Limited Interview Questions
3.9
 • 151 Interviews
MSN Laboratories Interview Questions
3.7
 • 128 Interviews
View all
Territory Manager
9 salaries
unlock blur

₹2 L/yr - ₹3 L/yr

Business Manager
7 salaries
unlock blur

₹3.5 L/yr - ₹5.8 L/yr

Area Business Manager
5 salaries
unlock blur

₹4 L/yr - ₹7 L/yr

Territory Sales Manager
4 salaries
unlock blur

₹1.9 L/yr - ₹4.6 L/yr

Medical Representative
4 salaries
unlock blur

₹1.8 L/yr - ₹3 L/yr

Explore more salaries
Compare Lividus Pharmaceuticals with

Sun Pharmaceutical Industries

4.0
Compare

Cipla

4.1
Compare

DRJ & CO

5.0
Compare

Biocon Limited

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