AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clearwater Analytics Data Research Analyst Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Anonymous
I applied via Referral and was interviewed before Apr 2021. There were 3 interview rounds.
(3 Questions)
- Q1. Why are you looking for a change?
- Q2. Tell me about yourself.
- Q3. Why should we hire you?
Basic sql
(1 Question)
- Q1. Project manager round
Interview Preparation Tips
I applied via Referral and was interviewed before Jan 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Technical round: sql questions on joins, aggregate functions, window functions etc.
Interview Preparation Tips
Preparing answers around these LPs will help you both in converting the interviews as well as during internal movement.
I applied via Approached by Company and was interviewed before Jul 2021. There were 3 interview rounds.
(1 Question)
- Q1. It would be a short listing process to check if you fit the role
(1 Question)
- Q1. Questions would be based on the LP’s
(1 Question)
- Q1. Leadership principles
Interview Preparation Tips
Interview Questionnaire
5 Questions
- Q1. What is interview?
- Ans.
An interview is a formal conversation between an employer and a job candidate to assess their suitability for a role.
Interviews are used to evaluate a candidate's skills, experience, and personality.
They can be conducted in person, over the phone, or via video conferencing.
Interviews typically involve a series of questions and may include assessments or tests.
Examples of common interview questions include 'Tell me abou
- Q2. If you selected by the interviewers then firstly what you will do?
- Q3. Before interview what type of stress loaded on your brain?
- Q4. Ehat you will do with your first selary?
- Ans.
I plan to save a portion, invest in professional development, and treat myself to a small reward.
Save a portion of the salary for future financial goals
Invest in professional development such as courses or certifications
Treat myself to a small reward or experience as a form of celebration
- Q5. When you join your first day at job then what is your responsibility.
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Pivot and excel questions
- Q2. All about excel
Interview Preparation Tips
I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. About personality
Interview Preparation Tips
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. SQL, Business cases
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(3 Questions)
- Q1. Difference Between Rank and Dense Rank
- Ans.
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
Rank does not skip ranks when there are ties, while Dense Rank does
Rank will have gaps in ranks if there are ties, while Dense Rank will not
Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
- Q2. Some Basic Joins
- Q3. Socks Pair Puzzle Qustions
Interview Preparation Tips
I applied via Company Website and was interviewed in Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Questions mostly focused on window functions like row_number and aggregate functions like group by there was also a question based on self-join.
Interview Preparation Tips
- SQL
- Window functions
- joins
I applied via Company Website and was interviewed in Jan 2024. There were 2 interview rounds.
SQL and Python Questions
(1 Question)
- Q1. SQL and case study question
Tell us how to improve this page.
Clearwater Analytics Interviews By Designations
- Clearwater Analytics Reconciliation Analyst Interview Questions
- Clearwater Analytics Implementation Analyst Interview Questions
- Clearwater Analytics Software Engineer Interview Questions
- Clearwater Analytics Software Developer Interview Questions
- Clearwater Analytics Senior Associate Interview Questions
- Clearwater Analytics Software Development Engineer Interview Questions
- Clearwater Analytics Financial Data Analyst Interview Questions
- Clearwater Analytics Process Specialist SME Interview Questions
- Show more
Interview Questions for Popular Designations
- Research Associate Interview Questions
- Research Analyst Interview Questions
- Research and Development Interview Questions
- Senior Research Associate Interview Questions
- Research Scientist Interview Questions
- Researcher Interview Questions
- Research Intern Interview Questions
- Clinical Research Coordinator Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Reconciliation Analyst
95
salaries
|  ₹4 L/yr - ₹8.5 L/yr |
|
Software Development Engineer
67
salaries
| ₹6.5 L/yr - ₹25 L/yr |
|
Senior Software Development Engineer
30
salaries
| ₹25 L/yr - ₹58 L/yr |
|
Software Development Engineer II
30
salaries
| ₹11 L/yr - ₹20 L/yr |
|
Financial Data Analyst
26
salaries
| ₹4 L/yr - ₹8 L/yr |
Amazon
Uber
Fareportal
OLX
- Home >
- Interviews >
- Clearwater Analytics Interview Questions >
- Clearwater Analytics Data Research Analyst Interview Questions
