Virtusa Consulting Services Senior Software Engineer Interview Questions and Answers for Experienced

Basics of Sql Queries and Explain the Queries

Q1. SCD types of in ETL
Ans. 
Slowly Changing Dimensions (SCD) types in ETL refer to how historical data is handled when new data is loaded into a data warehouse.
• Type 1: Overwrite - simply overwrite the existing data with the new data

• Type 2: Add new row - keep all versions of the data in the table

• Type 3: Update - create a new column to store the old value while updating the current value

• Type 4: Hybrid - combination of Type 1 and Type 2 or Type 1 an
Answered by AI
Add your answer
Q2. SQL Queries with some scenario based
Add your answer
Q3. What is mean by index
Ans. 
An index is a data structure that improves the speed of data retrieval operations on a database table.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on columns in a database table to speed up data retrieval operations.

• Examples include primary keys, unique keys, and non-unique keys.
Answered by AI
Add your answer

Q1. Parent to child trigger
Add your answer
Q2. Questions on almost each and every part of Salesforce and integration
Add your answer

Write a trigger to delete account which have more than 2 contact.

Q1. Coding and core java
Add your answer

Q1. Project experience
Add your answer

Q1. Interaction with manager
Add your answer

Q1. Questions asked on sping framework like flow and annotations
Add your answer