Diya Systems Technical Lead Interview Questions and Answers

Q1. Which type Scheduler you used in ADF ?
Ans. 
I have used the built-in scheduler in Azure Data Factory (ADF).
• ADF provides a built-in scheduler that allows you to schedule and orchestrate data integration and data transformation activities.

• The scheduler in ADF supports various scheduling options such as time-based, event-based, and tumbling window triggers.

• You can define the schedule for your pipelines and activities using JSON-based expressions.

• For example, you ca...read more
Answered by AI
View 3 more answers
Q2. How do you perform sql query optimization ?
Ans. 
SQL query optimization involves analyzing and modifying queries to improve performance.
• Identify and eliminate unnecessary or redundant queries

• Use appropriate indexes to speed up data retrieval

• Optimize query structure and syntax

• Avoid using wildcard characters at the beginning of a LIKE statement

• Minimize the use of subqueries

• Use EXPLAIN or query execution plans to identify bottlenecks

• Consider denormalizing tables for fre...read more
Answered by AI
View 2 more answers

Q1. Tell me about yourself.
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. What are your salary expectations?
Add your answer

Q1. About yourself and regards studies
Add your answer

Finance related questions in a group discussion

Q1. They will tell you to attend a quality test for selection
Add your answer

Do quality test with full concentration otherwise you'll get an error and they will reject you.

Apptitude has two sections one is mathematics and another one physcemetric test

Q1. About education and family background
Add your answer

Q1. The talent team explains one topic and that we have to type in binder
Add your answer

Q1. The quality test will be there for six day if we clear this direct offer letter they will give
Add your answer

They will ask some basic maths english qualitative questions online exam conducted.

Q1. First 4 days they will train for the Qualitative assesment other 2 days u have to perform in the QA.without any error. One error and ur disqualified. In those 6 days u can feel how a corporate company work...read more
Add your answer
Q2. After that one PW session was their.
Add your answer

Puzzle, Bubble shoot in Mathematics, English error spotting. do not click on the wrong answers, it will cause negative marks.

Self introduction about 1-3 minutes, to check the communication skills and Procedure writing, where we need to understand and note down the procedure explained by the trainer and type in the system.

Q1. First they give training on the process. Then we need to work on it for six days, for first three days they give exceptions for errors we do while processing, but on the fourth day to sixth day we must giv...read more
Add your answer
Q2. Concentrate on the work
Add your answer

Logical puzzle questions

MVR training, explain the motor vehicle after the text will be there

Insurance purpose assignment