Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
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 87 Reviews

Filter interviews by

Clairvoyant India Interview Questions and Answers

Updated 8 Nov 2024

Clairvoyant India Interview Experiences

Popular Designations

6 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
    • Add your answer

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

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.
    • Add your answer
Round 2 - Technical 

(1 Question)

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

(1 Question)

  • Q1. 30 min HR Interview
    • Add your answer

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Software Engineer II Interview Questions & Answers

user image Anonymous

posted on 7 Sep 2022

I applied via Recruitment Consulltant and was interviewed in Aug 2022. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on Hive, SQL, python
    • Add your answer
Round 2 - Technical 

(1 Question)

  • Q1. Spark transformations and its applications, scenario based SQL question, Python
    • Add your answer
Round 3 - HR 

(1 Question)

  • Q1. Why you want to join Clairvoyant
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - I was taken for SE II as data engineer. The person has to well versed with SQL and may they require to implement same on spark.

Software Engineer II Interview Questions asked at other Companies

Q1. There are fifteen horses and a racing track that can run five horses at a time. You have to figure out the top 3 horses out of those and you don't have any timer machine to measure. How will you find the top 3 horses?
View answer (2)

Senior Software Engineer Interview Questions & Answers

user image Anonymous

posted on 14 Feb 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Feb 2022. There were 3 interview rounds.

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 - Coding Test 

Basic oops concepts in python programming

Round 3 - Technical 

(2 Questions)

  • Q1. More questions on spark performance tuning and hive partitioning and buketing.
    • Add your answer
  • Q2. Spark dataframe coding
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for Spark and python OOPS concepts and any of the cloud offering.

Senior Software Engineer Interview Questions asked at other Companies

Q1. Tell me about yourself. What technology are you using? What is a Collection? What are the different types of collection there? What is the difference between ArrayList and LinkedList What are the basic building blocks of Stream operators, s... read more
View answer (2)

Clairvoyant India interview questions for popular designations

 Data Analyst

 (2)

 Senior Software Engineer

 (1)

 Software Engineer II

 (1)

 Developer

 (1)

 Associate Software Engineer

 (1)

Associate Software Engineer Interview Questions & Answers

user image Anonymous

posted on 4 Jan 2021

Interview Questionnaire 

1 Question

  • Q1. Basic Java Questions like method overloading and overriding. Basic programs like currency count.
    • Add your answer

Associate Software Engineer Interview Questions asked at other Companies

Q1. Triplets with Given Sum Problem Given an array or list ARR consisting of N integers, your task is to identify all distinct triplets within the array that sum up to a specified number K. Explanation: A triplet is a set {ARR[i], ARR[j], ARR[k... read more
View answer (2)

Developer Interview Questions & Answers

user image Anonymous

posted on 13 Aug 2019

I applied via Referral and was interviewed in Jul 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Core java (collection), logical questions , caching . Hibernate general .
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - They conducted three rounds of interview on three different dates. after first interview they said I am selected and they will just have another client round but later they conducted two more rounds . said that I never received any reply on my interview result . after my third interview when I reached out for the result(yes you have to call and ask) I got to know the person who took my interview went on two weeks of leave with out sharing the result and they cannot disturb the person on leave for the interview result he/she conducted. So after a month I never received any communication at all

Developer Interview Questions asked at other Companies

Q1. Which programming language do you use regular in work
View answer (2)

Jobs at Clairvoyant India

View all

Top trending discussions

View All
Interview Tips & Stories
2w (edited)
timepasstiwari
·
A Digital Markter
Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question
So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..
Got a question about Clairvoyant India?
Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Saama Technologies user image Anonymous

posted on 30 Jan 2022

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
    Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Futurism Technologies user image Anonymous

posted on 12 Dec 2024

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
    Add your answer
Round 2 - Technical 

(1 Question)

  • Q1. All Programing ques
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - I recommend checking the reviews of the company before applying for the job.

Data Analyst Interview Questions & Answers

VDart user image Anonymous

posted on 24 Jul 2024

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
    • Add your answer
  • Q2. Salary Expectation
    • Add your answer
Round 2 - Technical 

(1 Question)

  • Q1. 14 questions in excel formulas
    • Add your answer

Interview Preparation Tips

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

Consultant Interview Questions & Answers

SAS user image Anonymous

posted on 15 Sep 2022

I applied via Referral and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Moderate difficult with business reasoning

Round 2 - Technical 

(1 Question)

  • Q1. Prior work Ex mostly and a case study
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Know SAS products and it's implementation use cases in detail with statistical knowledge
More about working at Clairvoyant India

Clairvoyant India Interview FAQs

How many rounds are there in Clairvoyant India interview?
Clairvoyant India interview process usually has 2-3 rounds. The most common rounds in the Clairvoyant India interview process are Technical, Coding Test and One-on-one Round.
How to prepare for Clairvoyant India 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, Spark, Java and AWS.
What are the top questions asked in Clairvoyant India interview?

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

  1. Basic Java Questions like method overloading and overriding. Basic programs lik...read more
  2. More questions on spark performance tuning and hive partitioning and buketi...read more
  3. core java (collection), logical questions , caching . Hibernate general...read more

Tell us how to improve this page.

Clairvoyant India Interviews By Designations

Interview Questions for Popular Designations

Clairvoyant India Interview Process

based on 7 interviews

Interview experience

3.7
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 205 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
LatentView Analytics Interview Questions
3.7
 • 62 Interviews
Sigmoid Interview Questions
3.3
 • 59 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
Algonomy Interview Questions
4.1
 • 9 Interviews
Bridgei2i Analytics Solutions Interview Questions
3.8
 • 8 Interviews
Analytic Edge Interview Questions
3.1
 • 6 Interviews
View all

Clairvoyant India Reviews and Ratings

based on 87 reviews

4.1/5

Rating in categories

4.1

Skill development

4.1

Work-life balance

4.0

Salary

3.8

Job security

4.0

Company culture

3.7

Promotions

4.0

Work satisfaction

Explore 87 Reviews and Ratings
Jobs at Clairvoyant India
Senior Data Engineer

Pune

8-13 Yrs

₹ 20-35 LPA

Lead Data Engineer

Bangalore / Bengaluru

8-11 Yrs

Not Disclosed

Fullstack Engineer - AWS & Python

Bangalore / Bengaluru

8-10 Yrs

₹ 27.5-30 LPA

Explore more jobs
Clairvoyant India Salaries in India
Software Engineer
131 salaries
unlock blur

₹3.5 L/yr - ₹12.2 L/yr

Senior Software Engineer
93 salaries
unlock blur

₹10.8 L/yr - ₹28.2 L/yr

Lead Software Engineer
45 salaries
unlock blur

₹15 L/yr - ₹37.7 L/yr

Data Engineer
42 salaries
unlock blur

₹7.8 L/yr - ₹22.8 L/yr

Associate Software Engineer
39 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Explore more salaries
Compare Clairvoyant India with

Saama Technologies

3.7
Compare

DISYS

3.0
Compare

Data-Core Systems

3.2
Compare

Arvato

3.5
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview