AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Sub-K IMPACT Solutions Senior Data Analyst Interview Questions and Answers for Experienced
Sub-K IMPACT Solutions Senior Data Analyst Interview Experiences for Experienced
1 interview found
Anonymous
Selected
I applied via Naukri.com and was interviewed before Dec 2021. There were 2 interview rounds.
(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
- 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.
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
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
- 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
- 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
- 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 ...
- 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...
- 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
- Q7. About your last company and role? Why you want to leave the company?
- Q8. Abou the role,. Any info on the role that you are applying?
Interview Preparation Tips
Skills evaluated in this interview
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 ...
Interview Questionnaire
1 Question
- Q1. Finance questions, account concepts,ifrs
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.
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Everything related to Capital markets and Securities. and Since It was for Business analyst role so it went around Scrum and agile methodologies
Interview Preparation Tips
(1 Question)
- Q1. SQL related PL SQL , Stored PRocedures
Selected
I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 2 interview rounds.
(3 Questions)
- Q1. Basic & intermediate SQL questions
- Q2. Second highest salary of employee
- Q3. DBMS key concepts and explation with examples of use case
- Ans.
DBMS key concepts and examples of use cases
DBMS stands for Database Management System
Key concepts include data modeling, query optimization, transaction management
Use cases include online transaction processing (OLTP), data warehousing, customer relationship management (CRM)
Examples: MySQL for OLTP, Oracle for data warehousing, Salesforce for CRM
(1 Question)
- Q1. Techno business related questions
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Feb 2024. There were 2 interview rounds.
30 questions: aptitude ,output questions, 3 coding questions
Mostly to connect front end and backend
Interview Preparation Tips
- datastructures
- heap
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
Top 7 th employee salary
Find Duplicates
(3 Questions)
- Q1. Trigger Stored procedure
- Ans.
A trigger is a special type of stored procedure that is automatically executed when certain events occur in a database.
Triggers are used to enforce business rules, maintain data integrity, and automate tasks.
They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
For example, a trigger can be created to update a log table whenever a new record is inserted into a main table.
- Q2. Gateway Different modes in power bi
- Ans.
Power BI has different modes like View, Edit, and Data Source.
View mode allows users to interact with reports and dashboards
Edit mode enables users to modify existing reports and create new ones
Data Source mode allows users to connect to and manipulate data sources
- Q3. Nothing to get importance no words
Skills evaluated in this interview
Sub-K IMPACT Solutions Interview FAQs
Tell us how to improve this page.
Sub-K IMPACT Solutions Interviews By Designations
- Sub-K IMPACT Solutions Product Manager Interview Questions
- Sub-K IMPACT Solutions Customer Service Representative Interview Questions
- Sub-K IMPACT Solutions Quality Analyst Interview Questions
- Sub-K IMPACT Solutions Business Associate Interview Questions
- Sub-K IMPACT Solutions CSR Interview Questions
- Sub-K IMPACT Solutions Senior Data Analyst Interview Questions
- Sub-K IMPACT Solutions Consultant Interview Questions
- Sub-K IMPACT Solutions Internal Auditor Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Sub-K IMPACT Solutions Senior Data Analyst Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Sub-K IMPACT Solutions Senior Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Unit Head
34
salaries
|  ₹2.2 L/yr - ₹4.8 L/yr |
|
Customer Service Representative
29
salaries
| ₹1.2 L/yr - ₹3 L/yr |
|
Business Associate
24
salaries
| ₹1.2 L/yr - ₹3.6 L/yr |
|
Cluster Manager
22
salaries
| ₹3.5 L/yr - ₹6.5 L/yr |
|
Product Manager
20
salaries
| ₹7.5 L/yr - ₹11 L/yr |
SBI Cards & Payment Services
Axis Direct
Kotak Securities
Aadhar Housing Finance
- Home >
- Interviews >
- Sub-K IMPACT Solutions Interview Questions >
- Sub-K IMPACT Solutions Senior Data Analyst Interview Questions for Experienced
