Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There was 1 interview round.
Top trending discussions
I was interviewed before Feb 2021.
House price prediction
I applied via Referral and was interviewed before Jan 2024. There were 2 interview rounds.
How much you rate in Python and SQL
I applied via Approached by Company and was interviewed before Jun 2021. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 5 interview rounds.
I applied via Campus Placement and was interviewed in Apr 2023. There were 3 interview rounds.
Maths, logical reasoning, 1.5 hrs
Piraamal finance jnlnm knkn
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
Used to retrieve, update, and manage data in relational databases
Commonly used in data analysis, data manipulation, and data reporting
Examples: SELECT * FROM table_name, INSERT INTO table_name VALUES (value1, value2)
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI allows users to connect to a wide variety of data sources and create interactive reports and dashboards.
Users can easily share their insights with others and collaborate in real-time.
It offers features like data modeling, data preparation, and data visualization to help organizatio...
Calculation and Logics
I applied via IIM Jobs and was interviewed in Mar 2023. There were 3 interview rounds.
Questions related to quantitative aptitude , Logical reasoning , Data Interpretation and English Comprehension . The level of the questions asked will be moderate anyone can easily crack the interview test . But try to be good in any two of the above mentioned topic so that you can clear it easily,
VLOOKUP searches for a value in the first column of a table and returns a corresponding value in the same row. INDEX/MATCH uses two functions to look up a value based on its position in a table.
VLOOKUP only searches for values in the first column of a table, while INDEX/MATCH can search for values in any column.
INDEX/MATCH is more flexible and efficient for large datasets.
VLOOKUP is easier to use for simple lookups wit...
Alter command on table affects views created on the table.
Views are virtual tables created from one or more tables.
Alter command on a table can change the structure of the table, which can affect the views created on it.
If the columns used in the view are altered or dropped, the view will become invalid.
If the data in the table is changed, the data in the view will also change accordingly.
Data transformations in SSIS include Lookup which retrieves data from a source based on a matching condition.
Lookup is used to retrieve data from a source based on a matching condition
It can be used to perform joins between two data sources
Lookup can be used to update or insert data into a destination based on a match
Other data transformations in SSIS include sorting, aggregating, and merging data
Drop deletes the table structure and data, truncate deletes only data, and delete deletes specific rows.
Drop: removes the table and all its data permanently
Truncate: removes all data from the table but keeps the structure
Delete: removes specific rows from the table based on a condition
Drop and truncate cannot be rolled back, but delete can be
Drop and truncate reset the identity of the table, but delete does not
Truncate resets identity value, delete does not.
Truncate resets the identity value to the original seed value
Delete does not change the identity value
Example: Truncate table resets identity value to 1
Example: Delete from table does not change identity value
Joins are used to combine data from two or more tables based on a related column. Types include inner, outer, left, right, and cross join.
Inner join returns only the matching rows from both tables.
Outer join returns all rows from both tables, with null values for non-matching rows.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and m...
Query to join employees who are all managers using id in the table.
Use self join to join the table on manager id and employee id
Filter the result to only include employees who are also managers
Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.id = e2.manager_id WHERE e2.manager_id IS NOT NULL
Ensure that the table has a manager_id column
based on 1 interview
Interview experience
Senior Research Associate
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Research Associate
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Executive
1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Scientist
793
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive
730
salaries
| ₹0 L/yr - ₹0 L/yr |
Biocon Limited
Piramal Group
Wockhardt
Strides Pharma