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 82 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

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.

People are getting interviews through

based on 1 Clairvoyant India interview
Referral
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Clairvoyant India Data Analyst Salary
based on 8 salaries
₹8.1 L/yr - ₹9.5 L/yr
34% 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 & Benefits

5.0

Job Security

5.0

Company culture

5.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Software Engineer
134 salaries
unlock blur

₹4.1 L/yr - ₹15 L/yr

Senior Software Engineer
92 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

Software Engineer2
39 salaries
unlock blur

₹8.9 L/yr - ₹20 L/yr

Explore more salaries
Compare Clairvoyant India with

Fractal Analytics

4.0
Compare

Mu Sigma

2.7
Compare

Tiger Analytics

3.6
Compare

LatentView Analytics

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview