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
(1 Question)
- Q1. Previous year experience
(1 Question)
- Q1. Type of value added to the company
- Ans.
I add value to the company by leveraging my skills and experience to drive growth, improve efficiency, and enhance overall performance.
Implementing cost-saving initiatives
Developing innovative solutions to challenges
Improving processes and workflows
Increasing revenue through strategic partnerships
Enhancing customer satisfaction and retention
Nitharsana Natarajan
Selected
I applied via Referral and was interviewed in Jul 2023. There were 2 interview rounds.
(1 Question)
- Q1. Tell about my self and experience
(1 Question)
- Q1. Telling about myself and my experience with my manager
(2 Questions)
- Q1. About my self and experience
- Q2. About my hobbies
(2 Questions)
- Q1. Document verify
- Q2. Tel about my favorite topic
- Ans.
My favorite topic is artificial intelligence and its impact on society.
AI has revolutionized various industries such as healthcare, finance, and transportation
Ethical considerations surrounding AI development and deployment are crucial
AI has the potential to both improve and disrupt society in significant ways
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Oct 2022. There were 4 interview rounds.
(2 Questions)
- Q1. More about requirement
- Q2. More on Past work experience
(2 Questions)
- Q1. About the Job description
- Q2. Detailed discussion with client on roles n responsibilities
(1 Question)
- Q1. Salary n other discussion
Team Lead Interview Questions & Answers
TekisHub Consulting Services
Anonymous
posted on 20 Dec 2024
(1 Question)
- Q1. What is recruitment
Interview Questionnaire
1 Question
- Q1. Data warehouse concepts, Scd with examples, Sql Queries
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
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 Devops Engineer Interview Questions
- On Demand Agility Software Technical Architect Interview Questions
- On Demand Agility Software Business Analyst Interview Questions
- On Demand Agility Software Lead Business Analyst 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
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 |
Value Point Systems
JoulestoWatts Business Solutions
Saama Technologies
DISYS
- Home >
- Interviews >
- On Demand Agility Software Interview Questions >
- On Demand Agility Software Technical Lead Interview Questions
