8/12/2019 00 Interview Guidelines (3)

1/5

Telephonic: Round1

# R2 + R3Time Interval

(min)

1 Take through Resume 2

2 Set the flow of interview 2

3 Questions on resume 10

4 SQL Knowledge test 5

6 Excel Knowledge Test 5

5 Puzzles 5

F2F: Round2

# R2 + R3Time Interval

(min)

1 Case Study 20

2 Adv Excel + SQL 10

Final: Round3

# R2 + R3

Time Interval

(min)

1 Behavioural 15

2 Final 15

8/12/2019 00 Interview Guidelines (3)

2/5

8/12/2019 00 Interview Guidelines (3)

3/5

Overall RemarksTelephonic Round

Score (out of 20)

Case StudyAdv. Excel +

SQL

BehaviouralFinal (Retention / Intent /

Attitude / Puzzles)

Overall Remarks

11

Face to Face (Score)

8/12/2019 00 Interview Guidelines (3)

4/5

F2F Round Score

(out of 20)

Total Score

(Out of 30)

0 5.5

8/12/2019 00 Interview Guidelines (3)

5/5

Topic Guideline to Score Topic Guideline to Score

Resume

[1]: Interaction with multiple people (college + work-ex)

[1]: Number oriented projects should be present in CV

[1]: Relevant e-commerce background in projects performed

[0.5]: Leadership position in college / work-ex (will help judge planning)

[1.5]: Impact of projects taken

Grades

[2]: Points for IITs / Top NITs / IIITs / BITS / DCE / NSIT

[3]: CGPA > 8.5, 10th & 12th 85%+

[2]: CGPA > 7.5, 10th & 12th 75%+

[1]: CGPA > 6.5, 10th & 12th 65%+

SQL Knowledge[2]: Theoritical Question

[3]: Simple Practical Question

Basic Excel

Knowledge [5]: 5 Basic Questions

Puzzle

[1]: Ask questions to get clarification

[1]: Attempts to solve; starts speaking on some lines

[1]: Able to break the problem successfully

[1]: Reaching Solution

[1]: Correct Solution

Case Study

(Round 1)

[1]: Ask questions to get clarification

[1]: Attempts to solve; starts speaking on some lines

[1]: Able to break the problem successfully

[1]: Able to convey and communicate

[1]: Makes genuine assumptions

Adv. Excel +

SQL (Round 1)

SQL:

[3]: One fairly complex problem

Excel:

[0.5]: Speed / confortable in using keys

[1]: Two problems

[0.5]: Ability to show data

Behavioural(Round 2)

[1]: Be very detail oriented and would consider data quality as a very important

factor in success of analytics function.

[1]: Learn new skills and tools quickly

[1]: Have an acumen to suggest quick turn-around.

[1]: High degree of people interaction

[0.5]: Ethics

[1]. Perseverence & Stressful situation + workload (efficient and relentless in

fire-fighting till a solution is achieved)

[0.5]. Leadership example (Be able to plan new projects)

Final Round(Round 2)

[1]: Retention / Goals / Short long term plan / Why change?

[1]: Why Snapdeal (Intent)

[1]: Positive Attitude (Do not get bogged down)[1]: Workload

[1]: Random question

F2F

Telephonic