SVB Global Services India Senior Data Engineer Interview Questions and Answers

SQL questions were asked

Q1. Snowflake cost reduction
Add your answer
Q2. Index in snowflake
Add your answer

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. What is your name
Ans. 
My name is John Smith.
• Full name is John Smith

• Common name in English-speaking countries

• Easy to remember and pronounce
Answered by AI
Add your answer
Q2. Tell me about your project experience
Ans. 
I have extensive project experience in implementing ERP systems for large corporations.
• Led a team in the successful implementation of SAP S/4HANA for a Fortune 500 company

• Managed the integration of Oracle ERP Cloud for a global manufacturing company

• Provided training and support for end-users during system go-live

• Worked closely with stakeholders to gather requirements and ensure project alignment
Answered by AI
Add your answer

Questions based on SQL,Python and computer networks

Q1. About salary,6 working days,
Add your answer

Q1. Tell me about your self
Ans. 
Experienced Senior Systems Engineer with a strong background in designing and implementing complex systems.
• Over 8 years of experience in system design and implementation

• Proficient in various programming languages such as Java, Python, and C++

• Skilled in troubleshooting and resolving complex technical issues

• Strong knowledge of network protocols and security measures

• Proven track record of successfully leading cross-functi
Answered by AI
Add your answer
Q2. How to address the BSOD issue
Ans. 
To address the BSOD issue, start by identifying the root cause and troubleshooting the hardware or software related issues.
• Identify the error code displayed on the BSOD screen to narrow down the issue

• Check for recent hardware or software changes that may have caused the BSOD

• Update device drivers and software to ensure compatibility and stability

• Run diagnostic tests to check for hardware failures

• Consider restoring the s...read more
Answered by AI
Add your answer
Q3. How troubleshoot the Outlook Issue
Ans. 
To troubleshoot Outlook issues, start by checking internet connection, restarting Outlook, updating software, checking email settings, and running diagnostics.
• Check internet connection to ensure Outlook can connect to server

• Restart Outlook to refresh the program

• Update Outlook software to the latest version

• Check email settings such as server configurations and account credentials

• Run diagnostics tools provided by Outlook
Answered by AI
Add your answer

Virtualization, HVS, OS Performance Tuning, VPN Connectivity Issues / Network Connectivity & Troubleshooting

Q1. Current Salary & Expected Salary
Ans. 
I am currently earning $90,000 annually and I am looking for a salary in the range of $100,000 to $110,000 for this position.
• Current Salary: $90,000 annually

• Expected Salary: $100,000 - $110,000

• Open to negotiation based on benefits and responsibilities
Answered by AI
Add your answer

Maximize the coin profit by iterating though a list

Q1. LLD for creating few java classes for a news channel
Ans. 
Designing Java classes for a news channel
• Create a NewsChannel class with attributes like name, location, and list of news articles

• Create a NewsArticle class with attributes like title, author, content, and publish date

• Implement methods in NewsChannel class to add, remove, and display news articles
Answered by AI
Add your answer