2 Sub-K IMPACT Solutions Senior Data Analyst Interview Questions & Answers | Complete Prep Guide 2025

Sub-K IMPACT Solutions Senior Data Analyst Interview Experiences

1 interview found

Senior Data Analyst Interview Questions & Answers

Anonymous

posted on 29 Dec 2022

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Naukri.com and was interviewed before Dec 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist

Pro Tip by AmbitionBox:

Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.

View all Resume tips

Round 2 - Technical

(2 Questions)

Q1. How to find null values from a data using sql?

Ans.

To find null values from a data using SQL, use the IS NULL operator.

Use the IS NULL operator to check for null values in a specific column.
Combine the IS NULL operator with the WHERE clause to filter out null values.
Use the COUNT function to count the number of null values in a column.
Example: SELECT * FROM table_name WHERE column_name IS NULL;
Example: SELECT COUNT(column_name) FROM table_name WHERE column_name IS NULL

Answered by AI

Add your answer

Q2. Select * from table where student_name isnull() ;

Ans.

This SQL query selects all rows from a table where the student_name column is null.

The query uses the SELECT statement to retrieve data from a table.
The * symbol means all columns will be selected.
The WHERE clause filters the results to only include rows where student_name is null.

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice SQL questions. They really focus on Statistics more. Statistics related to data analytics.

Skills evaluated in this interview

Top trending discussions

View All

Interview Tips & Stories

