Upload Button Icon Add office photos

IQVIA

Compare button icon Compare button icon Compare

Filter interviews by

IQVIA BI Data Warehouse Developer Interview Questions and Answers

Updated 6 Sep 2024

IQVIA BI Data Warehouse Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(4 Questions)

  • Q1. Clustering keys
  • Q2. Micro partition
  • Q3. Time travel implementation
  • Ans. 

    Time travel implementation involves storing historical data in a data warehouse for analysis and reporting.

    • Implement slowly changing dimensions to track changes over time

    • Use effective date ranges to capture when data was valid

    • Consider using snapshot tables to store historical data at specific points in time

  • Answered by AI
  • Q4. Materialized view

Skills evaluated in this interview

Interview questions from similar companies

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

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

Round 1 - Technical 

(3 Questions)

  • Q1. Anagram of two strings in java
  • Ans. 

    Java program to check if two strings are anagrams

    • Create a function that takes two strings as input

    • Convert both strings to character arrays and sort them

    • Check if the sorted arrays are equal to determine if they are anagrams

  • Answered by AI
  • Q2. Insert and select query in MySQL
  • Ans. 

    Insert and select data in MySQL using SQL queries

    • Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...); to insert data

    • Use SELECT * FROM table_name; to select all data from a table

    • Use SELECT column1, column2 FROM table_name WHERE condition; to select specific data based on a condition

  • Answered by AI
  • Q3. Get and Post APIs in rest
  • Ans. 

    GET and POST are HTTP methods used in REST APIs for retrieving and sending data.

    • GET method is used to retrieve data from a server

    • POST method is used to send data to a server

    • GET requests are idempotent, while POST requests are not

    • GET requests should only be used for retrieving data, not for modifying data

    • Example: GET request to retrieve a list of users - GET /users

    • Example: POST request to create a new user - POST /users

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was technical round and there were three panelists. Started with alot of database questions and core java question. Prepare well about your project working in the company. I couldn't clear this round recieved rejection mail after two weeks.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Feb 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Why pharmacy job not ava

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview can done by video call, conference call &skype.

Data Analyst Interview Questions & Answers

ICON Plc user image Vidyesh Poornima

posted on 13 Sep 2024

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

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

Round 1 - Aptitude Test 

General aptitude along with reasoning

Round 2 - Technical 

(2 Questions)

  • Q1. Basic question on your projet in the previous organisations
  • Q2. Behavioral questions
Round 3 - HR 

(1 Question)

  • Q1. General HR discussion and negotiating salary

Interview Preparation Tips

Interview preparation tips for other job seekers - Great company to work with lot of benefits and perks
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Nov 2023. 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 

They send an mail which have the link about assessment test

Round 3 - Group Discussion 

In hall all are discussed and written an interview test

Round 4 - HR 

(1 Question)

  • Q1. Self details, antidiabetis drugs,project ,ect

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't too panic on the point of interview...good karma on his way..🙌

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

Interview Questionnaire 

2 Questions

  • Q1. What is pharmacovigilance?
  • Q2. Which programing languages do you know?
  • Ans. 

    I know Python, R, SQL, and Java.

    • Python

    • R

    • SQL

    • Java

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Due to corona crises most companies prefer for telephonic interview. But when company reach student on phone call then their may be chance that student may not well prepared to face questions. And most of companies call students without notificaton. So student should be aware of basic knowledge of pharmacovigilance, clinical trials and offcourse the communication tricks. If student can manage this, then the possibility of getting selected increase. All the best.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Quantity, reasonning, English question and have coding

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Explain yourself
  • Ans. 

    I am a dedicated and experienced consultant with a strong background in problem-solving and client management.

    • Over 5 years of experience in consulting roles

    • Skilled in analyzing data and providing strategic recommendations

    • Excellent communication and interpersonal skills

    • Proven track record of successfully managing client relationships

    • Strong ability to work under pressure and meet deadlines

  • Answered by AI

Interview Questionnaire 

1 Question

  • Q1. Related to Pharmacovigilance terms

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

Interview Questionnaire 

1 Question

  • Q1. Basic of ICSR

Interview Preparation Tips

Interview preparation tips for other job seekers - Confidence and Basic of ICSR

IQVIA Interview FAQs

How many rounds are there in IQVIA BI Data Warehouse Developer interview?
IQVIA interview process usually has 1 rounds. The most common rounds in the IQVIA interview process are Technical.
What are the top questions asked in IQVIA BI Data Warehouse Developer interview?

Some of the top questions asked at the IQVIA BI Data Warehouse Developer interview -

  1. Time travel implementat...read more
  2. Clustering k...read more
  3. Micro partit...read more

Tell us how to improve this page.

IQVIA BI Data Warehouse Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

ICON Plc Interview Questions
4.1
 • 75 Interviews
Syneos Health Interview Questions
3.8
 • 46 Interviews
Equinox Labs Interview Questions
3.8
 • 34 Interviews
View all
Associate Consultant
1.1k salaries
unlock blur

₹5 L/yr - ₹19.1 L/yr

Consultant
1.1k salaries
unlock blur

₹8.5 L/yr - ₹30 L/yr

Clinical Data Specialist
779 salaries
unlock blur

₹3.5 L/yr - ₹11.5 L/yr

Drug Safety Associate
744 salaries
unlock blur

₹2 L/yr - ₹8.5 L/yr

Software Developer
740 salaries
unlock blur

₹4.8 L/yr - ₹19 L/yr

Explore more salaries
Compare IQVIA with

Syngene International

3.9
Compare

Aragen Life Sciences

4.0
Compare

SAI Life Sciences

3.9
Compare

Parexel International

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