Sigmoid

Role: Data Analyst

College: Not Specified

Interview Date: September 2024

Interview Type: Not Specified

Result: Selected

Difficulty: Medium

Rounds: 3 rounds

Topics Asked: Tableau, SQL, Puzzles, Behavioral Questions

Experience:

The candidate interviewed for a Data Analyst role with 2 years of experience.

Round 1: Technical

This round focused on Tableau and SQL. Tableau questions included: "How to publish a dataset in Tableau?", "How to blend different datasources?", and "How to pivot the data?". For SQL, the candidate was given a dataset and asked to show the difference between RANK and DENSE_RANK. They were also asked how to optimize a query.

Round 2: Managerial/Behavioural

Questions in this round covered past company experience and challenges faced. The interviewer also asked a few puzzles, such as "moving a square to make it a rhombus type".

Round 3: HR Round

The HR round included questions about the reason for leaving the previous company and salary expectations.

Overall Experience: The candidate was selected as a Data Analyst.