Upload Button Icon Add office photos
Engaged Employer

i

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

Xerago Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 96 Reviews

Filter interviews by

Xerago Data Analyst Interview Questions and Answers

Updated 19 May 2024

Xerago Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 19 May 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. SQL Questions, 1. Difference between truncate and drop. 2. how to create a empty duplicate table based on existing table.

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Oct 2022. There were 4 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 - Aptitude Test 

Mathematics, English and Reasoning..

Round 3 - Technical 

(2 Questions)

  • Q1. What is python? What is uses of python?
  • Ans. 

    Python is a high-level, interpreted programming language used for web development, data analysis, artificial intelligence, and more.

    • Python is easy to learn and has a simple syntax.

    • It is used for web development with frameworks like Django and Flask.

    • Python is popular for data analysis and visualization with libraries like Pandas and Matplotlib.

    • It is used for artificial intelligence and machine learning with libraries li...

  • Answered by AI
  • Q2. Some coding based questions of python.
Round 4 - HR 

(3 Questions)

  • Q1. Salary and work discussionion
  • Q2. Short and long term goals.
  • Q3. Work Role, post and company work.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be careful during interview and hear all the instruction carefully.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Some basic Python ETL Questions, based on list,dictionary.
  • Q2. SQL Basics Question
Round 2 - HR 

(1 Question)

  • Q1. Explain your projects
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Why XG boost Than random forest
  • Ans. 

    XGBoost is preferred over Random Forest due to its faster execution speed and better performance in complex datasets.

    • XGBoost is faster than Random Forest due to its optimized implementation of gradient boosting algorithm.

    • XGBoost generally performs better in complex datasets with high-dimensional features.

    • XGBoost allows for more fine-tuning of hyperparameters compared to Random Forest.

    • XGBoost has regularization techniqu...

  • Answered by AI
  • Q2. About Projects experience

Interview Preparation Tips

Interview preparation tips for other job seekers - They are taking forever to feedback us

Skills evaluated in this interview

I applied via Referral and was interviewed in Nov 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Difference between coalesce and repartition
  • Ans. 

    Coalesce is used to select the first non-null value from a set of columns. Repartition is used to shuffle data across nodes.

    • Coalesce reduces the number of partitions to the minimum required.

    • Repartition increases or decreases the number of partitions.

    • Coalesce is a narrow transformation while repartition is a wide transformation.

    • Coalesce is used to optimize data for queries while repartition is used to balance data acros...

  • Answered by AI
  • Q2. How to optimise joins
  • Ans. 

    Optimizing joins involves selecting appropriate join types, indexing tables, and minimizing data movement.

    • Choose the appropriate join type based on the size and structure of the tables being joined

    • Index the tables on the join columns to speed up the join process

    • Minimize data movement by selecting only the necessary columns and filtering rows before joining

    • Consider using denormalization or materialized views to precompu

  • Answered by AI
  • Q3. Spark optimizations
  • Q4. Difference between RDD dataset and dataframe
  • Ans. 

    RDD is a low-level distributed data structure while DataFrame is a high-level structured data abstraction.

    • RDD is immutable and unstructured while DataFrame is structured and has a schema

    • DataFrames are optimized for SQL queries and can be cached in memory

    • RDDs are more flexible and can be used for complex data processing tasks

    • DataFrames are easier to use and provide a more concise syntax for data manipulation

    • RDDs are the...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The major focus was on Apache Spark.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

Mathematics, English and Reasoning..

Round 3 - Technical 

(2 Questions)

  • Q1. What is python? What is uses of python?
  • Ans. 

    Python is a high-level, interpreted programming language used for web development, data analysis, artificial intelligence, and more.

    • Python is easy to learn and has a simple syntax.

    • It is used for web development with frameworks like Django and Flask.

    • Python is popular for data analysis and visualization with libraries like Pandas and Matplotlib.

    • It is used for artificial intelligence and machine learning with libraries li...

  • Answered by AI
  • Q2. Some coding based questions of python.
Round 4 - HR 

(3 Questions)

  • Q1. Salary and work discussionion
  • Q2. Short and long term goals.
  • Q3. Work Role, post and company work.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be careful during interview and hear all the instruction carefully.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
No response

I applied via Campus Placement and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

It want really good, aptitude test, focus on basic

Round 2 - One-on-one 

(1 Question)

  • Q1. Case study, interview, guestimates, python, SQL, power bi, Excel
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Assignment 

Technical question on based of resume

Round 2 - Coding Test 

Questionnaire given to solve

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Coding Test 

Basic dsa question in python and data engineering questions ,sql

Round 3 - Coding Test 

Basic dsa question in python and data engineering questions

Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation

I applied via LinkedIn and was interviewed in Aug 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. First-round was technical assessment after that there is a technical interview on google meet. The guy asked me for sharing the screen and asked some programming questions related to python.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for programming questions.

Xerago Interview FAQs

How many rounds are there in Xerago Data Analyst interview?
Xerago interview process usually has 1 rounds. The most common rounds in the Xerago interview process are Technical.
How to prepare for Xerago Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Xerago. The most common topics and skills that interviewers at Xerago expect are Data Analysis, Data Analytics, Google Analytics, Power Bi and Tableau.

Tell us how to improve this page.

People are getting interviews through

based on 1 Xerago interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Xerago Data Analyst Salary
based on 21 salaries
₹1.8 L/yr - ₹5.3 L/yr
49% less than the average Data Analyst Salary in India
View more details

Xerago Data Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-Life balance

5.0

Salary & Benefits

5.0

Job Security

5.0

Company culture

5.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Web Developer
55 salaries
unlock blur

₹1.2 L/yr - ₹4.3 L/yr

Business Analyst
22 salaries
unlock blur

₹1.9 L/yr - ₹8.2 L/yr

Data Analyst
21 salaries
unlock blur

₹1.8 L/yr - ₹5.3 L/yr

Senior Web Developer
19 salaries
unlock blur

₹3 L/yr - ₹5.4 L/yr

Team Lead
19 salaries
unlock blur

₹3 L/yr - ₹12.6 L/yr

Explore more salaries
Compare Xerago with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview