SVB Global Services India Senior Data Engineer Interview Questions and Answers

SQL questions were asked

Q1. Opps Concepts and internal working of HashMap
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to quickly retrieve values based on keys.
• HashMap is a part of Java's collection framework.

• It uses hashing to store and retrieve key-value pairs efficiently.

• Each key in a HashMap must be unique.

• HashMap allows null keys and values.

• Internal working involves using hash codes to determine the index of the key-value pair in the underlying array.
Answered by AI
Add your answer
Q2. Design Patterns and some scenario based questions
Add your answer

Q1. Windows functions in SQL and use of Lag function
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to perform calculations on a set of rows related to the current row in a query result.

• The LAG function is a window function that allows you to access data from a previous row in the result set.

• Example: SELECT employee_id, salary, LAG(salary) OVER (ORDER BY hire_date) AS prev_salary FR
Answered by AI
Add your answer
Q2. Nested for loop for list example
Ans. 
Nested for loop used to iterate through a list of items
• Use a for loop to iterate through the main list

• Inside the first loop, use another for loop to iterate through each item in the sublist

• Example: for item in main_list: for sub_item in item: print(sub_item)
Answered by AI
Add your answer
Q3. What is data base and data warehouse
Ans. 
A database is a collection of structured data organized for easy access, while a data warehouse is a centralized repository for storing and analyzing large volumes of data.
• Database is used for transactional processing and storing current data.

• Data warehouse is used for analytical processing and storing historical data.

• Database is typically used for day-to-day operations.

• Data warehouse is used for decision-making and bu...read more
Answered by AI
Add your answer
Q4. Which are Joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the righ...read more
Answered by AI
Add your answer
Q5. What is DAX in power bi
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI to create custom calculations and aggregations.
• DAX is similar to Excel formulas but designed for more complex data analysis tasks

• It can be used to create calculated columns, measures, and calculated tables in Power BI

• DAX functions include aggregation functions like SUM, AVERAGE, and COUNT, as well as logical functions and date functions

• Example: CALC...read more
Answered by AI
Add your answer

Q1. String manipulation question
Add your answer
Q2. Dataframe manipulation questions
Add your answer

Q1. Interview was related to work exp, Internship and project.
Add your answer
Q2. They asked questions on random forest and PCA
Add your answer

2 DSA easy to medium question in python language.

Q1. Discussion on why you want to join company?
Add your answer
Q2. Discussion on Projects
Add your answer

Q1. Classical ML questions
Add your answer

Q1. 45 minute hr round
Add your answer

2 medium level programming questions and 3 hr type questions

Q1. Oops,dbms, and os concepts , also project related
Add your answer