4d (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours... read more

Got a question about Sub-K IMPACT Solutions?

Ask anonymously on communities.

Interview questions from similar companies

Business Analyst Interview Questions & Answers

Satin Creditcare Network

Anonymous

posted on 13 Mar 2021

I applied via Naukri.com and was interviewed before Mar 2020. There were 3 interview rounds.

Interview Questionnaire

2 Questions

Q1. My favourite tool in excel.

Ans.

My favourite tool in Excel is the PivotTable.

PivotTable helps to summarize and analyze large amounts of data quickly.
It allows for easy filtering, sorting, and grouping of data.
PivotTable also provides visual representation of data through charts and graphs.
It can be used for various purposes such as financial analysis, sales analysis, and inventory management.

Answered by AI

Add your answer

Q2. How to calculate trend and forecasting.

Ans.

Trend and forecasting can be calculated using statistical methods like regression analysis and time series analysis.

Collect and analyze historical data
Identify patterns and trends in the data
Choose a suitable forecasting model
Apply the model to the data to generate a forecast
Evaluate the accuracy of the forecast

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Very easy Interview if you have excel knowledge and good communication skills . You can crack the Interview easily.

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Morningstar

Anonymous

posted on 29 Jan 2021

I was interviewed in Dec 2020.

Interview Questionnaire

1 Question

Q1. 30 equity and 30 aptitude

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - When u apply for job. Start working on your knowledge after applying only. Don't wait for email bcz email comes at night and online test was there at day after only at afternoon. If u pass u will get selection email and thereafter 3 round of interview is there.

Data Analyst Interview Questions & Answers

Morningstar

Anonymous

posted on 22 May 2021

I applied via Company Website and was interviewed in Nov 2020. There were 5 interview rounds.

Interview Questionnaire

1 Question

Q1. Fund, indexes, financial products and definitions, stocks and so on.

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well in advance..make notes and research about the company and profile.

Data Analyst Interview Questions & Answers

Morningstar

Anonymous

posted on 22 Jul 2021

Interview Questionnaire

1 Question

Q1. What are the financial statements? How cost sheet of bank different from cost sheet of manufacturing company? What is debt to equity ratio? What is stock option? What is Stock split? What is lease financin...

Ans.

Financial statements, cost sheet, debt to equity ratio, stock option, stock split, lease financing, profitability ratios.

Financial statements are reports that show the financial performance of a company.
Cost sheet of a bank includes interest expenses and income, while cost sheet of a manufacturing company includes direct and indirect costs.
Debt to equity ratio is a financial ratio that shows the proportion of debt and ...

Answered by AI

Add your answer

Data Analyst Interview Questions & Answers

Morningstar

Anonymous

posted on 27 Jul 2021

Interview Questionnaire

1 Question

Q1. Finance questions, account concepts,ifrs

Add your answer

Business Analyst Interview Questions & Answers

Jana Small Finance Bank

Anonymous

posted on 24 Jun 2022

I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist

Pro Tip by AmbitionBox:

Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.

View all Resume tips

Round 2 - Aptitude Test

Basic aptitude test

Round 3 - Technical

(1 Question)

Q1. Related to data science

Add your answer

Interview Preparation Tips

Topics to prepare for Jana Small Finance Bank Business Analyst interview:

SQL
Excel

Interview preparation tips for other job seekers - Prepare well with respect to SQL knowledge and excel

Data Analyst Interview Questions & Answers

Morningstar

Anonymous

posted on 17 Jan 2021

I applied via Referral and was interviewed before Jan 2020. There were 6 interview rounds.

Interview Questionnaire

8 Questions

Q1. What is amortization?

Ans.

Amortization is the process of spreading out a loan into smaller, regular payments over a period of time.

It is used to pay off a debt over time with regular payments
Each payment includes both principal and interest
The amount of interest decreases over time as the principal is paid off
Examples include mortgages, car loans, and student loans

Answered by AI

Add your answer

Q2. What is WASO, TSO and EPS?

Ans.

WASO is Wake After Sleep Onset, TSO is Total Sleep Time, and EPS is Earnings Per Share.

WASO is the amount of time spent awake after initially falling asleep.
TSO is the total amount of time spent sleeping, including both REM and non-REM sleep.
EPS is a financial metric that represents the portion of a company's profit allocated to each outstanding share of common stock.
WASO and TSO are commonly used in sleep studies, whi

Answered by AI

Add your answer

Q3. What are the elements which are present in all the financial statements like BS,IS and CF.

Ans.

The financial statements (BS, IS, CF) have common elements such as assets, liabilities, equity, revenue, expenses, and cash flows.

Assets: resources owned by the company
Liabilities: obligations owed by the company
Equity: residual interest in the assets of the company
Revenue: income generated by the company
Expenses: costs incurred by the company
Cash flows: inflows and outflows of cash

Answered by AI

View 1 more answer

Q4. What is the effect of stock split on market capitalisation of a company?

Ans.

A stock split increases the number of shares outstanding and decreases the price per share, but does not affect the market capitalisation.

Stock split does not affect the total value of the company
Market capitalisation remains the same after a stock split
Stock split increases the number of shares outstanding and decreases the price per share
For example, if a company has 1 million shares outstanding and the stock splits ...

Answered by AI

Add your answer

Q5. Components of Cash flow statements?

Ans.

Cash flow statements have three main components: operating activities, investing activities, and financing activities.

Operating activities: cash inflows and outflows from the company's core business operations.
Investing activities: cash inflows and outflows from buying or selling long-term assets.
Financing activities: cash inflows and outflows from borrowing or repaying debt, issuing or buying back stock, and paying di...

Answered by AI

Add your answer

Q6. How is EPS caluclated?

Ans.

EPS is calculated by dividing the company's net income by the number of outstanding shares.

EPS = Net Income / Outstanding Shares
Net Income is the company's total earnings after expenses and taxes
Outstanding Shares are the total number of shares issued by the company
EPS is an important metric for investors to evaluate a company's profitability
Higher EPS indicates better profitability and potential for higher dividends

Answered by AI

Add your answer

Q7. About your last company and role? Why you want to leave the company?

Add your answer

Q8. Abou the role,. Any info on the role that you are applying?

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the financial statements. Check all ratios with respect to statements. Be clear about the job profile. Read about the company.

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Annapurna Finance

Anonymous

posted on 7 Dec 2024

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - HR

(2 Questions)

Q1. About yourself?

Add your answer

Q2. Future ambition and expectations?

Add your answer

Round 2 - Group Discussion

Recent Topics oriented with Market, Business, Finance and budgets

Round 3 - One-on-one

(2 Questions)

Q1. Knowledge about core skills

Add your answer

Q2. How you are flexible with time and travel.

Add your answer

Data Analyst Interview Questions & Answers

Morningstar

Anonymous

posted on 28 Jul 2021

I applied via Referral and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire

1 Question

Q1. Financial statements , What are corporate actions, income statement

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to know the accounting basics and be upto date about the market.

Sub-K IMPACT Solutions Interview FAQs

How many rounds are there in Sub-K IMPACT Solutions Senior Data Analyst interview?

Sub-K IMPACT Solutions interview process usually has 2 rounds. The most common rounds in the Sub-K IMPACT Solutions interview process are Resume Shortlist and Technical.

What are the top questions asked in Sub-K IMPACT Solutions Senior Data Analyst interview?

Some of the top questions asked at the Sub-K IMPACT Solutions Senior Data Analyst interview -

How to find null values from a data using s...read more
Select * from table where student_name isnull(...read more

Tell us how to improve this page.

Sub-K IMPACT Solutions Interviews By Designations

Interview Questions for Popular Designations

Sub-K IMPACT Solutions Senior Data Analyst Interview Process

based on 1 interview

Interview experience

Excellent

Jana Small Finance Bank Interview Questions

3.8

• 249 Interviews

Morningstar Interview Questions

3.9

• 241 Interviews

SBI Cards & Payment Services Interview Questions

3.7

• 235 Interviews

Utkarsh Small Finance Bank Interview Questions

3.8

• 213 Interviews

Kotak Securities Interview Questions

3.6

• 116 Interviews

TresVista Interview Questions

2.9

• 115 Interviews

Pine Labs Interview Questions

3.4

• 109 Interviews

Aadhar Housing Finance Interview Questions

4.2

• 92 Interviews

Mr Cooper Interview Questions

4.0

• 84 Interviews

Synchrony Interview Questions

4.3

• 77 Interviews

View all

Xavier Institute of Social Service (XISS), Ranchi Placement Questions

1 Interview

View all

Sub-K IMPACT Solutions Senior Data Analyst Salary

based on 6 salaries

₹3.8 L/yr - ₹5 L/yr

60% less than the average Senior Data Analyst Salary in India

View more details

Sub-K IMPACT Solutions Salaries in India

Unit Head 37 salaries	₹0 L/yr - ₹0 L/yr
Customer Service Representative 29 salaries	₹0 L/yr - ₹0 L/yr
Business Associate 24 salaries	₹0 L/yr - ₹0 L/yr
Cluster Manager 22 salaries	₹0 L/yr - ₹0 L/yr
Product Manager 20 salaries	₹0 L/yr - ₹0 L/yr