Huron Rcm Analyst Interview Questions and Answers

Set of questions on english , aptitude , all are at easy level

Sql basics and some query questions

Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
Add your answer
Q2. Question on real life scenarios
Add your answer

Q1. Salary expectation
Add your answer
Q2. When can u join
Add your answer

Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join.
Add your answer
Q2. In Tableau if the underlining table columns keep on changing than what can be done so that it wont affect on the view level.
Ans. 
Create calculated fields in Tableau to dynamically adjust to changing table columns.
• Use calculated fields to reference specific columns by name instead of position.

• Utilize parameters to allow users to select which columns to display.

• Consider using custom SQL queries to dynamically adjust to changing table structure.
Answered by AI
Add your answer
Q3. Row level security
Add your answer
Q4. Tell me about your project
Ans. 
Developed a predictive model to forecast customer churn for a telecommunications company.
• Utilized machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model performance

• Collaborated with business stakeholders to understand key drivers of churn

• Achieved 85% accuracy in predicting customer churn
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join kpmg?
Add your answer
Q3. What you understand about the job?
Add your answer
Q4. What is your work experience?
Add your answer
Q5. How will you see yourself within 5 years?
Add your answer

Q1. Tell me about yourself ?
Add your answer
Q2. What are few major projects that you had in your work ?
Add your answer

Q1. Questions related to your work domain ?
Add your answer
Q2. Any software that you used (Although they will ask opposite of the software you have experience with)
Add your answer

Q1. Some OOPs questions
Add your answer
Q2. SQL Questions were asked basic sql
Add your answer
Q3. Project related questions
Add your answer

Q1. Basic introduction
Add your answer
Q2. Some basic hr questions
Add your answer

The aptitude test was interesting, Had a bunch of fun puzzles

Q1. Tell me about yourself
Ans. 
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
• Experienced in gathering and analyzing business requirements

• Skilled in creating data models and visualizations

• Proficient in using tools like SQL, Excel, and Tableau

• Strong communication and presentation skills

• Certified in business analysis (e.g. CBAP)
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Add your answer

It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.

Q1. What is the difference between where and having clause ?
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE co...read more
Answered by AI
Add your answer
Q2. One ques was a guesstimate problem.
Add your answer

Q1. Self Introduction.
Add your answer
Q2. Business case problem which was to be solved in 15 minutes.
Add your answer