Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 3 interview rounds.
SQL joins are used to combine rows from two or more tables based on a related column between them.
INNER JOIN: Returns rows when there is at least one 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
CROSS J...
CODS rule is a troubleshooting method used in technical support to identify and resolve issues.
CODS stands for Cause, Observation, Diagnosis, Solution.
It helps technical support engineers systematically identify the root cause of a problem and provide a solution.
By following the CODS rule, engineers can efficiently troubleshoot and resolve technical issues.
Example: If a customer reports slow internet connection, the en...
Top trending discussions
I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.
SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.
SCD Type 2 maintains a separate row for each change in data, with a start and end date.
It requires a surrogate key to uniquely identify each row.
Informatica provides a built-in SCD Type 2 transformation to implement this technique.
Example: tracking changes in customer addresses over time.
Find an odd occurring number among even occurring numbers.
Use XOR operation to cancel out even occurring numbers and get the odd occurring number.
Iterate through the array and XOR each element with the result variable.
The final result will be the odd occurring number.
Print the spiral order of a binary tree and matrix.
For binary tree, use level order traversal and alternate direction for each level.
For matrix, use four pointers to traverse in spiral order.
Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9
Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13
Finding pairs in an array with a given sum.
Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.
Use a hash table to store the elements of the array and their indices for faster lookup.
If there are multiple pairs with the same sum, return any one of them.
If no pair is found, return null or an empty array.
Find total number of k element with given avg in an array in minimum time complexity.
Use sliding window technique to traverse the array in O(n) time complexity.
Maintain a sum variable to keep track of the sum of elements in the window.
If the sum of elements in the window is equal to k times the given avg, increment the count.
Move the window by subtracting the first element and adding the next element in the array.
Printing non-boundary elements of a binary tree
Traverse the tree in any order (preorder, inorder, postorder)
Check if the current node is not a boundary node (not the first or last node in its level)
If it is not a boundary node, print its value
Recursively traverse its left and right subtrees
posted on 5 Aug 2022
I applied via Referral and was interviewed before Aug 2021. There were 2 interview rounds.
Easy basic questions on ds algo, swap two numbers with out extra space
To find the frequency of each word in a sentence.
Split the sentence into words
Create a dictionary to store word frequency
Iterate through the words and update the dictionary
Return the dictionary
I applied via Campus Placement and was interviewed before Sep 2020. There were 5 interview rounds.
I applied via Naukri.com and was interviewed in Oct 2020. There were 5 interview rounds.
based on 1 interview
Interview experience
Senior Software Engineer
491
salaries
| ₹9.7 L/yr - ₹31 L/yr |
Software Engineer
288
salaries
| ₹7 L/yr - ₹22.4 L/yr |
Lead Software Engineer
106
salaries
| ₹18 L/yr - ₹39 L/yr |
Senior Associate Software Engineer
105
salaries
| ₹11 L/yr - ₹25 L/yr |
Senior Test Analyst
84
salaries
| ₹8.7 L/yr - ₹26.6 L/yr |
Wells Fargo
JPMorgan Chase & Co.
Citicorp
American Express