Add office photos
i
Optimum Infosystem
Compare
Filter interviews by
Optimum Infosystem Senior Project Leader Interview Questions and Answers
Optimum Infosystem Senior Project Leader Interview Experiences
1 interview found
Guru Kalle
I applied via Recruitment Consultant and was interviewed before Oct 2019. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. They asked one question about my experience, as well as one or 2 questions about IBM Websphere MQ
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Anonymous
(5 Questions)
- Q1. Difference between first() or FirstOrDefault()
- Ans.
first() returns the first element of a sequence, while FirstOrDefault() returns the first element or a default value if the sequence is empty.
first() throws an exception if the sequence is empty, while FirstOrDefault() returns a default value (e.g. null) in that case.
Use first() when you expect the sequence to always have at least one element, and FirstOrDefault() when the sequence might be empty.
Example: var numbers =...
- Q2. Left join vs right join
- Ans.
Left join includes all records from the left table and matching records from the right table, while right join includes all records from the right table and matching records from the left table.
Left join: includes all records from the left table and matching records from the right table
Right join: includes all records from the right table and matching records from the left table
Example: Left join - SELECT * FROM table1...
- Q3. Optimization of SQL query
- Ans.
Optimizing SQL queries involves using indexes, minimizing joins, and avoiding unnecessary columns.
Use indexes on columns frequently used in WHERE clauses
Minimize the use of JOIN operations
Avoid selecting unnecessary columns in the query
Consider using stored procedures for frequently executed queries
- Q4. Tool used to check query slowness
- Ans.
One tool used to check query slowness is SQL Server Profiler.
SQL Server Profiler can be used to trace and analyze query performance.
It provides detailed information on query execution, including duration, reads, writes, and more.
Users can identify slow queries and optimize them for better performance.
Other tools like Query Store in SQL Server Management Studio can also be used for monitoring query performance.
- Q5. Design repository pattern using EF core
- Ans.
Repository pattern using EF core for data access layer
Create an interface for the repository with generic CRUD methods
Implement the repository interface with EF core for data access
Use dependency injection to inject the repository into services
Separate concerns by having repositories handle data access logic
Skills evaluated in this interview
(2 Questions)
- Q1. Explain day to day activity as Pm
- Ans.
As a Project Manager, day to day activities include overseeing project progress, communicating with team members and stakeholders, resolving issues, and tracking deadlines.
Communicating with team members and stakeholders to provide updates and gather feedback
Monitoring project progress and ensuring tasks are completed on time
Identifying and resolving any issues or roadblocks that may arise
Tracking deadlines and ensurin...
- Q2. How strong you are in communication skills
- Ans.
I am highly skilled in communication, with experience in leading project teams and effectively conveying information.
I have experience leading project teams and effectively conveying information
I am skilled in written and verbal communication
I am able to tailor my communication style to different audiences
I have experience in conflict resolution and negotiation
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Nov 2023. There were 3 interview rounds.
(1 Question)
- Q1. Based on experience technical questions
(1 Question)
- Q1. Based on software life cycle questions
I applied via Approached by Company and was interviewed in Jul 2023. There were 4 interview rounds.
(1 Question)
- Q1. Related to profile
(1 Question)
- Q1. Related to project
(1 Question)
- Q1. Job profile and generic
I applied via Company Website and was interviewed in Sep 2022. There were 3 interview rounds.
(5 Questions)
- Q1. Which project you work have done?
- Q2. Which collage you done polytechnic?
- Ans.
I completed my polytechnic from XYZ College.
I pursued my polytechnic studies from XYZ College.
I gained valuable knowledge and skills in engineering from my college.
My college provided me with hands-on experience through practical sessions and projects.
I was able to network with industry professionals and alumni through various events organized by my college.
- Q3. Have knowledge in Autocad?
- Ans.
Yes, I have knowledge in Autocad.
I have experience in creating 2D and 3D drawings using Autocad.
I am proficient in using Autocad tools such as layers, blocks, and dimensions.
I have used Autocad for designing mechanical parts and assemblies.
I am familiar with Autocad's interface and commands.
- Q4. Shortcut key of circle?
- Ans.
The shortcut key for circle is 'O'
Press 'O' key to draw a circle in most design software
Can be used in Adobe Illustrator, AutoCAD, SketchUp, etc.
- Q5. Shortcut key of line?
- Ans.
The shortcut key for line is Ctrl+L.
Press Ctrl+L to draw a straight line in most design software.
The line tool can be found in the toolbar of most design software.
Lines can be customized by adjusting their thickness, color, and style.
When was you relocate in here?
Interview Preparation Tips
- Mechanical Engineering
- Autocadd
(2 Questions)
- Q1. Tell something about yourself
- Q2. Explain your experience as a manager
Interview Preparation Tips
Selected
I applied via Job Portal and was interviewed before Mar 2023. There was 1 interview round.
(2 Questions)
- Q1. How you handled project
- Q2. Mentioned end to end how I handled the project
Interview Preparation Tips
I applied via Campus Placement and was interviewed in May 2022. There were 3 interview rounds.
Check your activity. And professional prasanality development.
How to do planning hendal of project work
Interview Preparation Tips
- Pharmaceutical engineering
Thanks
Associate Technical Leader Interview Questions & Answers
TO THE NEW
Nishant Singh
posted on 6 Jun 2024
I applied via Recruitment Consulltant
(2 Questions)
- Q1. Well architect framework
- Q2. 3 tier arch questions
Tell us how to improve this page.
Optimum Infosystem Interviews By Designations
- Optimum Infosystem Senior Consultant Interview Questions
- Optimum Infosystem Senior Java Developer Interview Questions
- Optimum Infosystem Software Developer Interview Questions
- Optimum Infosystem Consultant Interview Questions
- Optimum Infosystem Lead Consultant Interview Questions
- Optimum Infosystem Senior Developer Interview Questions
- Optimum Infosystem Senior Manager Interview Questions
- Optimum Infosystem Account Executive 1 Interview Questions
- Show more
Interview Questions for Popular Designations
- Project Lead Interview Questions
- Project Associate Interview Questions
- Technical Project Manager Interview Questions
- Associate Technical Leader Interview Questions
- Project Manager Interview Questions
- Project Engineer Interview Questions
- Project Manager Scrum Master Interview Questions
- IT Project Manager Interview Questions
- Show more
Interview Questions from Similar Companies
|
Senior Consultant
364
salaries
|  ₹8 L/yr - ₹30.2 L/yr |
|
Consultant
233
salaries
| ₹5 L/yr - ₹18.9 L/yr |
|
Lead Consultant
91
salaries
| ₹9.5 L/yr - ₹35.3 L/yr |
|
Senior Software Engineer
77
salaries
| ₹9 L/yr - ₹34 L/yr |
|
Associate Consultant
74
salaries
| ₹2.8 L/yr - ₹9.5 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Optimum Infosystem Interview Questions >
- Optimum Infosystem Senior Project Leader Interview Questions
