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
Compare
Filter interviews by
Dilyt Interview Questions, Process, and Tips
Updated
30 Oct 2024
Top Dilyt Interview Questions and Answers
- Q1. How would prepare an emplyees attendance record? Create charts and graphs regarding it.asked in Business Intelligence Developer Analyst interview
- Q2. What's the difference between numpy and pandasasked in Data Analyst interview
- Q3. what is commondsasked in Junior Business Intelligence Developer interview
Popular Job Profiles
8 Dilyt Interview Experiences
29 questions found
Sort by:
Popular
Anonymous
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Walk-in and was interviewed in May 2024.
3 Interview Rounds
1
Aptitude Test Round
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
2
HR Round (2 Questions)
- Q1. Self introduction Add Answer
- Q2. Okay with the SLA View Answers (1)
3
Technical Round (7 Questions)
- Q1. What is the difference between DDL and DML? View Answers (1)
- Q2. How to fetch a employee record with the second highest salary from the employees table? Add Answer
- Q3. What was one of the trickiest incident you have faced and how did you counter it? Add Answer
- Q4. How SQL is divided? View Answers (1)
- Q5. How would prepare an emplyees attendance record? Create charts and graphs regarding it. View Answers (1)
- Q6. Difference between SQL and MYSQL View Answers (1)
- Q7. Define joins using examples. View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Got the invite through naukri.com
On day 1 there were 3 rounds.
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
2nd round was HR round where resume related questions like qualification and projects are asked along with a basic question of interest in this field. This round will be of 5 to 15 minutes max.
3rd round was technical round where questions related to the technical expertise is asked. This round is a bit tough but if prepared well in advanced can be done easily. This round will last upto somewhere around 30 to 45 mins on an avg.
All the rounds were of basic level but the wait time is more as there were many candidates for the post.
Tip: prepare well with basic SQL queries as they are mostly asked and if answered well gives an advantage.
After these three rounds was asked to wait for 1 week for the results.
Qs
1. What is the difference between DDL and DML?
2. How to fetch a employee record with the second highest salary from the employees table?
3. What was one of the trickiest incident you have faced and how did you counter it?
4. How SQL is divided?
5. Difference between SQL and MYSQL
6. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
7. Define SQL set using some examples.
8. Define joins using examples.
9. What is a constraint?
10. What is primary key?
11. What is foreign key?
12. What is tableau?
13. How tableau connection is established?
14. How many types of filters are there in tableau?
15. How KPI metrics can be depicted in tableau?
16. How dashboards are made?
17. What is the difference between dashborading and report generation?
18. What is storytelling?
19. Difference between Power BI and tableau
20. Which one do you prefer tableau or Power BI and why?
21. Data types in SQL
On day 1 there were 3 rounds.
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
2nd round was HR round where resume related questions like qualification and projects are asked along with a basic question of interest in this field. This round will be of 5 to 15 minutes max.
3rd round was technical round where questions related to the technical expertise is asked. This round is a bit tough but if prepared well in advanced can be done easily. This round will last upto somewhere around 30 to 45 mins on an avg.
All the rounds were of basic level but the wait time is more as there were many candidates for the post.
Tip: prepare well with basic SQL queries as they are mostly asked and if answered well gives an advantage.
After these three rounds was asked to wait for 1 week for the results.
Qs
1. What is the difference between DDL and DML?
2. How to fetch a employee record with the second highest salary from the employees table?
3. What was one of the trickiest incident you have faced and how did you counter it?
4. How SQL is divided?
5. Difference between SQL and MYSQL
6. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
7. Define SQL set using some examples.
8. Define joins using examples.
9. What is a constraint?
10. What is primary key?
11. What is foreign key?
12. What is tableau?
13. How tableau connection is established?
14. How many types of filters are there in tableau?
15. How KPI metrics can be depicted in tableau?
16. How dashboards are made?
17. What is the difference between dashborading and report generation?
18. What is storytelling?
19. Difference between Power BI and tableau
20. Which one do you prefer tableau or Power BI and why?
21. Data types in SQL
Skills evaluated in this interview
dirisala pradeepthi
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
4 Interview Rounds
1
Aptitude Test Round
Aptitude, basic sql queries and power bi related question
2
HR Round (1 Question)
- Q1. Self intro , projects and related to resume Add Answer
3
Technical Round (1 Question)
- Q1. Sql queries and power bi questions Add Answer
4
Technical Round (1 Question)
- Q1. Create a attendance report View Answers (1)
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Coding Test Round
Second highest salary
union, union all, intersect and except or minus
case statement questions
2
HR Round (3 Questions)
- Q1. Tell me about your self
explain the visuals of power bi
what is constrains
what is commonds View Answers (1)
- Q2. Explain the power bi visuals View Answers (1)
- Q3. What is commonds View Answers (1)
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Jan 2024.
2 Interview Rounds
1
Aptitude Test Round (1 Question)
- Q1. Basic mathematics question, basic English and SQL questions Add Answer
2
Technical Round (5 Questions)
- Q1. Resume based questions Add Answer
- Q2. Different types of commands View Answers (1)
- Q3. Difference between inner join and outer join View Answers (1)
- Q4. Write SQL query to get second highest salary View Answers (1)
- Q5. What's the difference between numpy and pandas View Answers (1)
Interview Preparation Tips
Topics to prepare for Dilyt Data Analyst interview:
- SQL
- Python
Skills evaluated in this interview
Dilyt interview questions for popular designations
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Aptitude Test Round
Questions based on SQL and powerbi were asked
2
HR Round (1 Question)
- Q1. Basic hr questions Add Answer
3
One-on-one Round (1 Question)
- Q1. Basic SQL queries Add Answer
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Aptitude Test Round
SQL commands, query,union union all ,maths English spelling, correct sentence.
2
HR Round (2 Questions)
- Q1. Personal introduction Add Answer
- Q2. College life ,career gap details asking. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be confident, prepare excel vlookup ,SQL commands questions
Jobs at Dilyt
NAVEEN KUMAR KAJULURI
Interview experience
Poor
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Jul 2023.
4 Interview Rounds
1
Resume Shortlist Round
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
2
Assignment Round
Maths, GK, English, Coding, Behaviour Questions.
3
HR Round (1 Question)
- Q1. Personal Questions, Resume Based Questions Add Answer
4
Technical Round (2 Questions)
- Q1. SQL, Power BI Based Questions. Add Answer
- Q2. Power Query, Editor. Add Answer
Interview Preparation Tips
Topics to prepare for Dilyt SQL and BI Developer interview:
- MY SQL
- Power Bi
chittiboyina padmasree
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (5 Questions)
- Q1. How would you handle Agile Transformation to Productize an existing Team View Answers (1)
- Q2. How to manage High Technical Skilled resources who do not follow any process View Answers (1)
- Q3. What would you propose to build a scrum team View Answers (1)
- Q4. Do you hvae experience of Managing Complex Team dynamics View Answers (1)
- Q5. When did you last use Agile Processes View Answers (1)
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Mvvm and Mvc architectures Add Answer
- Q2. Gave Code snippets to find the output Add Answer
- Q3. Swift basics and concepts like memory management Add Answer
- Q4. Oops concepts and solid principles Add Answer
Dilyt Interview FAQs
How many rounds are there in Dilyt interview?
Dilyt interview process usually has 2-3 rounds. The most common rounds in the Dilyt interview process are HR, Technical and Aptitude Test.
How to prepare for Dilyt 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 Dilyt. The most common topics and skills that interviewers at Dilyt expect are Business Intelligence, IT Services, Performance Management, Data Analytics and Information Technology.
What are the top questions asked in Dilyt interview?
Tell us how to improve this page.
Dilyt Interviews By Designations
- Dilyt Power BI Developer Interview Questions
- Dilyt BI Developer Interview Questions
- Dilyt Business Intelligence Developer Analyst Interview Questions
- Dilyt Data Analyst Interview Questions
- Dilyt Junior Business Intelligence Developer Interview Questions
- Dilyt SQL and BI Developer Interview Questions
Interview Questions for Popular Designations
Interview Process at Dilyt
based on 6 interviews in last 1 year
Interview experience
People are getting interviews through
based on 3 Dilyt interviews
Job Portal
WalkIn
67%
33%
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Interview Questions from Similar Companies
|
BI Developer
19
salaries
|  ₹2.4 L/yr - ₹4.5 L/yr |
|
ETL Developer
9
salaries
| ₹2.2 L/yr - ₹4.5 L/yr |
|
Business Intelligence Developer
7
salaries
| ₹2.4 L/yr - ₹3 L/yr |
|
Software Engineer
5
salaries
| ₹2 L/yr - ₹6.7 L/yr |
|
Software Developer
4
salaries
| ₹3 L/yr - ₹9 L/yr |
Explore more salaries
Compare Dilyt with
HCL Infosystems
Compare
Accel Frontline
Compare
Diverse Lynx
Compare
Solartis Technology Services
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
- Home >
- Interviews >
- Dilyt Interview Questions
Share an Interview