Upload Button Icon Add office photos

Filter interviews by

Diya Systems Technical Lead Interview Questions and Answers for Experienced

Updated 16 Jul 2024

Diya Systems Technical Lead Interview Experiences for Experienced

1 interview found

Technical Lead Interview Questions & Answers

user image Diyansha Sharma

posted on 16 Jul 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It was not that difficult, simple apti questions

Round 2 - Technical 

(2 Questions)

  • Q1. What is domain?
  • Ans. 

    Domain is the area of expertise or knowledge that a person or organization specializes in.

    • Domain refers to a specific subject or field of study.

    • It can also refer to the range of values that a function can take.

    • For example, in software development, a domain expert is someone who has specialized knowledge in a particular industry or topic.

    • In mathematics, the domain of a function is the set of input values for which the f

  • Answered by AI
  • Q2. What is web hosting?
  • Ans. 

    Web hosting is a service that allows individuals and organizations to make their website accessible via the World Wide Web.

    • Web hosting providers store website files on servers connected to the internet

    • Users can access the website by typing the domain name in a web browser

    • Different types of web hosting include shared hosting, VPS hosting, and dedicated hosting

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Expected salary
  • Q2. Where you see yourself in next 5 years

Skills evaluated in this interview

Interview questions from similar companies

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 - One-on-one 

(2 Questions)

  • 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...

  • Answered by AI
  • 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...

  • Answered by AI
Round 3 - HR 

(3 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Over all good experience. They are asking good quality of interview question and interviewer is very energetic.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Technical about SQL, Unix and domain
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • 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...

  • Answered by AI
  • 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...

  • Answered by AI
Round 3 - HR 

(3 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Over all good experience. They are asking good quality of interview question and interviewer is very energetic.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Aug 2020. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Tell me something about yourself
  • Ans. This an open ended question and trust me the ball can be in your court if your "about yourself" is impressive
  • Answered Anonymously
  • Q2. Your role in previous company
  • Ans. You need to speak about this in detail with a good example on how you dealt with irate customers and try to speak as much as you can on this topic which not only include the job description but also how you were important and suitable for that role
  • Answered Anonymously
  • Q3. Why did you leave your last job
  • Ans. Now this is something very important. Don't start complaining about your last job, or salary because it's you who joined the company knowing what they will pay you but yes you can always say that you are looking for a change to up skill yourself and implement what you have learnt there, so that you can grow as fast as the industry is growing
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident enough when you speak about yourself, your strength and weakness. Don't lie. In case you don't know something, feel free to accept it. You can question back the same politely to show you are keen to learn. Adhere to a neutral accent free of MTI. And the most important is VERSANT TEST you need to crack it! All the best.

Diya Systems Interview FAQs

How many rounds are there in Diya Systems Technical Lead interview for experienced candidates?
Diya Systems interview process for experienced candidates usually has 3 rounds. The most common rounds in the Diya Systems interview process for experienced candidates are Aptitude Test, Technical and HR.
What are the top questions asked in Diya Systems Technical Lead interview for experienced candidates?

Some of the top questions asked at the Diya Systems Technical Lead interview for experienced candidates -

  1. What is doma...read more
  2. What is web hosti...read more

Tell us how to improve this page.

Diya Systems Technical Lead Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

3.0

Work-Life balance

2.0

Salary & Benefits

4.0

Job Security

4.0

Company culture

3.0

Promotions/Appraisal

3.0

Work Satisfaction

Explore 1 Review and Rating
Technical Support Engineer
191 salaries
unlock blur

₹1.6 L/yr - ₹4 L/yr

Junior Administrator
86 salaries
unlock blur

₹1.7 L/yr - ₹3.5 L/yr

Software Engineer
36 salaries
unlock blur

₹2.2 L/yr - ₹8.7 L/yr

Senior Software Engineer
36 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Junior Support Engineer
35 salaries
unlock blur

₹2 L/yr - ₹3.1 L/yr

Explore more salaries
Compare Diya Systems with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
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
write
Share an Interview