Filter interviews by
Data warehouse is used for storing and analyzing large amounts of historical data, while a database is used for storing and managing current data.
Data warehouse is designed for analytical queries and reporting, while a database is optimized for transactional processing.
Data warehouse typically stores historical data from multiple sources for analysis, while a database stores current data for operational use.
Data wareho...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using subqueries or temporary tables
Optimize query structure by using appropriate functions and operators
Top trending discussions
I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.
I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.
SQL server
SQL DBA
A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.
Collects data from various sources
Cleans and processes data to ensure accuracy
Analyzes data using statistical methods and tools
Interprets data to identify trends and patterns
Presents findings and recommendations to stakeholders
I applied via Naukri.com and was interviewed before Jun 2023. There was 1 interview round.
posted on 13 Aug 2023
I applied via Campus Placement and was interviewed before Aug 2022. There were 3 interview rounds.
It was quantitative aptitude test with some coding questions
posted on 30 Dec 2024
I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.
Easy on cyber security
Good went well nicce process
Medium level questions
based on 1 interview
Interview experience
Business Analyst
6
salaries
| ₹9.1 L/yr - ₹51.1 L/yr |
Information Technology Developer 2
4
salaries
| ₹9.2 L/yr - ₹21 L/yr |
Customer Experience Associate
4
salaries
| ₹7.5 L/yr - ₹10 L/yr |
Insurance Adviser
4
salaries
| ₹15 L/yr - ₹34.2 L/yr |
Senior Financial Analyst
4
salaries
| ₹35 L/yr - ₹50 L/yr |
HDFC Bank
ICICI Bank
Axis Bank
State Bank of India