Upload Button Icon Add office photos
Engaged Employer

i

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

Clairvoyant India Verified Tick

Compare button icon Compare button icon Compare
4.1

based on 83 Reviews

Filter interviews by

Clairvoyant India Data Analyst Interview Questions and Answers

Updated 8 Nov 2024

Clairvoyant India Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 8 Nov 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Top N Analysis Queries

Data Analyst Interview Questions & Answers

user image Prashant Dahiya

posted on 5 Mar 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. 1h technical interview, Python Basic, SQL Intermediate.
Round 2 - Technical 

(1 Question)

  • Q1. 1h technical, SQL Advanced, Python Intermediate, PySpark Basic
Round 3 - One-on-one 

(1 Question)

  • Q1. 30 min HR Interview

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate ProblemGiven an array/list of integer numbers 'CHOCOLAT ... read more
asked in Wipro
Q3. Ninja and substringsNinja has been given a string 'STR' containin ... read more
Q4. Maximum In Sliding Windows Of Size KGiven an array/list of intege ... read more
asked in Tredence
Q5. First Repeated CharacterYou are given a string 'STR' of lowercase ... read more

Data Analyst Jobs at Clairvoyant India

View all

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. What is the difference between working from home and working from the office, and what are the benefits of each?
  • Ans. 

    Working from home offers flexibility and comfort, while working from the office provides structure and social interaction.

    • Working from home allows for flexibility in schedule and eliminates commute time.

    • Working from the office provides a structured environment and opportunities for in-person collaboration.

    • Benefits of working from home include increased productivity and work-life balance.

    • Benefits of working from the off...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. All Programing ques

Interview Preparation Tips

Interview preparation tips for other job seekers - I recommend checking the reviews of the company before applying for the job.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Self Introduction
  • Q2. Salary Expectation
Round 2 - Technical 

(1 Question)

  • Q1. 14 questions in excel formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - To prepare Excel Formulas and Hlookup,vlookup and etc....

I applied via Naukri.com and was interviewed in Nov 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Python pandas sql just be thorough abt this
  • Q2. Be confident they dont ask much difficult medium to easy level questions only

Interview Preparation Tips

Interview preparation tips for other job seekers - Be on time interviewer are very good here

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Complex sql scenarios and their results
  • Ans. 

    Complex SQL scenarios and their results

    • Using subqueries to filter data

    • Joining multiple tables with complex conditions

    • Using window functions to calculate running totals

    • Pivoting data to transform rows into columns

    • Using recursive queries to traverse hierarchical data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
-
Result
Not Selected

I was interviewed in Nov 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Azure data engineering basic questions
Round 2 - Technical 

(1 Question)

  • Q1. Scenario based coding questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Assignment 

Object Detection on a subset of COCO dataset having Cars and Person classes

Round 2 - Technical 

(1 Question)

  • Q1. Technical discussion on Machine Learning, Deep Learning Concepts and coding round.
Round 3 - Technical 

(1 Question)

  • Q1. Technical discussion on Deep Learning and Computer Vision.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Company Website and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL related basic theory questions
  • Q2. SQL coding test

Interview Preparation Tips

Topics to prepare for Equifax Senior Data Analyst interview:
  • SQL

Data Engineer Interview Questions & Answers

DISYS user image Srinivasa moorthy

posted on 29 Feb 2024

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

(1 Question)

  • Q1. Explain process in adf
  • Ans. 

    ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.

    • ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

    • You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.

    • ADF supports a wide range of d...

  • Answered by AI

Skills evaluated in this interview

Clairvoyant India Interview FAQs

How many rounds are there in Clairvoyant India Data Analyst interview?
Clairvoyant India interview process usually has 2 rounds. The most common rounds in the Clairvoyant India interview process are Technical and One-on-one Round.
How to prepare for Clairvoyant India 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 Clairvoyant India. The most common topics and skills that interviewers at Clairvoyant India expect are Python, SQL, Analytical, Data Analysis and Data Quality.
What are the top questions asked in Clairvoyant India Data Analyst interview?

Some of the top questions asked at the Clairvoyant India Data Analyst interview -

  1. 1h technical interview, Python Basic, SQL Intermedia...read more
  2. 1h technical, SQL Advanced, Python Intermediate, PySpark Ba...read more
  3. Top N Analysis Quer...read more

Tell us how to improve this page.

Clairvoyant India Data Analyst Salary
based on 8 salaries
₹8.1 L/yr - ₹9.5 L/yr
35% more than the average Data Analyst Salary in India
View more details

Clairvoyant India Data Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Data Analyst

Hyderabad / Secunderabad,

Pune

+1

4-9 Yrs

Not Disclosed

Explore more jobs
Software Engineer
134 salaries
unlock blur

₹4.1 L/yr - ₹15 L/yr

Senior Software Engineer
93 salaries
unlock blur

₹12.2 L/yr - ₹28.5 L/yr

Lead Software Engineer
45 salaries
unlock blur

₹15 L/yr - ₹37.7 L/yr

Data Engineer
41 salaries
unlock blur

₹4.8 L/yr - ₹19.2 L/yr

Associate Software Engineer
39 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Explore more salaries
Compare Clairvoyant India with

Fractal Analytics

4.0
Compare

Mu Sigma

2.7
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

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