1. General tech questions to assess that the candidate is "qualified" and has the capabilities and experiences to meet the expectations of this Tech Lead role. 2. During face-to-face, interview questions will drill down on areas of design, development, and testing as well as some form of project management and leading a small team. 3. During the final informal coffee session, is more about sharing personal stories and fitting into the culture.
One mathematical question which I answered but interviewer didn't know the answer to reply
What is you notice period
You are expected to work overtime all the time, is that alright with you.
Check if the arithmetic expression is balanced or not in terms of braces () {} []?
More on java collections and microservices
2 round. Basic question and some managerial related questions. Matlab related,solver,step size ,Adas related ,vehicle dynamics,performance analysis,Misra guidelines,maab guidlines. Previous experience question.introduction,online solving problem ,modeling.automtive spice, various features of automotive Thanks
Asked the below questions in the written test. 1. Define Packages and advantages of using packages 2. What information you require for designing a table? 3. What is bulk collect in PLSQL? Illustrate with an example. 4. How can one protect PLSQL source code? 5. Assume that a structure of an employee table is as given below and the employee table data as given below. EMP NO | ENAME | MGR |SAL |HIRE DATE | DEPT NO| 7369 | Smith | 7902 | 800 | 17-Dec-80 | 10 7521 | Wart | 7698 | 1250| 22-Feb-81| 30 6. Write a Query to get the running total of salary on department wise. 7. Write a hierarchical query to get the employee reporting to manager. 8. what are ref cursors? give an example. What are week and strong cursors. 9. Write about application tuning or SQL tuning for performance upgrade. 10. What are the ways of executing a dynamic SQL 11. How a commit or rollback done in table level trigger. 12. What is the difference between a foreign key and a reference key. 13. Name few 11g PLSQL features introduced in oracle 11G. 14. What are exceptions. Name oracle predefined exceptions that you have used in application development. 15. What oracle supplied that you have used/known. 16. What are Varrays/Nested tables. Below questions in the F-F. 1. Tell me about yourself. 2. What is Clustered index? 3. What are all the different types of indexes? 4. oracle 11g new PLSQL features. 5. How to do application/SQL performance tuning.
Can you tell me about your long-term career goals and how this position fits into those plans? How do you see yourself contributing to the team and company? What questions do you have for us?
go through cv and asked about previous positions
Viewing 681 - 690 interview questions