Upload Button Icon Add office photos

Filter interviews by

any company Data Analyst Interview Questions and Answers

Updated 15 Jun 2022

any company Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 15 Jun 2022

I was interviewed in May 2022.

Round 1 - Technical 

(1 Question)

  • Q1. What is SQL,DDL,DML,JOINS,DELETE,TRUNCATE,FIND MAXIMUM,MINIMUM ETC.
  • Ans. 

    SQL is a programming language used to manage and manipulate relational databases.

    • DDL (Data Definition Language) is used to define the structure of a database.

    • DML (Data Manipulation Language) is used to manipulate data within a database.

    • JOINS are used to combine data from two or more tables based on a related column.

    • DELETE is used to remove data from a table.

    • TRUNCATE is used to remove all data from a table.

    • MAXIMUM and M...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Why do you want to join company,why am i select for you

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep things in balance and make sure that you are taking care of yourself.Dont get discouraged and remember that most jobs comes when you least expect them.

Skills evaluated in this interview

Interview questions from similar companies

I was interviewed in Aug 2017.

Interview Preparation Tips

Round: Group Discussion
Experience: every one put their views
Tips: just tell anything. no one listen
Duration: 5 minutes

Round: Test
Experience: online test
Tips: do those question which can be solved without usingpen paper first
Duration: 5 minutes
Total Questions: 50

Skills: Relieving Pressure

I was interviewed in Sep 2016.

Interview Questionnaire 

2 Questions

  • Q1. Behavioral questions, what will you choose knowledge or money?Why?, etc . Other curricular activities that showcase your managerial skills, etc
  • Q2. Focused on projects from resume and cross questioning. Can ask you about the tools or languages related questions if you have added that to CV. Followed by guesstimates where you will have to provide detai...

Interview Preparation Tips

Round: Technical + HR Interview
Tips: It is advantageous if you have prior experience with data handling tools eg advanced EXCEL , SPSS

I applied via Naukri.com and was interviewed in Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is unwanted safety effect?

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not show fear on the face and do not interrupt your speech weather it is right or wrong, it may lead effect on you chance of selection by the interviewer.

Data Analyst Interview Questions & Answers

TCS user image Mahuya Khan Basak

posted on 12 Nov 2017

I was interviewed before Nov 2016.

Interview Preparation Tips

Round: Test
Experience: Only Written
Duration: 1 hour 45 minutes
Total Questions: 100

Skills: Proficiency In English, Basic concepts of computer, Commerce background with 50%

I was interviewed before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Medium

  • Q1. 

    Ninja and His Secret Information Encoding Problem

    Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...

  • Ans. 

    The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.

    • Read the number of test cases 'T'

    • For each test case, encode the 'SECRET_INFORMATION' and then decode it

    • Compare the decoded string with the original 'SECRET_INFORMATION'

    • Print 'Transmission successful' if they match, else print 'Transmission failed'

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Medium

  • Q1. 

    Equilibrium Index Problem Statement

    Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array.

    An index is considered as an equilibrium index if the sum of elem...

  • Ans. 

    Find the equilibrium index of an array where sum of elements on left equals sum on right.

    • Iterate through the array and calculate prefix sum and suffix sum at each index.

    • Compare prefix sum and suffix sum to find equilibrium index.

    • Return the left-most equilibrium index or -1 if none found.

  • Answered by AI
Round 3 - HR 

Round duration - 50 Minutes
Round difficulty - Easy

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in PuneEligibility criteria7 CGPACapgemini interview preparation:Topics to prepare for the interview - Data Structures, OOPS, SQL, Python, JavaTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company

Application resume tips for other job seekers

Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Prior experience,questions related to data analysis tools.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview process is fast,mine got done in a day but if you are selected and your salary negotiation is finished, it will take almost a month to get offer letter,so need not worry till that time you will surely get it.
The reason behind the offer letter delay is they have to get approvals from multiple teams which creates a delay on the process.

I applied via Walk-in and was interviewed before Aug 2021. There were 2 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 

(1 Question)

  • Q1. How to transpose data set
  • Ans. 

    Transposing a data set involves flipping rows and columns.

    • Identify the data set to be transposed

    • Create a new table with the columns and rows flipped

    • Copy the data from the original table to the new table

    • Transpose can be done using Excel, Python, R, SQL, etc.

    • Example: Transposing a table of sales data to have products as rows and months as columns

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Was asked hard hitting questions by interviewer. Ultimately failed

I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Da tools

Interview Preparation Tips

Interview preparation tips for other job seekers - Get referal

I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Python data structures
  • Q2. MongoDB database algorithms
  • Ans. 

    MongoDB database algorithms are used for efficient data storage, retrieval, and processing.

    • MongoDB uses various algorithms for indexing, sharding, and aggregation.

    • Indexing algorithms include B-tree, hash, and text search indexes.

    • Sharding algorithms include range-based, hash-based, and zone-based sharding.

    • Aggregation algorithms include map-reduce and aggregation pipeline.

    • MongoDB also uses algorithms for query optimizati

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with your basics

Skills evaluated in this interview

any company Interview FAQs

How many rounds are there in any company Data Analyst interview?
any company interview process usually has 2 rounds. The most common rounds in the any company interview process are Technical and HR.

Tell us how to improve this page.

Data Analyst Interview Questions from Similar Companies

View all
any company Data Analyst Salary
based on 6 salaries
₹1.2 L/yr - ₹7.7 L/yr
43% less than the average Data Analyst Salary in India
View more details
Data Entry Operator
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Accountant
14 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

CAR Driver
11 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Receptionist
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Tele Caller
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare any company with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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