Eversana Senior Consultant Interview Questions and Answers for Experienced

Q1. SQL related - Joins, Range, Limits
Add your answer
Q2. .Net related - syntax, basic programs
Add your answer

Q1. Previous experience
Add your answer
Q2. Comfortability with shifts
Add your answer

Q1. What is SCD and types of SCD
Ans. 
SCD refers to Slowly Changing Dimensions in data warehousing, managing changes in data over time.
• Type 0: Passive - No changes are made to the existing data. Example: Historical data remains unchanged.

• Type 1: Overwrite - Old data is replaced with new data. Example: Correcting a misspelled name.

• Type 2: Add New Row - A new record is created for changes, preserving history. Example: Tracking changes in customer addresses.

• T...read more
Answered by AI
Add your answer
Q2. SQL query for join
Ans. 
SQL joins combine rows from two or more tables based on related columns.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the left ...read more
Answered by AI
Add your answer
Q3. What is MDM
Ans. 
MDM stands for Master Data Management, a process for managing critical data across an organization.
• Ensures consistency and accuracy of key business data across systems.

• Involves data governance, data quality, and data integration.

• Examples include managing customer, product, and supplier data.

• Helps in decision-making by providing a single source of truth.
Answered by AI
Add your answer

Q1. Share your difficult situation?
Ans. 
I faced a difficult situation when a critical project deadline was approaching and we encountered unexpected technical issues.
• Technical issues arose during a critical project

• Deadline was approaching

• Had to find quick solutions to resolve the issues

• Coordinated with team members to troubleshoot and fix the problems

• Implemented contingency plans to ensure project completion on time
Answered by AI
Add your answer

Q1. Az values and principles. And Jab related questions
Add your answer

Resume round that mainly focused on relevant projects

Q1. Why are you looking for a switch?
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for new challenges and opportunities to expand my skills

• Interested in working with a different client base or industry

• Seeking a more collaborative team environment

• Want to take on more leadership responsibilities
Answered by AI
Add your answer
Q2. Why switching to Eli Lilly?
Add your answer

Q1. How to evaluate classification model.
Ans. 
Evaluation of a classification model involves assessing its performance and accuracy.
• Calculate accuracy, precision, recall, and F1 score

• Use confusion matrix to analyze true positives, true negatives, false positives, and false negatives

• Consider ROC curve and AUC to measure model's ability to distinguish between classes

• Cross-validation and train-test split can be used to validate the model's performance

• Compare the model
Answered by AI
Add your answer
Q2. What is list comprehension?
Ans. 
List comprehension is a concise way to create lists in Python by combining loops and conditional statements.
• List comprehension is written inside square brackets []

• It consists of an expression followed by a for loop and optional if statements

• It can be used to create new lists, filter existing lists, or transform elements in a list

• Example: squares = [x**2 for x in range(1, 6)]

• Example: evens = [x for x in range(1, 11) if
Answered by AI
Add your answer

Q1. How you fit for this position
Add your answer
Q2. What is your strength
Add your answer

Q1. What is salary expectaton
Add your answer

Q1. Business related questions based on CV
Add your answer
Q2. What are your aspirations for the role?
Ans. 
My aspiration for the role is to utilize my expertise to drive impactful change and deliver exceptional results for clients.
• To leverage my skills and experience to provide valuable insights and recommendations to clients

• To collaborate with team members to develop innovative solutions to complex problems

• To continuously learn and grow professionally in order to stay ahead in the consulting industry
Answered by AI
Add your answer

Q1. Question on data pipeline and server technology
Add your answer
Q2. Activities and ADF
Add your answer

Business case about increasing market share

Q1. Why this role and this company
Add your answer
Q2. Tell me about a time you failed and what did you learn from it?
Add your answer