i
Optimum Infosystem
Filter interviews by
I applied via Naukri.com and was interviewed in Jan 2023. There were 3 interview rounds.
Sql questions, python questions
List comprehension is a concise way to create lists in Python. Constructor is a special method used to initialize objects. Schemas are blueprints for organizing data.
List comprehension is a shorthand way to create lists in Python
It is a concise way to write a for loop and append to a list in a single line
Example: squares = [x**2 for x in range(10)]
Constructor is a special method used to initialize objects
It is called w...
DBMS stands for Database Management System. SQL is a programming language used to manage and manipulate data in DBMS.
DBMS is a software system that allows users to create, manage, and manipulate databases.
SQL (Structured Query Language) is a programming language used to communicate with DBMS and perform operations on data.
DBMS and SQL are used in various industries such as finance, healthcare, and e-commerce.
Examples o...
I was interviewed before Sep 2023.
Managed project timelines, client communication, and team coordination in previous roles.
Led cross-functional teams to deliver projects on time and within budget
Communicated project updates and milestones to clients regularly
Coordinated with internal teams to ensure smooth project execution
Managed stakeholder expectations and addressed any issues or concerns promptly
GIve examples of microservice you implemented
Using nested loops in Springboot to iterate over a list of objects
Create a list of objects to iterate over
Use nested for loops to iterate over the list
Access the properties of each object within the nested loops
Android development apk creation involves compiling the code into an executable file for installation on Android devices.
Write the code in Java or Kotlin
Use Android Studio to build and compile the code
Generate a signed APK for distribution
Test the APK on different devices to ensure compatibility
Latency delisting refers to removing items from a list due to excessive delay.
Latency delisting is common in online marketplaces where products with slow shipping times are removed from search results.
In finance, stocks with significant delays in reporting financial information may be delisted from exchanges.
In healthcare, medications with long wait times for regulatory approval may be delisted from formularies.
I applied via Approached by Company and was interviewed in Aug 2023. There were 3 interview rounds.
Optimum Infosystem interview questions for designations
I applied via Recruitment Consulltant and was interviewed before Jan 2023. There was 1 interview round.
Get interview-ready with Top Optimum Infosystem Interview Questions
I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.
Redux flow involves dispatching actions, updating the store, and triggering re-rendering of components.
Actions are dispatched from components
Reducers update the store based on the action
Store notifies subscribed components of state change
Components re-render with updated state
Hooks are functions that let you use state and other React features without writing a class.
Hooks are introduced in React 16.8
Rules of hooks are: Only call hooks at the top level, Only call hooks from React functions, Only call hooks from custom hooks
Examples of hooks are useState, useEffect, useContext, useReducer, useMemo, useCallback, useRef
Display flex is a CSS property that allows flexible layout of elements within a container.
It enables responsive design by automatically adjusting the size and position of elements
It allows for easy alignment and distribution of elements along the main and cross axis
It can be used to create complex layouts with minimal code
It supports both horizontal and vertical layouts
Example: display: flex; justify-content: center; a
I applied via Naukri.com and was interviewed before Jul 2022. There were 3 interview rounds.
How many time did you loop it or how to if then for loop and all
I have savings, investments, and a strong network for potential job opportunities.
I have a substantial emergency savings fund that can cover my expenses for several months.
I have diversified investments that can provide additional financial support if needed.
I have a strong professional network that can help me find new job opportunities quickly.
I am open to exploring freelance or consulting opportunities to generate i
I applied via Naukri.com and was interviewed before Jun 2022. There were 3 interview rounds.
SQL MODE METER DATA is a setting that determines how strict or lenient MySQL is when handling invalid or missing values in queries.
SQL MODE METER DATA is a configuration setting in MySQL that affects how queries are processed.
It determines the behavior of MySQL when encountering invalid or missing values in queries.
It can be set to different modes like STRICT_ALL_TABLES, TRADITIONAL, etc.
For example, in STRICT_ALL_TABL...
Inner joins are used to return rows that have matching values in both tables, while outer joins return all rows from one table and only matching rows from the other table.
Use inner join to retrieve rows with matching values in both tables
Use outer join to retrieve all rows from one table and only matching rows from the other table
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Example: SELECT * ...
I applied via Recruitment Consulltant and was interviewed before Apr 2022. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed before Feb 2021. There were 3 interview rounds.
TPRM related
Top trending discussions
The duration of Optimum Infosystem Senior Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 87 reviews
Rating in categories
Senior Consultant
361
salaries
| ₹7.5 L/yr - ₹30.3 L/yr |
Consultant
249
salaries
| ₹5.5 L/yr - ₹19.5 L/yr |
Lead Consultant
77
salaries
| ₹9.3 L/yr - ₹35.3 L/yr |
Senior Software Engineer
76
salaries
| ₹9 L/yr - ₹27.8 L/yr |
Associate Consultant
71
salaries
| ₹2.8 L/yr - ₹9.9 L/yr |
TCS
Infosys
Wipro
HCLTech