i
Impact
Analytics
Filter interviews by
SQL JOIN functions combine rows from two or more tables based on related columns.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from the right table and matched records ...
Mean, median, and mode are measures of central tendency used to summarize data sets.
Mean: The average of a data set, calculated by summing all values and dividing by the count. Example: For {2, 3, 5}, Mean = (2+3+5)/3 = 3.33.
Median: The middle value when data is sorted. If even number of values, it's the average of the two middle numbers. Example: For {1, 3, 3, 6, 7}, Median = 3.
Mode: The value that appears most f...
Multicollinearity occurs when independent variables in a regression model are highly correlated, affecting model reliability.
Multicollinearity can inflate the variance of coefficient estimates, making them unstable.
It can lead to misleading statistical significance of predictors.
Example: In a model predicting house prices, including both 'square footage' and 'number of rooms' may cause multicollinearity.
Detection ...
Variance Inflation Factor (VIF) quantifies multicollinearity in regression models, indicating how much variance is inflated due to predictors.
VIF measures how much the variance of a regression coefficient is increased due to multicollinearity.
A VIF value of 1 indicates no correlation among predictors, while values above 5-10 suggest high multicollinearity.
For example, if a predictor has a VIF of 15, it indicates t...
Behavioral questions assess how past experiences shape your work style and problem-solving abilities.
Describe a challenging project: Led a team to deliver a complex software solution under tight deadlines, improving efficiency by 30%.
Conflict resolution: Mediated a disagreement between team members, fostering collaboration and resulting in a successful project outcome.
Adaptability: Transitioned from a monolithic a...
The 3 Sum problem involves finding triplets in an array that sum to zero.
Sort the array to simplify finding triplets. Example: [-1, 0, 1, 2, -1, -4] becomes [-4, -1, -1, 0, 1, 2].
Use a loop to fix one element and apply two-pointer technique for the remaining elements.
Skip duplicates to avoid repeated triplets in the result. Example: For [-1, -1, 0, 1], only consider unique combinations.
To print nodes with no edges in a unidirectional graph, iterate through all nodes and print those without any outgoing edges.
Iterate through all nodes in the graph
For each node, check if it has any outgoing edges
If a node has no outgoing edges, print it
A prime number is a natural number greater than 1 that cannot be formed by multiplying two smaller natural numbers.
A prime number has exactly two distinct positive divisors: 1 and itself.
Examples of prime numbers include 2, 3, 5, 7, 11, and 13.
The number 1 is not considered a prime number.
The only even prime number is 2; all other even numbers can be divided by 2.
Black box testing is a software testing method where the internal structure or code of the application is not known to the tester.
Tester focuses on the functionality of the software without knowing its internal workings
Tests are based on requirements and specifications
Input data is provided and output is compared against expected results
Examples include equivalence partitioning, boundary value analysis, and decisi...
Regression testing is the process of retesting a software application to ensure that new code changes have not adversely affected existing functionality.
Regression testing is performed after code changes to verify that the existing features still work correctly.
It helps in identifying any defects introduced by new code changes.
Automated testing tools are often used for regression testing to save time and effort.
Ex...
I appeared for an interview in Jun 2025, where I was asked the following questions.
Multicollinearity occurs when independent variables in a regression model are highly correlated, affecting model reliability.
Multicollinearity can inflate the variance of coefficient estimates, making them unstable.
It can lead to misleading statistical significance of predictors.
Example: In a model predicting house prices, including both 'square footage' and 'number of rooms' may cause multicollinearity.
Detection metho...
Variance Inflation Factor (VIF) quantifies multicollinearity in regression models, indicating how much variance is inflated due to predictors.
VIF measures how much the variance of a regression coefficient is increased due to multicollinearity.
A VIF value of 1 indicates no correlation among predictors, while values above 5-10 suggest high multicollinearity.
For example, if a predictor has a VIF of 15, it indicates that i...
SQL JOIN functions combine rows from two or more tables based on related columns.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from the right table and matched records from ...
Mean, median, and mode are measures of central tendency used to summarize data sets.
Mean: The average of a data set, calculated by summing all values and dividing by the count. Example: For {2, 3, 5}, Mean = (2+3+5)/3 = 3.33.
Median: The middle value when data is sorted. If even number of values, it's the average of the two middle numbers. Example: For {1, 3, 3, 6, 7}, Median = 3.
Mode: The value that appears most freque...
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.
24 mcqs were given and all of them were of aptitude and sql based
Anagram question solved without using any inbuilt functions
Create a function to check if two strings are anagrams by comparing the frequency of characters
Iterate through both strings and count the frequency of each character
Compare the frequency of characters in both strings to determine if they are anagrams
Frequency of elements in an array
Iterate through the array and count the occurrences of each element
Store the counts in a map or dictionary for easy access
Return the map/dictionary with element frequencies
I appeared for an interview in Aug 2024.
It was easy difficulty.
I appeared for an interview in Aug 2024.
Hackerrank coding test
Resultant rows for different SQL joins
Inner join - returns rows that have matching values 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 outer join - returns all rows when there is a match in either left or right table
I applied via Instahyre and was interviewed in Jun 2024. There were 3 interview rounds.
Coding round had one SQL and one Python question. And some mcqs around python and math
There were 2 coding questions one is based on array and one more is based on abstraction
HTML5 introduced new features like semantic elements, audio/video support, canvas for graphics, local storage, and improved form controls compared to HTML3.
HTML5 introduced semantic elements like <header>, <footer>, <nav>, <article>, <section> for better structure and SEO.
HTML5 added native support for audio and video playback without the need for plugins.
Canvas element in HTML5 allows for...
React's forwardRef and useImperativeHandle allow components to expose methods to parent components.
forwardRef allows you to pass a ref through a component to one of its children.
useImperativeHandle customizes the instance value that is exposed to parent components when using ref.
Example: Create a custom input component that focuses on itself when a method is called.
Usage: const MyInput = React.forwardRef((props, ref) =...
Top trending discussions
The duration of Impact Analytics interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 43 interview experiences
Difficulty level
Duration
based on 89 reviews
Rating in categories
Senior Software Engineer
107
salaries
| ₹25 L/yr - ₹39 L/yr |
Senior Data Scientist
93
salaries
| ₹20.7 L/yr - ₹30 L/yr |
Senior Business Analyst
75
salaries
| ₹17 L/yr - ₹29.5 L/yr |
Business Analyst
70
salaries
| ₹10 L/yr - ₹14.5 L/yr |
Software Engineer
56
salaries
| ₹8.2 L/yr - ₹17.9 L/yr |
Maxgen Technologies
JoulestoWatts Business Solutions
Value Point Systems
F1 Info Solutions and Services