Filter interviews by
I applied via LinkedIn and was interviewed in Jun 2021. There were 3 interview rounds.
Distinct returns unique values while group by groups and aggregates data based on a column.
Distinct returns only unique values from a single column.
Group by groups and aggregates data based on a column.
Distinct can be used to count the number of unique values in a column.
Group by can be used to group data by a column and perform aggregate functions like sum, count, avg, etc.
Distinct is used to remove duplicates from a ...
Right join and right outer join are the same thing.
Right join and right outer join are interchangeable terms.
Both return all the rows from the right table and matching rows from the left table.
If there is no match, the result will contain NULL values for the left table columns.
Used to combine data from two tables based on a common column.
Syntax: SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;
Special characters in columns can be handled by replacing or removing them.
Identify the special characters in the column
Replace the special characters with a suitable alternative
Remove the special characters if they are not necessary
Use regular expressions to handle complex special characters
Ensure that the data type of the column is appropriate
I applied via Referral and was interviewed before Dec 2023. There was 1 interview round.
I am a data analyst with a background in statistics and programming, passionate about turning data into actionable insights.
Background in statistics and programming
Experience in data analysis and visualization tools like Python, R, and Tableau
Strong problem-solving skills and attention to detail
Ability to communicate complex data findings to non-technical stakeholders
I rate myself as proficient in SQL with experience in writing complex queries and optimizing database performance.
Proficient in writing complex SQL queries
Experience in optimizing database performance
Familiar with database management systems like MySQL, PostgreSQL, etc.
I appeared for an interview in Jan 2025.
Online aptitude test have been coundected
I applied via LinkedIn and was interviewed before Oct 2021. There were 3 interview rounds.
8 python coding
With 2 aptitude
Game based assessment.
More than 8 games need to play
Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.
There are four types of joins in SQL: inner join, left join, right join, and full outer join.
Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.
Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...
I applied via Campus Placement and was interviewed in Nov 2022. There were 5 interview rounds.
Get questions from all topics and medium level questions
They give one topic and provide one minute for thinking its overall 30 min discussion
Latent view and analytics are essential for data-driven decision making. My best achievement is developing a predictive model for customer churn.
Latent view helps to uncover hidden patterns and insights in data that are not immediately apparent.
Analytics provides a systematic approach to analyzing data and extracting meaningful insights.
My best achievement is developing a predictive model for customer churn that helped
Senior Software Engineer
191
salaries
| ₹6.2 L/yr - ₹24 L/yr |
Software Engineer
190
salaries
| ₹2.5 L/yr - ₹12 L/yr |
Technical Lead
46
salaries
| ₹12.2 L/yr - ₹37 L/yr |
Softwaretest Engineer
46
salaries
| ₹3 L/yr - ₹12.6 L/yr |
Senior QA Engineer
42
salaries
| ₹6 L/yr - ₹18 L/yr |
Tekwissen
Damco Solutions
smartData Enterprises
In Time Tec Visionsoft