Filter interviews by
I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.
Types of Joins in SQL include Inner Join, Left Join, Right Join, and Full Outer 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 Outer Join: Returns rows when there is a match in either table.
Optimizing Tableau dashboard involves improving performance, usability, and visual appeal.
Limit the number of worksheets on a dashboard to improve performance
Use filters and parameters effectively to allow for interactivity
Optimize data source connections for faster loading times
Utilize dashboard actions to create dynamic interactions
Design with user experience in mind to ensure clarity and ease of use
Different types of LOD functions include INCLUDE, EXCLUDE, and FIXED.
INCLUDE LOD function is used to compute the level of detail for a specific dimension while keeping all other dimensions constant.
EXCLUDE LOD function is used to compute the level of detail for all dimensions except the specified dimension.
FIXED LOD function is used to compute the level of detail independently of the visualization's dimensions.
Examples...
I appeared for an interview before Jun 2016.
Autocorrelation is the correlation of a signal with a delayed copy of itself.
Autocorrelation is used to identify patterns in time series data.
It is a measure of how similar a signal is to a delayed version of itself.
Autocorrelation can be positive, negative, or zero.
It is commonly used in signal processing, finance, and econometrics.
Autocorrelation can be visualized using a correlogram.
Heteroscedasticity is a statistical term that refers to the unequal variance of a variable across different levels of another variable.
It is a violation of the assumption of homoscedasticity in regression analysis.
It can lead to biased and inefficient estimates of regression coefficients.
It can be detected through residual plots or statistical tests such as the Breusch-Pagan test.
Examples include income and expenditure...
Data analysis is affected by various factors that can influence the accuracy and reliability of the results.
Data quality: The accuracy, completeness, and consistency of the data can impact the analysis.
Data sources: The reliability and relevance of the data sources used for analysis can affect the outcomes.
Data preprocessing: The way data is cleaned, transformed, and prepared for analysis can impact the results.
Data in...
I applied via Walk-in and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Approached by Company and was interviewed in Nov 2018. There were 4 interview rounds.
I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.
MongoDB database algorithms are used for efficient data storage, retrieval, and processing.
MongoDB uses various algorithms for indexing, sharding, and aggregation.
Indexing algorithms include B-tree, hash, and text search indexes.
Sharding algorithms include range-based, hash-based, and zone-based sharding.
Aggregation algorithms include map-reduce and aggregation pipeline.
MongoDB also uses algorithms for query optimizati
I appeared for an interview before Dec 2020.
Round duration - 120 Minutes
Round difficulty - Medium
Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...
The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.
Read the number of test cases 'T'
For each test case, encode the 'SECRET_INFORMATION' and then decode it
Compare the decoded string with the original 'SECRET_INFORMATION'
Print 'Transmission successful' if they match, else print 'Transmission failed'
Round duration - 60 Minutes
Round difficulty - Medium
Given an array Arr
consisting of N integers, your task is to find the equilibrium index of the array.
An index is considered as an equilibrium index if the sum of elem...
Find the equilibrium index of an array where sum of elements on left equals sum on right.
Iterate through the array and calculate prefix sum and suffix sum at each index.
Compare prefix sum and suffix sum to find equilibrium index.
Return the left-most equilibrium index or -1 if none found.
Round duration - 50 Minutes
Round difficulty - Easy
Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company
Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.
I applied via Walk-in and was interviewed before Aug 2020. There were 4 interview rounds.
I applied via Walk-in and was interviewed before Oct 2020. There was 1 interview round.
I applied via LinkedIn and was interviewed before Sep 2020. There was 1 interview round.
based on 1 interview
Interview experience
Senior Software Engineer
26
salaries
| ₹16 L/yr - ₹37 L/yr |
Software Engineer
21
salaries
| ₹8.1 L/yr - ₹16 L/yr |
Principal Software Engineer
10
salaries
| ₹23.4 L/yr - ₹42 L/yr |
Technical Support Engineer
9
salaries
| ₹6 L/yr - ₹9.1 L/yr |
Product Manager
6
salaries
| ₹35 L/yr - ₹42 L/yr |
Accenture
Wipro
Cognizant
Capgemini