Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Engaged Employer

i

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

Dilyt Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 17 Reviews

Filter interviews by

Dilyt Data Analyst Interview Questions, Process, and Tips

Updated 19 Jul 2024

Dilyt Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 19 Jul 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

(1 Question)

  • Q1. Basic mathematics question, basic English and SQL questions
    • Add your answer
Round 2 - Technical 

(5 Questions)

  • Q1. Resume based questions
    • Add your answer
  • Q2. Different types of commands
  • Ans. 

    Different types of commands include data manipulation, data definition, data control, and transaction control commands.

    • Data manipulation commands: SELECT, INSERT, UPDATE, DELETE

    • Data definition commands: CREATE, ALTER, DROP

    • Data control commands: GRANT, REVOKE

    • Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT

    • Answered by AI
    Add your answer
  • Q3. Difference between inner join and outer join
  • Ans. 

    Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.

    • Inner join only includes rows that have matching values in both tables

    • Outer join includes all rows from both tables, filling in missing values with NULL if there is no match

    • Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id; Outer join - SELECT * FROM table1 LEFT OUTER JOI

    • Answered by AI
    Add your answer
  • Q4. Write SQL query to get second highest salary
  • Ans. 

    SQL query to retrieve the second highest salary from a table

    • Use the ORDER BY clause to sort salaries in descending order

    • Use the LIMIT clause to retrieve the second row

    • Answered by AI
    Add your answer
  • Q5. What's the difference between numpy and pandas
  • Ans. 

    Numpy is a library for numerical operations in Python, while Pandas is used for data manipulation and analysis.

    • Numpy is used for numerical operations like linear algebra, Fourier transform, etc.

    • Pandas is used for data manipulation tasks like data cleaning, merging, reshaping, etc.

    • Numpy works with arrays, while Pandas works with dataframes.

    • Numpy is more efficient for numerical computations, while Pandas is more user-fri...

    • Answered by AI
    Add your answer

Interview Preparation Tips

Topics to prepare for Dilyt Data Analyst interview:
  • SQL
  • Python

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
2w (edited)
timepasstiwari
·
A Digital Markter
Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question
So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..
Got a question about Dilyt?
Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Diverse Lynx user image Anonymous

posted on 12 May 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview before May 2022.

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. Pivot table in excel
  • Ans. 

    Pivot table is a data summarization tool in Excel.

    • Pivot table allows users to summarize and analyze large datasets.

    • It can be used to group data by categories, calculate totals, and create custom calculations.

    • Users can easily change the layout of the table to view data in different ways.

    • Pivot table is a powerful tool for data analysis and reporting.

    • Example: A sales manager can use pivot table to analyze sales data by re

    • Answered by AI
    Add your answer
  • Q2. How to count data in excel
  • Ans. 

    To count data in Excel, use the COUNT function or select the data and look at the status bar.

    • Use the COUNT function to count the number of cells that contain numbers or dates

    • Use the COUNTA function to count the number of cells that are not empty

    • Select the data and look at the status bar to see the count of selected cells

    • Use the COUNTIF function to count cells that meet a specific criteria

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - It’s was good

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Pitney Bowes user image Anonymous

posted on 4 Dec 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL Test with 5 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Approach towards solving the SQL Queries from the test
    • Add your answer
  • Q2. Past Experiences
    • Add your answer
Round 3 - One-on-one 

(2 Questions)

  • Q1. Resume related Questions
    • Add your answer
  • Q2. Power BI and SQL related questions. How to approach in a dashboard building process
    • Add your answer

Data Analyst Interview Questions & Answers

HCL Infosystems user image Anonymous

posted on 5 Jan 2022

Interview Questionnaire 

1 Question

  • Q1. Situation based question on experience
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for what is in CV

Business Analyst Interview Questions & Answers

HCL Infosystems user image Anonymous

posted on 12 Nov 2021

I applied via Referral and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Related to work profile
    • Add your answer
  • Q2. Related to interests
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, go well groomed

Business Analyst Interview Questions & Answers

HCL Infosystems user image Anonymous

posted on 16 Aug 2021

Interview Questionnaire 

