ICON Plc Record Management Specialist Interview Questions and Answers

Quantity, reasonning, English question and have coding

Questions related to quantitative aptitude , Logical reasoning , Data Interpretation and English Comprehension . The level of the questions asked will be moderate anyone can easily crack the interview test . But try to be good in any two of the above mentioned topic so that you can clear it easily,

Q1. Advance level sql and excel question will be asked first but they are only asked to check your knowledge even if you answer them correctly it won't guarantee you of getting placed . The main part of the in...read more
Add your answer
Q2. SQL : - Question related to advance level sql like windows function.
Add your answer
Q3. Excel :- Difference between vlookup and Index(Match)
Ans. 
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 wit...read more
Answered by AI
Add your answer

Sas coding test with good questions.

Q1. Unprofessional. Whole team was on audio only the interviewee was on video. Questions were more on your history rather than on technologies.
Add your answer
Q2. NO response from Hr afterwards.
Add your answer

Q1. Mostly Manager ask from the CV Overall Experience in CDM right from STUDY START UP TO CLOSE OUT ACTIVITIES, EDC TOOLS WORKED ON
Add your answer
Q2. Explain phases in CDM
Ans. 
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.
Answered by AI
Add your answer

Q1. SQL questions from beginner to advanced
Add your answer
Q2. Duplicates removal
Add your answer
Q3. Aggregate functions
Add your answer

The test was simple basic aptitude

Q1. Desribe your project
Ans. 
Developed a predictive model to forecast customer churn for a telecom company
• Used machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model accuracy

• Evaluated model performance using metrics like accuracy, precision, and recall
Answered by AI
Add your answer
Q2. Skills and related questions
Add your answer