Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Mehta Api Team. If you also belong to the team, you can get access from here

Mehta Api Verified Tick

Compare button icon Compare button icon Compare
3.2

based on 56 Reviews

Filter interviews by

Mehta Api Analyst Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed in Aug 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 - Technical 

(3 Questions)

  • Q1. HPLC calibration
  • Q2. Describe a time when you have encountered instrument malfunction
  • Ans. 

    Encountered instrument malfunction during a critical data analysis project

    • During a critical data analysis project, the software I was using to analyze the data suddenly crashed

    • I had to troubleshoot the issue by restarting the software and reloading the data

    • The malfunction caused a delay in the project deadline, but I was able to quickly resolve the issue and complete the analysis successfully

  • Answered by AI
  • Q3. What software are used in HPLC
  • Ans. 

    Common software used in HPLC include Empower, Chromeleon, and LabSolutions.

    • Empower

    • Chromeleon

    • LabSolutions

  • Answered by AI
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

Round 2 - Assignment 

RESEARCH ASSIGNMENT ON THE TB SPACE

I applied via Walk-in and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. About chemistry knowledge
  • Q2. Hwhat is mean by PH?.
  • Ans. 

    PH stands for potential of hydrogen. It is a measure of the acidity or alkalinity of a solution.

    • PH is a scale ranging from 0 to 14.

    • A pH of 7 is considered neutral, below 7 is acidic, and above 7 is alkaline.

    • The pH of common substances: lemon juice (2), water (7), baking soda (9).

  • Answered by AI
  • Q3. Negative logarithm of base 10
  • Ans. 

    Negative logarithm of base 10 is used to find the number of times 10 must be multiplied to get the given number.

    • Negative logarithm of base 10 is denoted as -log10(x)

    • It is used to find the pH value of a solution in chemistry

    • It is also used to measure the intensity of earthquakes using the Richter scale

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Best interview question answer
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

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

HPLC maintenance and calibration

Round 3 - HR 

(4 Questions)

  • Q1. Basic salary details
  • Q2. Date of joining
  • Q3. Current notice period
  • Q4. Expected CTC. and any other offers

Interview Preparation Tips

Interview preparation tips for other job seekers - you have to give a ppt on the topic they will give after the first round.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Explain example of window function
  • Ans. 

    Window functions are used to perform calculations across a set of table rows related to the current row.

    • Window functions are used in SQL to perform calculations within a specific window or subset of rows.

    • They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

  • Answered by AI
  • Q2. A question using aggregate function and case when in sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for skills that are required in the jd

I applied via Naukri.com and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Some organic chemistry-related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was for 3 three rounds.
written test . technical interview and presentation were compulsory.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Do you know adobe analytics
  • Ans. 

    Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.

    • I have used Adobe Analytics to track website traffic and user behavior

    • I have created custom reports and dashboards using Adobe Analytics

    • I am proficient in extracting insights from Adobe Analytics data to drive business decisions

  • Answered by AI
  • Q2. Explain example of window function
  • Ans. 

    Window functions are used to perform calculations across a set of table rows related to the current row.

    • Window functions are applied to a set of rows related to the current row in a query result.

    • They can be used to calculate running totals, averages, ranks, and more.

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for real life scenarios and learn skills that they need

I applied via Naukri.com and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Techinal questions. of subject
  • Q2. Mostly general technical questions.
Round 2 - Presentation 

(2 Questions)

  • Q1. Presentation on HPLC calibration
  • Q2. Presentation is compalsory

Interview Preparation Tips

Interview preparation tips for other job seekers - one round of technical questions and one round on presentation on Instrument
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

Round 2 - Assignment 

RESEARCH ASSIGNMENT ON THE TB SPACE

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

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

(3 Questions)

  • Q1. HPLC calibration
  • Q2. Describe a time when you have encountered instrument malfunction
  • Ans. 

    Encountered instrument malfunction during a critical data analysis project

    • During a critical data analysis project, the software I was using to analyze the data suddenly crashed

    • I had to troubleshoot the issue by restarting the software and reloading the data

    • The malfunction caused a delay in the project deadline, but I was able to quickly resolve the issue and complete the analysis successfully

  • Answered by AI
  • Q3. What software are used in HPLC
  • Ans. 

    Common software used in HPLC include Empower, Chromeleon, and LabSolutions.

    • Empower

    • Chromeleon

    • LabSolutions

  • Answered by AI

Tell us how to improve this page.

Interview Questions from Similar Companies

Cipla Interview Questions
4.1
 • 467 Interviews
Aurobindo Pharma Interview Questions
4.0
 • 230 Interviews
Biocon Limited Interview Questions
3.9
 • 146 Interviews
View all
Production Officer
15 salaries
unlock blur

₹1.5 L/yr - ₹3.6 L/yr

Officer
10 salaries
unlock blur

₹1.9 L/yr - ₹3.5 L/yr

Assistant Manager
9 salaries
unlock blur

₹6 L/yr - ₹10.3 L/yr

Executive Accountant
7 salaries
unlock blur

₹2.7 L/yr - ₹3 L/yr

Executive
7 salaries
unlock blur

₹5.5 L/yr - ₹7 L/yr

Explore more salaries
Compare Mehta Api with

Cipla

4.1
Compare

Sun Pharmaceutical Industries

4.1
Compare

DRJ & CO

5.0
Compare

Biocon Limited

3.9
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