i
Innovaccer
Filter interviews by
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
Developed a mobile app for tracking personal fitness goals
Used React Native to create a cross-platform app
Implemented features such as goal setting, progress tracking, and workout logging
Integrated with wearable devices like Fitbit for automatic data syncing
Ways to speed up SQL queries in increasing order of complexity
Use indexes on columns frequently used in WHERE clauses
Optimize queries by avoiding unnecessary joins and subqueries
Use stored procedures to reduce network traffic and improve performance
Consider denormalizing tables for frequently accessed data
Use query optimization techniques like query caching and query hints
Redis is single-threaded.
Redis is single-threaded, meaning it can only execute one command at a time.
This design choice allows Redis to be extremely fast and efficient for certain use cases.
However, it also means that Redis may not be the best choice for highly concurrent workloads.
Data types that can be used as keys in Python include strings, integers, floats, tuples, and custom objects.
Strings are commonly used as keys in Python dictionaries.
Integers and floats can also be used as keys.
Tuples can be used as keys if they only contain immutable elements.
Custom objects can be used as keys if they are hashable.
Examples: {'name': 'John'}, {1: 'apple'}, {(1, 2): 'tuple'}
Types of indexing in SQL include clustered, non-clustered, unique, and composite indexes.
Clustered index physically reorders the table based on the index key
Non-clustered index creates a separate structure for the index
Unique index ensures that all values in the index column are unique
Composite index uses multiple columns for indexing
Top trending discussions
posted on 11 Dec 2024
I applied via LinkedIn and was interviewed in Nov 2024. There were 3 interview rounds.
posted on 9 Oct 2024
I applied via Job Portal and was interviewed in Oct 2024. There were 3 interview rounds.
posted on 5 Oct 2024
Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class.
Allows a class to inherit attributes and methods from another class
Promotes code reusability and reduces redundancy
Creates a parent-child relationship between classes
Derived class can override or extend the functionality of the base class
Types of joins in MySQL include inner join, left join, right join, and full join.
Inner join: Returns rows when there is a match in both tables.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
Full join: Returns rows when there is a match in one of the tables.
Use a centralized API gateway to manage and route requests to multiple APIs efficiently.
Implement a centralized API gateway to handle incoming requests and route them to the appropriate API based on the endpoint.
Utilize API management tools like Apigee, Kong, or AWS API Gateway to manage and monitor multiple APIs.
Consider implementing a caching layer to improve performance and reduce the number of requests to external
strstr function searches for a substring within a string and returns a pointer to the first occurrence of the substring.
Used in C programming language
Syntax: char *strstr(const char *haystack, const char *needle)
Example: char *str = strstr("hello world", "world")
I applied via LinkedIn and was interviewed in Nov 2024. There were 2 interview rounds.
Maths ,english ,reasoning, puzzles
Jackeron was the platform
Big data refers to large volumes of structured and unstructured data that is too complex for traditional data processing applications.
Big data involves processing and analyzing large volumes of data to uncover patterns, trends, and insights.
It can come from various sources such as social media, sensors, devices, and business transactions.
Examples of big data technologies include Hadoop, Spark, and NoSQL databases.
Big d...
I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.
The topic given to me is AI is good or bad
A program to find prime numbers in a given range.
Iterate through numbers in the given range
Check if each number is divisible by any number other than 1 and itself
If not divisible, then the number is prime
Program to find duplicates in an array of strings
Iterate through the array and store each element in a hash set
If an element is already in the hash set, it is a duplicate
Return a list of all duplicates found
The project code is a web application that allows users to create and share interactive quizzes.
The code uses HTML, CSS, and JavaScript to create the front-end interface.
It utilizes Node.js and Express for the back-end server.
MongoDB is used as the database to store user-generated quizzes.
Socket.io is used for real-time communication between users during quiz sessions.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Data Analyst
308
salaries
| ₹5 L/yr - ₹16 L/yr |
Senior Data Analyst
167
salaries
| ₹8 L/yr - ₹24 L/yr |
Associate Software Engineer
96
salaries
| ₹6 L/yr - ₹10 L/yr |
Data Engineer
68
salaries
| ₹4.9 L/yr - ₹16 L/yr |
Software Development Engineer II
63
salaries
| ₹16 L/yr - ₹34 L/yr |
Practo
Lybrate
Portea Medical
PharmEasy