Filter interviews by
To calculate TDI and MDI of a customer in SQL, you need to aggregate and analyze the customer's transaction data.
Calculate Total Daily Income (TDI) by summing up the income of the customer for each day.
Calculate Monthly Daily Income (MDI) by averaging the TDI for each day in a month.
Use SQL functions like SUM, AVG, and GROUP BY to perform the calculations.
Example: SELECT SUM(income) AS TDI, AVG(income) AS MDI FROM tran
They asked about the sas,sql,and power bi
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
English, quant, logical reasoning
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])
posted on 11 Oct 2024
Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.
Data warehousing involves extracting data from multiple sources and consolidating it into a central repository.
It is used for analytical reporting, business intelligence, and decision-making purposes.
Data warehouses are designed for query and analysis rather than transaction processing.
Examples of d...
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Engineer
169
salaries
| ₹8.1 L/yr - ₹31.2 L/yr |
Analyst
90
salaries
| ₹3 L/yr - ₹13 L/yr |
Senior Analyst
84
salaries
| ₹3.8 L/yr - ₹7.6 L/yr |
Software Engineer
55
salaries
| ₹11 L/yr - ₹32.5 L/yr |
Data Engineer
44
salaries
| ₹8.6 L/yr - ₹35.2 L/yr |
HSBC Group
JPMorgan Chase & Co.
Barclays Global Service Centre
Standard Chartered