Upload Button Icon Add office photos

Filter interviews by

Diacto Data Analyst Interview Questions and Answers

Updated 20 Jan 2025

Diacto Data Analyst Interview Experiences

4 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 20 Jan 2025

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

I applied via Approached by Company and was interviewed before Jan 2024. There were 2 interview rounds.

Round 1 - Group Discussion 

Shared details on what company does.

Round 2 - Technical 

(1 Question)

  • Q1. SQL based questions as appearing for Data Analyst position

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 26 Nov 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
No response
Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself ?
  • Q2. Why you want to be a part of this team?
  • Ans. 

    I am passionate about data analysis and believe this team offers a great opportunity for growth and collaboration.

    • I am excited about the team's focus on using data to drive decision-making

    • I admire the team's innovative approach to problem-solving

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was intern position for Data & AI team. Interview taken on teams by the HR, It was smooth, but the position was not available after sometime.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
Q4. Sliding Window Maximum Problem Statement You are given an array/l ... read more
asked in Tredence
Q5. Find First Repeated Character in a String Given a string 'STR' co ... read more

Data Analyst Interview Questions & Answers

user image Gourav Gore

posted on 4 Sep 2024

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

(2 Questions)

  • Q1. About your self
  • Q2. About project mentioned in resume
Round 2 - Assignment 

Assignment was all about sql, python

Data Analyst Interview Questions & Answers

user image Arunav Rajkhowa

posted on 3 Jul 2024

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

I was interviewed before Jul 2023.

Round 1 - Technical 

(1 Question)

  • Q1. Sql window functions

Interview questions from similar companies

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

I was interviewed in Dec 2024.

Round 1 - Technical 

(6 Questions)

  • Q1. Tell me About Yourself
  • Q2. Project working and day to day activities I do
  • Q3. Rate Yourself In SQL out of 5
  • Q4. Sql 3 question based on windows function
  • Q5. Very basic python 2 Question
  • Q6. What You do on power bi in your work Explain with full details workflow
Round 2 - Technical 

(1 Question)

  • Q1. All 3 sql Questions very simple Round but they didn't provide any Data tables just tell this and that so it may get confusing I slove 2 out of three but rejected on this Round questions Are intermidate

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall interview Is Very simple just listen there Questions Clearly on sql You Will Crack Deloitte
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine?
  • Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients?
Round 2 - One-on-one 

(2 Questions)

  • Q1. Can you explain your project experience related to Advanced Excel and Power BI?
  • Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data?

Interview Preparation Tips

Interview preparation tips for other job seekers - If your resume is shortlisted, then there is a higher chance that you will be selected.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
No response

I applied via AmbitionBox and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
Round 2 - Case Study 

NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.

Round 3 - Group Discussion 

A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.

Interview Preparation Tips

Interview preparation tips for other job seekers - I am willing to work hard and invest ample time in the company's development, demonstrating effective time management while sincerely engaging in daily scheduled project-based research and maintaining team spirit.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Sql python bigdata hadoop hive spark

Round 2 - Coding Test 

1 hour simple coding python sql

Round 3 - One-on-one 

(5 Questions)

  • Q1. Advantages of sql
  • Ans. 

    SQL allows for efficient data retrieval, manipulation, and analysis in relational databases.

    • SQL is widely used in querying databases to retrieve specific data.

    • It allows for data manipulation, such as adding, updating, and deleting records.

    • SQL can perform complex data analysis tasks, such as aggregations and joins.

    • It provides a standardized language for interacting with relational databases.

    • SQL is essential for generati...

  • Answered by AI
  • Q2. Advantages of python
  • Ans. 

    Python is a versatile programming language known for its simplicity, readability, and vast library support.

    • Easy to learn and use, making it ideal for beginners and experienced programmers alike

    • Extensive library support for data analysis, machine learning, web development, and more

    • Strong community support with active forums and resources for problem-solving

    • Cross-platform compatibility allows for seamless integration wit...

  • Answered by AI
  • Q3. Spark and its benefits
  • Ans. 

    Spark is a fast and powerful big data processing framework that offers benefits like speed, ease of use, and versatility.

    • Spark is known for its speed, as it can process data up to 100 times faster than traditional Hadoop MapReduce.

    • It offers ease of use with high-level APIs in Java, Scala, Python, and SQL, making it accessible to a wide range of users.

    • Spark is versatile, supporting various workloads such as batch proces...

  • Answered by AI
  • Q4. Why to leave the company
  • Q5. Huddles of data engineer
  • Ans. 

    Huddles of data engineers refer to collaborative meetings or discussions among data engineers to share insights, solve problems, and make decisions.

    • Huddles are typically informal and can be scheduled or ad-hoc.

    • They provide a platform for data engineers to brainstorm, troubleshoot, and exchange ideas.

    • Huddles may involve reviewing code, discussing data pipelines, or addressing technical challenges.

    • Effective huddles promo...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - One-on-one 

(1 Question)

  • Q1. Python and sql related question
Round 2 - One-on-one 

(1 Question)

  • Q1. Pandas numpy visualisation sql
Round 3 - Coding Test 

Alteryx data processing and reporting

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

I applied via Walk-in and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Online aptitude test with maths and statistics and data analysis

Round 2 - Technical 

(1 Question)

  • Q1. Joins sql groups python numpy pandas

Diacto Interview FAQs

How many rounds are there in Diacto Data Analyst interview?
Diacto interview process usually has 1-2 rounds. The most common rounds in the Diacto interview process are Technical, HR and Assignment.
What are the top questions asked in Diacto Data Analyst interview?

Some of the top questions asked at the Diacto Data Analyst interview -

  1. SQL based questions as appearing for Data Analyst posit...read more
  2. sql window functi...read more

Tell us how to improve this page.

Diacto Data Analyst Interview Process

based on 4 interviews

Interview experience

4.8
  
Excellent
View more

Data Analyst Interview Questions from Similar Companies

View all
Diacto Data Analyst Salary
based on 37 salaries
₹3.6 L/yr - ₹10 L/yr
21% more than the average Data Analyst Salary in India
View more details

Diacto Data Analyst Reviews and Ratings

based on 8 reviews

4.2/5

Rating in categories

4.0

Skill development

4.4

Work-life balance

3.8

Salary

3.9

Job security

4.7

Company culture

3.9

Promotions

3.7

Work satisfaction

Explore 8 Reviews and Ratings
Associate Data Analyst
38 salaries
unlock blur

₹3 L/yr - ₹10.4 L/yr

Data Analyst
37 salaries
unlock blur

₹3.6 L/yr - ₹10 L/yr

Project Manager
5 salaries
unlock blur

₹12.4 L/yr - ₹20 L/yr

Associate Software Developer
4 salaries
unlock blur

₹4.5 L/yr - ₹4.5 L/yr

Software Developer
3 salaries
unlock blur

₹4.5 L/yr - ₹11 L/yr

Explore more salaries
Compare Diacto with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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