Clearwater Analytics Reconciliation Analyst Interview Questions and Answers

General aptitude questions

Was given a topic and asked to talk about for 2 mins

Q1. Why LatentView?
Ans. 
LatentView offers a dynamic work environment with opportunities for growth and learning in the field of analytics.
• LatentView has a strong reputation in the analytics industry for delivering innovative solutions to clients.

• The company values continuous learning and development, providing employees with opportunities to enhance their skills.

• LatentView offers a collaborative work culture where employees can work on divers...read more
Answered by AI
Add your answer
Q2. What do you expect from us?
Ans. 
I expect a supportive work environment, opportunities for growth, and clear communication.
• Supportive work environment where I can collaborate with team members

• Opportunities for growth and advancement within the company

• Clear communication regarding expectations, feedback, and goals
Answered by AI
Add your answer

Basic coding questins

Q1. All based on my project
Add your answer

Aptitude test was easy, you can prepare it with online available resources

We were asked to complete few games which were related to logical thinking

It was a common topic and was 1 hour long

Q1. They asked basic sql question like joins, windows function, subqueries. Also they asked one guestimate and a case study. Guestimate- No. of IPhone stores in delhi Case study - How to increase the profit of...read more
Add your answer

There were 48 questions to be done in 60 minutes.
the platform used was below average.
about 1400 gave the test

The Next round was a GD.
about 250 were shortlisted.
it was held in groups of 10 - 13.
there were 2 Panelists observing the body language, the fluency and time you speak for.
It is very important that you either start or conclude the GD.
leaves a good impression.

Q1. Tell me about yourself
Add your answer
Q2. What is Data Analysis?
Ans. 
Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information.
• It involves collecting and organizing data

• It includes statistical analysis and visualization

• It helps in making informed decisions

• Examples include market research, financial analysis, and scientific research
Answered by AI
Add your answer
Q3. SQL Queries using Joins and sub-queries
Ans. 
SQL Queries using Joins and sub-queries
• Joins are used to combine rows from different tables based on a related column

• Sub-queries are queries nested within another query

• Joins and sub-queries can be used together to retrieve specific data from multiple tables
Answered by AI
View 1 more answer
Q4. Many questions about projects mentioned in the resume.
Add your answer
Q5. Estimation and probability questions were asked to see the way you approach a question logically.
Add your answer

Q1. Tell me about Yourself
Add your answer
Q2. Again Questions based on resumes
Add your answer
Q3. Some Regular HR Questions like why latent view, where to do you yourself in 5 years.....etc.
Add your answer
Q4. Any questions for me?
Add your answer

Aptitude test :Numerical,Logical and Behavioral

Group discussion - Conducted among 6-12 people

Q1. Introduction,Guesstimates & basic programming
Add your answer

Q1. Project explanation:Final year project
Add your answer

Q1. General HR discussion: Intro,Reasons for joining here
Add your answer

Prepare well on Python, SQL and be good at solving analytical problems

Q1. Mostly based on your resume, prepare to answer whatever you kept on resume. Still prepare well on Python, SQL... Go through AWS/Datawarehouse concepts if role is Data Engineering position
Add your answer

Q1. Lightly on Technical side, Mostly on testing how you're able to solve business problems
Add your answer