Premium Employer

i

This company page is being actively managed by Shadowfax Technologies Team. If you also belong to the team, you can get access from here

Shadowfax Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Shadowfax Technologies Senior Data Analyst Interview Questions and Answers for Freshers

Updated 4 Mar 2024

Shadowfax Technologies Senior Data Analyst Interview Experiences for Freshers

1 interview found

Senior Data Analyst Interview Questions & Answers

user image Prithwijit Paul

posted on 4 Mar 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Joins, Window Functions, Agg Functions
Round 2 - Case Study 

Guesstimates and Case Study

Round 3 - HR 

(1 Question)

  • Q1. Screening and Salary Expectations

Interview questions from similar companies

I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

Excel and aptitude test

Round 2 - Technical 

(2 Questions)

  • Q1. Case study on OYO room
  • Q2. Guesstimate on number of delivery boys in Gurgaon.
  • Ans. 

    There are approximately 10,000 delivery boys in Gurgaon.

    • Consider the population of Gurgaon and the number of online food delivery services operating in the area.

    • Assume an average of 5 delivery boys per restaurant and multiply by the number of restaurants in Gurgaon.

    • Factor in the number of delivery boys working for other types of delivery services such as e-commerce and courier companies.

    • The number may vary depending on...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Tell me something about yourself and your previous roles

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice aptitude and Excel online. Understand the thinking process for guesstimate which you get on YouTube.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude test went good like the CAT

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well in advnace with topics similar to logistics
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Detailed questions on probability. Statistical questions.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - Technical 

(3 Questions)

  • Q1. Guess estimate question
  • Q2. Advance excel
  • Q3. Statistics basic
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in Jun 2024. There were 7 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What is your name
  • Ans. 

    My name is John Doe.

    • My first name is John

    • My last name is Doe

  • Answered by AI
  • Q2. Introducing ur self
Round 2 - One-on-one 

(2 Questions)

  • Q1. Why do you want work for us?
  • Ans. 

    I am impressed by your company's innovative approach to data analysis and want to be a part of your team.

    • I admire your company's reputation in the industry

    • I am excited about the opportunity to work on cutting-edge projects

    • I believe my skills and experience align well with the company's goals

  • Answered by AI
  • Q2. What are you strength
  • Ans. 

    My strengths include strong analytical skills, attention to detail, and the ability to communicate complex data effectively.

    • Strong analytical skills - able to interpret and analyze data effectively

    • Attention to detail - meticulous in reviewing and ensuring accuracy of data

    • Effective communication of complex data - able to present findings in a clear and understandable manner

  • Answered by AI
Round 3 - Group Discussion 

Involve working through a business problem or scenario with the interviewer to reach a logical conclusions

Round 4 - HR 

(2 Questions)

  • Q1. Introducing your self
  • Q2. Tell me about your self
  • Ans. 

    I am a data analyst with a strong background in statistics and data visualization.

    • Experienced in using statistical tools such as R and Python

    • Skilled in creating insightful data visualizations using Tableau

    • Proficient in SQL for data querying and manipulation

    • Strong analytical and problem-solving skills

    • Excellent communication and presentation abilities

  • Answered by AI
Round 5 - Aptitude Test 

Employers will set this type of test if they need to hire a person with excellent logical skills.

Round 6 - Coding Test 

Code testing refers to running each line of code with a controlled input, and verifying if it performs the expected output

Round 7 - Technical 

(2 Questions)

  • Q1. Introducing the same time
  • Q2. Telling me about company

Interview Preparation Tips

Topics to prepare for XpressBees Data Analyst interview:
  • Business Development
Interview preparation tips for other job seekers - Identify Your Career Goals. ...
2. Dedicate Time to the Search. ...
3. Don't Limit Your Search to Online Resources. ...
4. Make Networking Part of Your Everyday Life. ...
5. Keep Yourself Busy. ...
6. Optimize Your LinkedIn Profile. ...
7. Use Several Job-Search Websites. ...
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Profile screening
  • Q2. Previous employment details
  • Ans. 

    I have worked as a Data Analyst for two years at XYZ Company.

    • Worked as a Data Analyst at XYZ Company for two years

    • Analyzed large datasets to identify trends and patterns

    • Created reports and visualizations to present data findings

    • Collaborated with cross-functional teams to gather and analyze data

    • Used SQL, Python, and Excel for data analysis tasks

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Technical questions on tech stack. Mostly statistics and basic ML
  • Q2. Previous project details
  • Ans. 

    Developed a predictive model to forecast customer churn in a telecommunications company.

    • Used machine learning algorithms such as logistic regression and random forest.

    • Analyzed customer data including demographics, usage patterns, and customer service interactions.

    • Achieved an accuracy of 85% in predicting customer churn.

    • Provided actionable insights to the company to reduce churn rate and improve customer retention.

  • Answered by AI
Round 4 - Assignment 

Need to frame questions and their answers on data provided

Round 5 - HR 

(1 Question)

  • Q1. Final salary discussion

Interview Preparation Tips

Topics to prepare for XpressBees Data Analyst interview:
  • R programming
  • Machine Learning
  • Statistics
Interview preparation tips for other job seekers - Be clear with basics. Easy for fresher and experienced both.

I applied via Referral and was interviewed in Oct 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Optimization of Service center model design
  • Ans. 

    Optimizing service center model design involves analyzing data to identify areas for improvement and implementing changes to increase efficiency and customer satisfaction.

    • Analyze data on customer needs and service center performance

    • Identify areas for improvement, such as wait times or staffing levels

    • Implement changes to increase efficiency and customer satisfaction, such as adding self-service options or adjusting staf...

  • Answered by AI
  • Q2. Python related questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Scenario based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to understand the problem statement correctly and give answers to the point. Don't deviate your answers to much. Prepare for atleast 200 interview questions on skills you out on your resume.

