Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by CriticalRiver Team. If you also belong to the team, you can get access from here

CriticalRiver Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

CriticalRiver Data Analyst Interview Questions and Answers

Updated 13 Jun 2024

CriticalRiver Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 13 Jun 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jun 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Write a sql query for getting the highest salary from employee table
  • Ans. 

    SQL query to retrieve the highest salary from employee table

    • Use the MAX() function to get the highest salary

    • Select the salary column from the employee table

    • Group by the salary column if there are multiple employees with the same highest salary

  • Answered by AI
  • Q2. Data refresh options in tableau
  • Ans. 

    Tableau offers various data refresh options including extract refresh, live connection, and incremental refresh.

    • Tableau allows users to refresh data extracts manually or on a schedule.

    • Live connections enable real-time data updates directly from the data source.

    • Incremental refresh can be used to update only new or modified data since the last refresh.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - For Data analyst, prepare more on Tableau and SQL complex queries

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic aptitude questions, statics, probability etc

Round 2 - HR 

(2 Questions)

  • Q1. Where do you live in the USA
  • Ans. 

    I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.

    • I reside in the heart of Manhattan, surrounded by towering skyscrapers.

    • New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.

    • The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.

    • I enjoy exploring the diverse neighborhoods and ...

  • Answered by AI
  • Q2. Where do you see yourself in 5 years
  • Ans. 

    In 5 years, I see myself as a senior data analyst leading a team, utilizing advanced analytics to drive strategic decision-making.

    • Leading a team of data analysts

    • Utilizing advanced analytics techniques

    • Driving strategic decision-making

    • Continuously learning and staying updated with the latest trends in data analysis

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic aptitude and math skills are the key to success in the field of psychology and psychology in the field and in the field in
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Difference between Primary Key and Unique Key ?
  • Ans. 

    Primary key uniquely identifies each record in a table, while Unique key allows only unique values but can have null values.

    • Primary key enforces uniqueness and not null constraint on a column

    • Primary key can consist of multiple columns

    • Unique key allows only unique values but can have null values

    • Unique key can be applied to multiple columns as well

  • Answered by AI
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Common logical and reasoning questions and also has a pseudocode

Round 3 - Gamified and Essay writing 

(1 Question)

  • Q1. Gamified round with time limits and essay writing for the given picture
Round 4 - Technical 

(1 Question)

  • Q1. Asked about whatever you put in the resume and mainly focus on aptitude
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round is gaming round with 13 levels
And the aptitude with science, technical and non technical questions

Round 2 - HR 

(4 Questions)

  • Q1. General questions were asked Tell me about yourself And then technical he round with puzzles and aptitude to solve
  • Q2. Long term and short term goals
  • Q3. Strength and weakness
  • Q4. Puzzles and aptitude questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare yourself with general aptitude and puzzles
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Well designed to test the aptitude competence of the candidate.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Explanations for the answers given to the aptitude questions.
  • Q2. Questions from python.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare based on the JD.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - Aptitude Test 

Logical and aptitude test, game round

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on projects and logical questions

Data Analyst Interview Questions & Answers

Affine user image Vikranth Ravikanthi

posted on 16 Aug 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. SQL Questions on Aggregations

Data Analyst Interview Questions & Answers

Affine user image Sai Shreyas B.K

posted on 28 Sep 2024

Interview experience
4
Good
Difficulty level
Hard
Process Duration
-
Result
Not Selected

I appeared for an interview in Aug 2024.

Round 1 - Coding Test 

The sql questions were hard

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL and excel questions intermediate

CriticalRiver Interview FAQs

How many rounds are there in CriticalRiver Data Analyst interview?
CriticalRiver interview process usually has 1 rounds. The most common rounds in the CriticalRiver interview process are Technical.
How to prepare for CriticalRiver Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at CriticalRiver. The most common topics and skills that interviewers at CriticalRiver expect are Data Analysis, SQL, Python, Tableau and Basic.
What are the top questions asked in CriticalRiver Data Analyst interview?

Some of the top questions asked at the CriticalRiver Data Analyst interview -

  1. write a sql query for getting the highest salary from employee ta...read more
  2. Data refresh options in tabl...read more

Tell us how to improve this page.

CriticalRiver Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
CriticalRiver Data Analyst Salary
based on 5 salaries
₹3.5 L/yr - ₹12.8 L/yr
16% more than the average Data Analyst Salary in India
View more details

CriticalRiver Data Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

4.0

Salary

5.0

Job security

5.0

Company culture

3.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
117 salaries
unlock blur

₹1.2 L/yr - ₹7.9 L/yr

Senior Software Engineer
82 salaries
unlock blur

₹10 L/yr - ₹33 L/yr

Software Developer
27 salaries
unlock blur

₹3.5 L/yr - ₹13.4 L/yr

Technical Lead
27 salaries
unlock blur

₹19 L/yr - ₹33 L/yr

Salesforce Developer
16 salaries
unlock blur

₹2 L/yr - ₹7.7 L/yr

Explore more salaries
Compare CriticalRiver with

Maxgen Technologies

4.6
Compare

Value Point Systems

3.6
Compare

JoulestoWatts Business Solutions

2.9
Compare

F1 Info Solutions and Services

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview