Medsol India Overseas Interview Questions and Answers

Q1. Self intro and project architecture
Add your answer
Q2. What are the data sources used?
Add your answer
Q3. Bigquery architecture
Add your answer
Q4. Partition vs clustering
Add your answer
Q5. Bq commands on create table and load csv file
Add your answer
Q6. Bq commands on show the schema of the table
Add your answer
Q7. Explain about leaf nodes and columnar storage.
Add your answer
Q8. How many slots are there in bigquery?
Add your answer

Q1. Can you describe your experience and provide details about your job role?
Add your answer
Q2. What is your desired location for work, and what is your availability?
Add your answer

Q1. Education gaps and study gaps. Education history and work experience history
Add your answer
Q2. Work history and education history
Add your answer

Q1. I am interested for jobs Data Entry operator
Add your answer
Q2. How is possible google for my jobs I am very happy Thanksgiving
Add your answer
Q3. I needed for this job
Add your answer

Q1. 8 years Experience working from Data Entry operator
Add your answer
Q2. BNMU Madhepura District
Add your answer

Q1. About your self
Add your answer
Q2. About birth place
Add your answer
Q3. About your dream day
Add your answer
Q4. About your dream place
Add your answer
Q5. How to spent every day
Add your answer

Q1. What is correlation and parameterization?
Ans. 
Correlation is the process of extracting dynamic values from server responses and passing them to subsequent requests. Parameterization is the process of replacing hard-coded values in scripts with variables.
• Correlation involves identifying and capturing dynamic values like session IDs or tokens from server responses.

• Parameterization involves replacing hard-coded values in scripts with variables to make them reusable a...read more
Answered by AI
Add your answer
Q2. Explain load, stress, all testing?
Ans. 
Load testing is to test the system under normal and peak load conditions, stress testing is to test the system beyond its limits, and all testing is a combination of both.
• Load testing checks the system's ability to handle expected load levels, ensuring performance under normal conditions.

• Stress testing pushes the system beyond its limits to identify breaking points and measure performance degradation.

• All testing combin...read more
Answered by AI
Add your answer
Q3. Explain PTLC?
Ans. 
PTLC stands for Performance Testing Life Cycle, which is a set of activities involved in the performance testing process.
• PTLC involves planning, preparation, execution, analysis, and reporting of performance tests.

• It includes defining performance goals, creating test scenarios, setting up test environments, running tests, analyzing results, and making recommendations.

• Example: In PTLC, performance engineers work closely...read more
Answered by AI
Add your answer
Q4. Loadrunner scripting, execution and reports issue faced and how to process?
Ans. 
Issues faced in Loadrunner scripting, execution, and reports
• Scripting: faced issues with correlation, parameterization, and dynamic data handling

• Execution: encountered problems with test environment setup, resource constraints, and test data management

• Reports: struggled with result analysis, performance bottlenecks identification, and report customization
Answered by AI
Add your answer
Q5. LG calculation and workload modelling process?
Ans. 
LG calculation and workload modelling process involves determining the number of Load Generators required and creating a realistic simulation of user behavior.
• Calculate the number of Load Generators needed based on expected user load and performance goals.

• Create workload models by analyzing user behavior patterns, transaction volumes, and system usage.

• Consider factors like peak load times, user distribution, and transa...read more
Answered by AI
Add your answer
Q6. NFR scenarios?
Ans. 
NFR scenarios refer to non-functional requirements that define the quality attributes of a system.
• NFR scenarios focus on aspects like performance, scalability, reliability, and security.

• Examples include load testing to assess system performance under expected load, stress testing to evaluate system behavior under extreme conditions, and security testing to identify vulnerabilities.

• NFR scenarios help ensure that the sys...read more
Answered by AI
Add your answer

Q1. Loadrunner questions
Add your answer

Q1. Check your soft skills
Add your answer

Q1. Complete your details
Add your answer

A case study in an Optum interview typically revolves around solving a real-world problem related to healthcare, data analysis, technology, or business strategy, given Optum’s focus on healthcare services and technology solutions. Here are some tips on how to approach a case study interview at Optum and a sample example:

Steps to Approach an Optum Case Study:

1. Understand the Problem Statement:

Take time to read the case study carefully and make sure you understand the key issue or question.

Identify the stakeholders involved (patients, healthcare providers, insurance companies, etc.) and the objective (cost reduction, improving patient outcomes, increasing efficiency, etc.).



2. Clarify Assumptions:

If there are any ambiguous elements, ask questions to clarify the problem.

You can also state your assumptions if you're making any, but be clear that these are assumptions.



3. Break Down the Problem:

Identify key data points you would need to analyze.

Break the problem into smaller pieces that can be addressed step-by-step.



4. Analyze:

Use frameworks like SWOT analysis, PESTLE analysis, or Porter’s Five Forces if applicable to the case.

In case of a data-related problem, try to identify key metrics (such as patient satisfaction, cost, quality of care, etc.) and how they can be improved or measured.

For technology-related cases, consider aspects like scalability, security, user experience, and integration with existing systems.



5. Propose a Solution:

Present your findings logically and suggest a solution based on your analysis.

Make sure to consider both short-term and long-term impacts on patient

Q1. When interviewing with Optum, you can expect a mix of technical, behavioral, and situational questions, especially considering their focus on healthcare services, technology, and data analysis. Here are so...read more
Add your answer
Q2. Done
Add your answer

Computer typing should be 40 wpm. And optional question answer multiple choice questions