Filter interviews by
It was on campus test, so we had 3 sections in aptitude round, aptitude, logical, and science based questions like FDA related EU drug administration related like that
Top trending discussions
posted on 16 Aug 2023
I applied via Walk-in and was interviewed before Aug 2022. There were 4 interview rounds.
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
Basic aptitude questions, statics, probability etc
I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.
I reside in the heart of Manhattan, surrounded by towering skyscrapers.
New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.
The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.
I enjoy exploring the diverse neighborhoods and ...
In 5 years, I see myself as a senior data analyst leading a team, utilizing advanced analytics to drive strategic decision-making.
Leading a team of data analysts
Utilizing advanced analytics techniques
Driving strategic decision-making
Continuously learning and staying updated with the latest trends in data analysis
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
Primary key uniquely identifies each record in a table, while Unique key allows only unique values but can have null values.
Primary key enforces uniqueness and not null constraint on a column
Primary key can consist of multiple columns
Unique key allows only unique values but can have null values
Unique key can be applied to multiple columns as well
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Use conditional formatting to highlight odd cells in Excel
Select the range of cells you want to highlight
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose 'New Rule' and select 'Use a formula to determine which cells to format'
Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)
Choose the formatting style you want for the odd cells
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
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
FU...
Use window function to calculate running sum of salary in SQL
Use window function like SUM() with OVER() clause
Partition the data by employee ID if needed
Order the data by date or any other relevant column
I appeared for an interview in Jun 2024.
Easy SQL questions related to sub query
SQL moderate questions related to joins and window functions
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Associate Analyst
201
salaries
| ₹4 L/yr - ₹4.9 L/yr |
Programmer Analyst
58
salaries
| ₹4.9 L/yr - ₹9 L/yr |
Research Analyst
43
salaries
| ₹4.5 L/yr - ₹9.2 L/yr |
Senior Programmer Analyst
31
salaries
| ₹8 L/yr - ₹13.5 L/yr |
Data Manager
25
salaries
| ₹5.8 L/yr - ₹9.2 L/yr |
Value Point Systems
JoulestoWatts Business Solutions
Saama Technologies
Systems Plus