i
UBS
Filter interviews by
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
Detailed interview on SQL, Tableau & Alteryx
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
Generic maths questions
Online platform coding challenge
SQL query to retrieve total sales amount for each product category
Use GROUP BY clause to group the results by product category
Use SUM() function to calculate the total sales amount
Join the tables if necessary to get the required data
I have 3 years of experience working as a Data Analyst in the finance industry.
Utilized SQL to extract and analyze data from databases
Created visualizations using Tableau to present findings to stakeholders
Performed predictive modeling using Python to forecast financial trends
A business analyst is a professional who analyzes an organization's business domain and documents its business processes or systems.
Analyzes business processes to identify areas for improvement
Works with stakeholders to gather requirements for new systems or processes
Creates documentation such as business requirements documents and process maps
Helps to bridge the gap between business stakeholders and technical teams
Use...
UBS interview questions for designations
I have worked on various databases including MySQL, Oracle, and MongoDB.
MySQL
Oracle
MongoDB
Different types of join are inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all the rows from the left table and matching rows from the right table.
Right join returns all the rows from the right table and matching rows from the left table.
Full outer join returns all the rows from both tables, with NULL values in the columns where there ...
Top trending discussions
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
IT WAS Difficult and i gave up
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
The data analysis process for an employee salary table involves data cleaning, exploration, visualization, and modeling.
Start by cleaning the data to remove any duplicates, missing values, or outliers.
Explore the data by calculating basic statistics like mean, median, and standard deviation.
Visualize the data using histograms, box plots, or scatter plots to identify patterns or trends.
Perform statistical modeling to an...
I faced challenges in managing large datasets and ensuring data accuracy in my project.
Managing large volumes of data from multiple sources
Ensuring data accuracy and consistency
Dealing with missing or incomplete data
Handling data cleaning and preprocessing tasks
Addressing technical issues with data storage or processing tools
I was interviewed in Sep 2024.
Use PyArrow library to load data from HDFS in Python
Install PyArrow library using pip install pyarrow
Use pyarrow.hdfs.connect to connect to HDFS
Use pyarrow.parquet.read_table to read data from HDFS
Query to find the top three salaried employees of each department
Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary
Partition the data by department and order by salary in descending order
Filter the results to only include rows where the row number is less than or equal to 3
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
Revenue impact for casino
I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Jun 2024. There was 1 interview round.
A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.
A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.
A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.
A p-value less than the significance level indicates st
The output of a**2 is the square of the value of a.
The output is the value of a multiplied by itself
For example, if a = 3, then the output would be 9 (3*3)
append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.
append() is a method used to add rows to a DataFrame.
concat() is a function used to combine multiple DataFrames along a particular axis.
append() modifies the original DataFrame, while concat() returns a new DataFrame.
Example: df1.append(df2) vs pd.concat([df1, df2])
based on 4 interviews
Interview experience
based on 9 reviews
Rating in categories
Associate Director
3.3k
salaries
| ₹14.8 L/yr - ₹53.5 L/yr |
Assistant Vice President
2.3k
salaries
| ₹16 L/yr - ₹49 L/yr |
Authorized Officer
1.7k
salaries
| ₹9.7 L/yr - ₹28 L/yr |
Exempt NON Officer
1.5k
salaries
| ₹7 L/yr - ₹29.1 L/yr |
ENO
1.4k
salaries
| ₹7 L/yr - ₹25 L/yr |
Morgan Stanley
Goldman Sachs
JPMorgan Chase & Co.
Deutsche Bank