Upload Button Icon Add office photos

Filter interviews by

MDC PHARMACEUTICALS HR Executive Recruiter Interview Questions and Answers

Updated 30 Aug 2024

MDC PHARMACEUTICALS HR Executive Recruiter Interview Experiences

1 interview found

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 before Aug 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Tell me about ur self Family family About my experience What suppose to handle ..... Etc......
Round 2 - One-on-one 

(1 Question)

  • Q1. Tell me about ur self Family background About my experience Which work suppose to handle

Interview questions from similar companies

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

Interview Questionnaire 

2 Questions

  • Q1. Object Oriented Concepts and basic list/tuple/dictionary/ datetime conversion
  • Q2. Project done in last company and how will you help Saama?

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to frame answers end to end and stick to what you have done. Don't try to exaggerate.

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Complex sql scenarios and their results
  • Ans. 

    Complex SQL scenarios and their results

    • Using subqueries to filter data

    • Joining multiple tables with complex conditions

    • Using window functions to calculate running totals

    • Pivoting data to transform rows into columns

    • Using recursive queries to traverse hierarchical data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

I applied via Referral and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Coding Test 

If you are a fresher , then this is for you else almost no coding test for experienced candidates.

Round 2 - One-on-one 

(1 Question)

  • Q1. Javascript basics, Angular react general questions depends upon profile.
Round 3 - Behavioral 

(1 Question)

  • Q1. They asked general questions related to some hectic situation faced in previous company / project..

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm . Clear your basics . That's it.

I applied via Walk-in and was interviewed before Mar 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude test

Round 2 - Group Discussion 

Current affairs

Round 3 - Technical 

(1 Question)

  • Q1. Puzzle , sql related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself, whatever you know just be confident
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
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
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
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - One-on-one 

(4 Questions)

  • Q1. Why should we hire you?
  • Q2. What does your previous colleagues describe you?
  • Q3. Self introduction
  • Q4. General questions from resume

Interview Preparation Tips

Interview preparation tips for other job seekers - be well prepared for the experiences and behavioral questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Coding Test 

2/3 coding questions+technical questions on dbms,os,cn

Round 2 - Interview 

(1 Question)

  • Q1. Its much about managerial related to project kept in resume and some basic tech questions on skills kept in resume
Round 3 - HR 

(1 Question)

  • Q1. Behavioural questions and few questions on project

MDC PHARMACEUTICALS Interview FAQs

How many rounds are there in MDC PHARMACEUTICALS HR Executive Recruiter interview?
MDC PHARMACEUTICALS interview process usually has 2 rounds. The most common rounds in the MDC PHARMACEUTICALS interview process are HR and One-on-one Round.

Tell us how to improve this page.

MDC PHARMACEUTICALS HR Executive Recruiter Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

ZoomRx Interview Questions
3.1
 • 36 Interviews
Air Liquide Interview Questions
3.7
 • 24 Interviews
View all
Sales Coordinator
5 salaries
unlock blur

₹1.6 L/yr - ₹3 L/yr

Executive Accountant
4 salaries
unlock blur

₹2.6 L/yr - ₹3 L/yr

Medical Representative
3 salaries
unlock blur

₹1.8 L/yr - ₹3.6 L/yr

QC Chemist
3 salaries
unlock blur

₹1 L/yr - ₹1.4 L/yr

Explore more salaries
Compare MDC PHARMACEUTICALS with

Becton Dickinson

4.0
Compare

Vidal Health Insurance

3.7
Compare

Vidal Health Tpa

3.5
Compare

Saama Technologies

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