Sarthee Consultancy interview experience Real time questions & tips from candidates to crack your interview

Data Analyst

Sarthee Consultancy

3 rounds | 3 Coding problems

Siddharth

Fresher | Apr 2021

Selected

Interview preparation journey

Preparation

Duration: 3 months

Topics: SQL, Excel, Tableau, ETL, Joins, Pivot Tables

Tip

Tip 1 : Be well versed with basics of SQL like joins and Select statement
Tip 2 : Be confident and genuine

Application process

Where: Campus

Eligibility: Ablove 7 CGPA

Resume tip

Tip 1 : Have relevant internships
Tip 2 : Only put true things in resume as your resume is thoroughly verified

Interview rounds

Round

Easy

Online Coding Interview

Duration90 minutes

Interview date1 Apr 2021

Coding problem1

It was an online aptitude test on Amcat platform. The overall test was easy with most of the questions testing basic mathematics and logical thinking. The test could be taken at your own convenience and was online proctored.

1. Nth Fibonacci Number

Easy

0/40

Asked in companies

The n-th term of Fibonacci series F(n), where F(n) is a function, is calculated using the following formula -

    F(n) = F(n - 1) + F(n - 2), 
    Where, F(1) = 1, F(2) = 1

Provided 'n' you have to find out the n-th Fibonacci Number. Handle edges cases like when 'n' = 1 or 'n' = 2 by using conditionals like if else and return what's expected.

"Indexing is start from 1"

Example :

Input: 6

Output: 8

Explanation: The number is ‘6’ so we have to find the “6th” Fibonacci number.
So by using the given formula of the Fibonacci series, we get the series:    
[ 1, 1, 2, 3, 5, 8, 13, 21]
So the “6th” element is “8” hence we get the output.

Try solving now

Round

Medium

Face to Face

Duration60 minutes

Interview date3 Apr 2021

Coding problem1

This round was technical in nature with a manager taking it. It was in the afternoon.

1. DBMS Question

Write a query to select the second highest salary details (ID, Name, Salary) from Employees table.

Round

Medium

Face to Face

Duration90 minutes

Interview date5 Apr 2021

Coding problem1

This was the final round with the co-founder. They were very relaxed and made me feel comfortable. It was late at night because of US time. I was asked puzzles and basic analytics terms.