IQVIA
TekPillar Interview Questions and Answers
Q1. Excel :- Difference between vlookup and Index(Match)
VLOOKUP searches for a value in the first column of a table and returns a corresponding value in the same row. INDEX/MATCH uses two functions to look up a value based on its position in a table.
VLOOKUP only searches for values in the first column of a table, while INDEX/MATCH can search for values in any column.
INDEX/MATCH is more flexible and efficient for large datasets.
VLOOKUP is easier to use for simple lookups with small datasets.
INDEX/MATCH can handle errors more effect...read more
Q2. What Is TMF and how many sections are available in etmf.
TMF stands for Trial Master File. eTMF has 8 sections including essential documents for clinical trials.
TMF stands for Trial Master File, which is a collection of essential documents for a clinical trial.
eTMF (electronic Trial Master File) typically has 8 sections including regulatory documents, study documents, and essential documents.
The 8 sections in eTMF are usually: Regulatory, Investigator, Ethics Committee, Study Management, Quality Management, Essential Documents, Oth...read more
Q3. Exlpain what is eTMF, phases of clinical trial.
eTMF stands for electronic Trial Master File. Phases of clinical trials include preclinical, phase 1, phase 2, phase 3, and phase 4.
eTMF is a digital version of the traditional Trial Master File, used to manage and store essential documents related to a clinical trial.
Phases of clinical trials include preclinical (testing on animals), phase 1 (testing on a small group of healthy volunteers), phase 2 (testing on a larger group of patients), phase 3 (testing on an even larger g...read more
Q4. What is current ctc
Current CTC refers to the current annual salary package of the candidate.
Current CTC is the total annual salary package including all components like base salary, bonuses, and benefits.
Candidates should be honest about their current CTC during interviews.
Employers ask for current CTC to understand the candidate's salary expectations and to assess their fit for the role.
Q5. What is FDA 1572
FDA 1572 is a form used in clinical trials to document the investigator's agreement to conduct the study in compliance with FDA regulations.
FDA Form 1572 is also known as the Statement of Investigator form.
It outlines the responsibilities of the investigator in conducting the clinical trial.
The form includes information about the investigator's qualifications, experience, and commitment to follow FDA regulations.
Signing the FDA 1572 form is a requirement for initiating a clin...read more
Q6. Explain phases in CDM
CDM stands for Common Data Model. It has three phases: Conceptualization, Design, and Maintenance.
Conceptualization phase involves understanding the data requirements and defining the scope of the project.
Design phase includes creating the data model, schema, and data flow diagrams.
Maintenance phase focuses on data quality, data integration, and ongoing updates to the data model.
Interview Process at TekPillar
Top Data Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month