I was interviewed before May 2021.

Round 1 - Assignment 

(1 Question)

Round duration - 45 Minutes
Round difficulty - Medium

  • Q1. Design a class booking application for students.
  • Ans. 

    A class booking application for students to schedule and manage their classes.

    • Create a class booking system where students can view available classes, book classes, and manage their schedule.

    • Include features like class search, class details, booking confirmation, and calendar view.

    • Implement user authentication to ensure only registered students can book classes.

    • Allow students to cancel or reschedule classes with proper...

  • Answered by AI
Round 2 - Telephonic Call 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Medium

The interviewer understand the current problem statement I was working on. 
Asked the clarifying questions and alternative approaches to solve the same and their tradeoffs.
Also, asked about the technologies I was using in depth and reason for choosing the same.

  • Q1. 

    Gas Tank Problem Statement

    You have a car with a gas tank of infinite capacity. There are 'N' gas stations located along a circular route, numbered from 0 to N-1. You begin your journey with an empty tank...

  • Ans. 

    Find the starting gas station index to complete a circular route with gas and cost arrays.

    • Iterate through gas stations, keeping track of gas remaining after each station

    • If gas remaining is negative, reset starting station to current station + 1

    • If total gas remaining at the end is greater than or equal to total cost, return starting station index

  • Answered by AI
Round 3 - Telephonic Call 

Round duration - 45 Minutes
Round difficulty - Medium

This round was their with the CTO and was mostly the culture fitment round.

 

Round 4 - HR 

Round duration - 30 Minutes
Round difficulty - Easy

This round was with the cofounder and was mostly culture fitment.

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in GurgaonEligibility criteriaNo criteriaRIVIGO interview preparation:Topics to prepare for the interview - Data Structures, Competitive Programming, Databases, Java, Spring , Hibernate, Jenkins, AWSTime required to prepare for the interview - 2 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice questions on leetcode
Tip 2 : Understand the best solutions in depth and algorithm used
Tip 3 : Ask clarifying questions to the interviewer and break the problem to smaller sub parts

Application resume tips for other job seekers

Tip 1 : Highlight your most impactful work on the resume
Tip 2 : Keep it easy to understand

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in May 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. What is diameter of Binary Tree? Write full working code.
  • Ans. 

    Diameter of a binary tree is the longest path between any two leaf nodes.

    • Calculate the height of left and right subtrees recursively.

    • Calculate the diameter recursively using the formula max(left_height + right_height + 1, max(left_diameter, right_diameter)).

    • Return the maximum diameter.

  • Answered by AI
  • Q2. Find interchanged terms from an AP, where terms are arranged in series
  • Ans. 

    To find interchanged terms from an AP series

    • Identify the common difference between terms

    • Swap the positions of adjacent terms

    • Check if the new series is also an AP

    • Repeat until no more interchanged terms can be found

  • Answered by AI
  • Q3. Explain database indexing
  • Ans. 

    Database indexing is a technique to improve the performance of database queries.

    • Indexing creates a data structure that allows for faster retrieval of data.

    • Indexes are created on one or more columns of a table.

    • Queries that use indexed columns can be executed faster.

    • Indexes can be clustered or non-clustered.

    • Clustered indexes determine the physical order of data in a table.

    • Non-clustered indexes create a separate structure...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on basic data structures, operating systems and database.

Skills evaluated in this interview

Shadowfax Technologies Interview FAQs

How many rounds are there in Shadowfax Technologies Senior Data Analyst interview for freshers?
Shadowfax Technologies interview process for freshers usually has 3 rounds. The most common rounds in the Shadowfax Technologies interview process for freshers are Technical, Case Study and HR.
What are the top questions asked in Shadowfax Technologies Senior Data Analyst interview for freshers?

Some of the top questions asked at the Shadowfax Technologies Senior Data Analyst interview for freshers -

  1. sql basics joins , subqueries, window functions , excel vlookup , pivot , busin...read more
  2. Joins, Window Functions, Agg Functi...read more

Tell us how to improve this page.

Shadowfax Technologies Senior Data Analyst Interview Process for Freshers

based on 1 interview

Interview experience

5
  
Excellent
View more
Join Shadowfax Technologies India's Fastest Growing End-to-End Fully Integrated Logistics Provider

Interview Questions from Similar Companies

Delhivery Interview Questions
3.9
 • 456 Interviews
ElasticRun Interview Questions
3.5
 • 250 Interviews
Ecom Express Interview Questions
3.8
 • 197 Interviews
XpressBees Interview Questions
3.6
 • 159 Interviews
DTDC Express Interview Questions
3.7
 • 151 Interviews
Safexpress Interview Questions
4.0
 • 103 Interviews
Blue Dart Express Interview Questions
4.0
 • 102 Interviews
Exl India Interview Questions
3.5
 • 102 Interviews
FedEx Express Interview Questions
4.0
 • 93 Interviews
View all
Shadowfax Technologies Senior Data Analyst Salary
based on 35 salaries
₹4 L/yr - ₹12 L/yr
19% less than the average Senior Data Analyst Salary in India
View more details

Shadowfax Technologies Senior Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

2.0

Skill development

3.0

Work-life balance

4.0

Salary

3.0

Job security

1.0

Company culture

2.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Team Lead
551 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
382 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Lead
205 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
183 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Lead
160 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Shadowfax Technologies with

Delhivery

3.9
Compare

Ecom Express

3.8
Compare

XpressBees

3.6
Compare

Wow Express

3.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview