Merkle Sokrati interview experience Real time questions & tips from candidates to crack your interview

Data Analyst

Merkle Sokrati

2 rounds | 3 Coding problems

Apurv Kumar

Fresher | Jan 2022

Selected

Interview preparation journey

Preparation

Duration: 3 months

Topics: Data Structures, Algorithms, OOPS, DBMS, OS, data analysts questions, Excel.

Tip

Tip 1 : Revise your study material before giving interview.
Tip 2 : Focus more and more on practicing excel.
Tip 3 : Try to solve previous years data analysts question as much as you can.

Application process

Where: Company Website

Eligibility: 7 CGPA, good in programming and knowledge of data analyst

Resume tip

Tip 1 : Don't write over skills and false things in your resume.
Tip 2 : Have some projects on resume and highlight the key points like technology, project name, skills, etc.

Interview rounds

Round

Easy

Online Coding Interview

Duration60 minutes

Interview date6 Jan 2022

Coding problem2

Timing-Duration Of Round is 60 mins.
you need to give the test within 5 days of getting the test mail.

Test is conducted virtually through Merkle Sokrati platform and after that it redirects to Amazon page where we need to answer questions related to Core subjects, DBMS, Excel, Behavioral, Leadership Principles and workstyles.

1. MCQ Questions

Test is conducted virtually through company's platform and after that it redirects to Amazon page where we need to answer questions related to Core subjects, DBMS, Excel, Behavioural, Leadership Principles and workstyles.

Number Of MCQs - 30

2. Technical Questions

We need to answer questions related to Core subjects, DBMS, Excel, Behavioural, Leadership Principles and workstyles.

this round is entirely based on MCQ's.
Questions like:-
1) How many types of joins in SQL?(DBMS question)
2) What is the output of below program?
3) Some behavioural questions like are you open to learn new skills.
Are you open to adopt new challenging opportunity or want to stick on the previous work?

Problem approach

Tip 1 : Based upon your knowledge you need to chose.
Tip 2 : Need to choose such option as per recruiter taste.
Tip 3 : Need to revise concepts before giving the assessment test.

Round

Medium

Face to Face

Duration60 minutes

Interview date12 Jan 2022

Coding problem1

We need to answer all recruiter question within 1 hour in which we need to answer our approaches and if recruiter wants to show how to solve then we need to perform the solution using Merkle Sokrati Platform or Excel Platform with optimal solution and time efficient approach.

1. Puzzle Question

How to sum of following data in excel?
data:-
S.No
1 A B C D E ...column_name->
2 Col1 Col2 Col3 Col4 Result
3 4 6 #N?A 2 ??
4 3 #N?A 4 1
.
.

In this round there are some other questions based on behavioral, leadership and core subject.
like:-
1) Are you open to work on weekend during the outage issue?
2) Difference between drop, truncate, and delete query in SQL?
3) If you are assigned a team then how you will lead the team?
4) Types of DML and its uses in SQL?

Problem approach

Tip 1 : We need to write below formula in E3 cell to get the result
SUM(IF(ISNUMBER(A3:D2),A3:D2))
Tip 2 : once done with writing code then press enter Output of SUM will be appear in E3 cell.
Tip 3 : Now just select the E3 cell from bottom right and drag down as per your data.