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

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

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

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)

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
Round 2 - Technical 

(1 Question)

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

(1 Question)

  • Q1. Why you want to join Clairvoyant

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)
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.
  • Q2. Spark dataframe coding

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)

Interview Questionnaire 

1 Question

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

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 .

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

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.

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
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 Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is MVC architecture?, What is partial view in MVC , state purpose of it & how to define it? , Prepare SQL query
  • Ans. 

    MVC is a software architecture pattern that separates an application into three interconnected components: Model, View, and Controller.

    • MVC stands for Model-View-Controller

    • Model represents the data and business logic

    • View represents the user interface

    • Controller handles user input and updates the model and view accordingly

    • Partial view is a reusable view component that can be rendered within another view

    • It is used to reduc...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic things, focus on concepts

Skills evaluated in this interview

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, HR and Resume Shortlist.
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 Interview Process

based on 7 interviews

Interview experience

3.7
  
Good
View more

Interview Questions from Similar Companies

Equifax Interview Questions
3.3
 • 32 Interviews
VDart Interview Questions
4.0
 • 29 Interviews
DISYS Interview Questions
3.0
 • 27 Interviews
EagleView Interview Questions
3.3
 • 20 Interviews
Apptio Interview Questions
3.9
 • 19 Interviews
SAS Interview Questions
4.3
 • 19 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
EHR Consultant (EPIC Specialist)

Pune,

Gurgaon / Gurugram

+1

5-9 Yrs

Not Disclosed

Qa Engineer

Pune

5-8 Yrs

Not Disclosed

Lead Data Engineer

Pune,

Gurgaon / Gurugram

9-14 Yrs

Not Disclosed

Explore more jobs
Software Engineer
131 salaries
unlock blur

₹3.5 L/yr - ₹12.2 L/yr

Senior Software Engineer
103 salaries
unlock blur

₹10.8 L/yr - ₹28.2 L/yr

Lead Software Engineer
46 salaries
unlock blur

₹12.2 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.1
Compare

Arvato

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