AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
On Demand Agility Software Technical Lead Interview Questions and Answers
On Demand Agility Software Technical Lead Interview Experiences
3 interviews found
I applied via Naukri.com
(2 Questions)
- Q1. L1 interview Technical
- Q2. Join, constraints, merge, procedure, package, cursor
(1 Question)
- Q1. Plsql development interview, performance tuning, bulk bind, advanced plsql
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2021. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What are indexes ?
- Ans.
Indexes are data structures that improve the speed of data retrieval operations on a database table.
Indexes are created on one or more columns of a table.
They allow the database to quickly find the rows that match a search condition.
Indexes can be unique or non-unique.
Unique indexes ensure that no two rows have the same value for the indexed columns.
Non-unique indexes allow duplicate values for the indexed columns.
Inde...
- Q2. What is query explain plan ?
- Ans.
Query explain plan is a tool used to analyze and optimize SQL queries.
It shows the steps taken by the database to execute a query
It helps identify performance bottlenecks and optimize the query
It can be generated using EXPLAIN or EXPLAIN PLAN statement
It shows the order of table access, join methods, and data access methods
- Q3. Query optimization techniques, triggers, file import export features, bulk collect, bulk binding, materialized view.
Interview Preparation Tips
More of related to query optimization.
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Bulk update and insert code including object creation and table type
- Q2. Stored proc and functions difference including triggers definition and practical example.
- Ans.
Stored procedures and functions are database objects used to perform specific tasks. Triggers are used to execute code in response to specific events.
Stored procedures are precompiled SQL statements that can be executed multiple times.
Functions return a single value and can be used in SQL statements.
Triggers are used to execute code in response to specific events, such as inserting or updating data.
A practical example ...
(1 Question)
- Q1. About previous companies, about family background, onsite work experience
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Technical Lead Interview Questions & Answers
TekisHub Consulting Services
Anonymous
posted on 28 Feb 2023
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 3 interview rounds.
(3 Questions)
- Q1. Why are you looking for a change?
- Q2. What is that you bring skills to the table that can add value to the Company
- Q3. How can you bring value add to the Company
- Ans.
I can bring value to the company by leveraging my technical expertise and leadership skills to drive innovation and improve efficiency.
Identifying and implementing new technologies to streamline processes
Mentoring and coaching team members to enhance their skills and productivity
Collaborating with cross-functional teams to develop and execute strategic plans
Ensuring adherence to industry standards and best practices
Con...
(2 Questions)
- Q1. What is your expectation?
- Q2. How long do you think will continue with the Company
Interview Preparation Tips
I applied via Referral and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. SQL queries, joins, lead lag functions,
- Q2. Unix scripting, snowflake, cloud technology background, practical experience
Interview Preparation Tips
Technical Lead Interview Questions & Answers
TekisHub Consulting Services
Anonymous
posted on 28 Feb 2023
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 3 interview rounds.
(3 Questions)
- Q1. Why are you looking for a change?
- Q2. What is that you bring skills to the table that can add value to the Company
- Q3. How can you bring value add to the Company
- Ans.
I can bring value to the company by leveraging my technical expertise and leadership skills to drive innovation and improve efficiency.
Identifying and implementing new technologies to streamline processes
Mentoring and coaching team members to enhance their skills and productivity
Collaborating with cross-functional teams to develop and execute strategic plans
Ensuring adherence to industry standards and best practices
Con...
(2 Questions)
- Q1. What is your expectation?
- Q2. How long do you think will continue with the Company
Interview Preparation Tips
Selected
I applied via campus placement at ABES Engineering College, Ghaziabad and was interviewed in Feb 2023. There were 3 interview rounds.
(1 Question)
- Q1. I the first round HR will ask you to tell about yourself. My Introduction format was as follows- 1.Good Morning/Afternoon/Evening 2.Thankyou For the opportunity greeting 3.Name and home town 4.Pursuing co...
(1 Question)
- Q1. Where you belong from ? Tell me about schooling ? what are your carrier Goals ? Are you comfortable with night shift ?
- Ans.
I am from XYZ city and completed my schooling from ABC school. My career goal is to become a successful Technical Analyst. Yes, I am comfortable with night shifts.
I belong to XYZ city.
I completed my schooling from ABC school.
My career goal is to become a successful Technical Analyst.
I am comfortable with night shifts.
Interview Preparation Tips
Remember after this you will undergo training and a technical test , which has some small fees.
So this not the end of of journey, its the beginning.
Best of luck.👍
I applied via Referral and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. SQL queries, joins, lead lag functions,
- Q2. Unix scripting, snowflake, cloud technology background, practical experience
Interview Preparation Tips
On Demand Agility Software Interview FAQs
Tell us how to improve this page.
On Demand Agility Software Interviews By Designations
- On Demand Agility Software Technical Lead Interview Questions
- On Demand Agility Software Business Analyst Interview Questions
- On Demand Agility Software Devops Engineer Interview Questions
- On Demand Agility Software Lead Business Analyst Interview Questions
- On Demand Agility Software Technical Architect Interview Questions
Interview Questions for Popular Designations
- Senior Technical Lead Interview Questions
- Technical Specialist Interview Questions
- Member Technical Staff Interview Questions
- Technical Analyst Interview Questions
- Technical Consultant Interview Questions
- Technical Architect Interview Questions
- Associate Technical Consultant Interview Questions
- Associate Technical Leader Interview Questions
- Show more
Technical Lead Interview Questions from Similar Companies
On Demand Agility Software Technical Lead Reviews and Ratings
based on 6 reviews
Rating in categories
|
Technical Lead
36
salaries
|  ₹12 L/yr - ₹38 L/yr |
|
Senior Business Analyst
35
salaries
| ₹8.8 L/yr - ₹27.8 L/yr |
|
Senior Analyst
27
salaries
| ₹5.1 L/yr - ₹18 L/yr |
|
Senior Software Engineer
26
salaries
| ₹8.8 L/yr - ₹28 L/yr |
|
Team Lead
24
salaries
| ₹8.2 L/yr - ₹28.8 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- On Demand Agility Software Interview Questions >
- On Demand Agility Software Technical Lead Interview Questions
