Optum Global Solutions Senior Data Analyst Interview Questions and Answers

Hacker rank test mostly on sql

Q1. Focused on Statistical analysis and sql. More sql questions on window functions
Add your answer
Q2. Sql joins and aggregation functions
Add your answer

Time vs money, time time time

Dsa, python sql etl ssis

Q1. What is clustering? And how do you check if a ML model is performing well?
Ans. 
Clustering is a machine learning technique used to group similar data points together. Model performance can be checked using evaluation metrics like silhouette score or inertia.
• Clustering is the process of dividing a set of data points into groups based on their similarities.

• Common clustering algorithms include K-means, hierarchical clustering, and DBSCAN.

• To check if a ML model is performing well, evaluation metrics l...read more
Answered by AI
Add your answer
Q2. Explain the difference between Arithmetic mean, Harmonic mean and Geometric mean?
Ans. 
Arithmetic mean is the sum of all values divided by the number of values. Harmonic mean is the reciprocal of the arithmetic mean of the reciprocals of the values. Geometric mean is the nth root of the product of n values.
• Arithmetic mean is most commonly used and is calculated by summing all values and dividing by the number of values.

• Harmonic mean is used when dealing with rates or ratios, and is calculated by taking t...read more
Answered by AI
Add your answer

Debugging,data analysis, coding,

Data analysis, debugging,coding