I applied online. The process took 2 weeks. I interviewed at Clairvoyant in Jan 2021
Interview
hard interview process, How do you receive your clairvoyant insights? Can you describe a memorable experience when your clairvoyance was particularly accurate? How do you prepare for a clairvoyant reading?. How do you handle skepticism from clients or others about your abilities?
I applied online. The process took 4 weeks. I interviewed at Clairvoyant (Pune) in Sept 2024
Interview
HR found my profile through Naukri, they got an understanding about my current job role and checked if it aligns with their requirement and arranged an interview. There were total three rounds - 2 technical, and 1 client interview round. The team prepares you for the client interview round.
Interview questions [3]
Question 1
column
1
2
3
4
5
5
6
7
8
8
10
Q. Using SQL find the highest non repeating number
Q. SQL: Print the number in column where the cumulative sum becomes equal to 10.
Q. Create a table without duplicates / remove duplicates
Q. Using Pandas find the highest non-repeating number
Q. Difference between coalesce and repartition in pyspark
Q. Difference between coalesce and isnull
Q. What is task, stages in pyspark
Q. Have you seen query execution plan in pyspark
Q. What is tuple and sets?
Q. What do you mean by ordered?
Q. Is list ordered?
Q. Is a string mutable?
Q. What is the order of execution in SQL
Q. Difference between Kmeans and KNN algorithm
Q. Which is supervised and which one is unsupervised?
Q. Does the scale of data affects clustering?
Q. What feature engineering you did before clustering?