2 Questions

  • Q1. Yell me about yourself
    • Add your answer
  • Q2. How uh celebrated ur last birthday
    • Add your answer

Business Analyst Interview Questions & Answers

DynPro user image Akbarali786

posted on 23 Oct 2024

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

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

Round 1 - HR 

(4 Questions)

  • Q1. About ourselves
    • Add your answer
  • Q2. Professional experience
    • Add your answer
  • Q3. Salary expectation
    • Add your answer
  • Q4. Notice period, if experienced
    • Add your answer

Business Analyst Interview Questions & Answers

Solartis Technology Services user image Anonymous

posted on 22 Jul 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected
Round 1 - Aptitude Test 

20 General MCQs were asked

Round 2 - Group Discussion 

Group discussion on any topic

Round 3 - Technical 

(3 Questions)

  • Q1. Self Introduction
    • Add your answer
  • Q2. How do you see yourself as the right fit in Solartis?
    • Add your answer
  • Q3. What was your college final project.
    • Add your answer
Round 4 - HR 

(2 Questions)

  • Q1. Salary Discussion
    • Add your answer
  • Q2. Terms and Conditions
    • Add your answer

Business Analyst Interview Questions & Answers

Solartis Technology Services user image Anonymous

posted on 28 Feb 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Who is a BA Role of a BA Scenario based questions Questions in area of interest Questions on project
    • Add your answer

Business Analyst Interview Questions & Answers

Solartis Technology Services user image Anonymous

posted on 23 Sep 2024

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

I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions but less time to solve.

Round 2 - Group Discussion 

Basic topics given such as social media and work life balance.

Round 3 - HR 

(2 Questions)

  • Q1. Self introduction
    • Add your answer
  • Q2. Why did you choose our company?
  • Ans. 

    I chose your company because of its reputation for innovation and commitment to employee development.

    • Impressed by the company's track record of successful projects

    • Positive reviews from current and former employees

    • Opportunities for growth and advancement within the company

    • Answered by AI
    Add your answer
More about working at Dilyt

Dilyt Interview FAQs

How many rounds are there in Dilyt Data Analyst interview?
Dilyt interview process usually has 2 rounds. The most common rounds in the Dilyt interview process are Aptitude Test and Technical.
What are the top questions asked in Dilyt Data Analyst interview?

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

  1. What's the difference between numpy and pan...read more
  2. Difference between inner join and outer j...read more
  3. Write SQL query to get second highest sal...read more

Tell us how to improve this page.

Dilyt Interviews By Designations

Interview Questions for Popular Designations

Dilyt Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

HCL Infosystems Interview Questions
3.9
 • 140 Interviews
Solartis Technology Services Interview Questions
3.6
 • 28 Interviews
Zebra Technologies Interview Questions
3.9
 • 26 Interviews
Sagitec Solutions Interview Questions
3.8
 • 22 Interviews
Pitney Bowes Interview Questions
3.8
 • 21 Interviews
Diverse Lynx Interview Questions
3.8
 • 19 Interviews
American Megatrends Interview Questions
3.6
 • 18 Interviews
DynPro Interview Questions
3.8
 • 18 Interviews
Dahua Technology India Pvt.Ltd. Interview Questions
3.5
 • 18 Interviews
Starmark Software Interview Questions
3.5
 • 17 Interviews
View all
Dilyt Salaries in India
BI Developer
19 salaries
unlock blur

₹2.4 L/yr - ₹4.5 L/yr

ETL Developer
9 salaries
unlock blur

₹2.2 L/yr - ₹4.5 L/yr

Business Intelligence Developer
7 salaries
unlock blur

₹2.4 L/yr - ₹3.9 L/yr

Software Engineer
5 salaries
unlock blur

₹2 L/yr - ₹6.7 L/yr

Business Development Executive
4 salaries
unlock blur

₹4 L/yr - ₹8.5 L/yr

Explore more salaries
Compare Dilyt with

HCL Infosystems

3.9
Compare

Accel Frontline

4.0
Compare

Diverse Lynx

3.8
Compare

Pitney Bowes

3.8
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview