Virtusa Consulting Services Senior Software Engineer Interview Questions, Process, and Tips

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. Basics of Html CSS & Javascript
Add your answer
Q2. Projects related
Add your answer

Q1. Coding question related to arrays and string
Add your answer
Q2. Coding question to remove duplicate , count frequencies of occurrence of characters
Ans. 
Remove duplicates and count frequencies of characters in an array of strings.
• Iterate through each string in the array

• Use a hashmap to store characters and their frequencies

• Remove duplicates by checking if character already exists in hashmap
Answered by AI
Add your answer

Q1. React and Redux related question with coding questions related to useEffect and other hooks
Add your answer

Q1. Asked regarding previous experience and willingness for reallocations and gave overall info about the project and tech they hiring for
Add your answer

Q1. Salary negotiations and experience
Add your answer

Q1. What is delete and truncate
Ans. 
Delete and truncate are SQL commands used to remove data from a table, but they differ in their functionality.
• DELETE is a DML command used to remove specific rows from a table based on a condition

• TRUNCATE is a DDL command used to remove all rows from a table, resetting auto-increment values

• DELETE can be rolled back, while TRUNCATE cannot be rolled back

• DELETE triggers delete triggers, while TRUNCATE does not trigger any...read more
Answered by AI
Add your answer
Q2. What is mean by Null
Ans. 
Null is a value that represents the absence of a value or a placeholder.
• Null is often used in programming to indicate that a variable does not have a value assigned to it.

• It is different from an empty string or zero, as it specifically means 'no value'.

• For example, a database field may have a null value if no data has been entered for that field.
Answered by AI
Add your answer

Q1. What are dependency we added in POM.xml file for mobile automation
Ans. 
We added dependencies like Appium, TestNG, Selenium, and Apache POI in POM.xml for mobile automation.
• Appium dependency for mobile automation testing

• TestNG dependency for test execution and reporting

• Selenium dependency for web automation

• Apache POI dependency for reading and writing Excel files
Answered by AI
Add your answer
Q2. What is the adb devices command and when we are use it
Ans. 
adb devices command is used to list all Android devices connected to a computer via USB debugging
• Used to check the list of Android devices connected to the computer for debugging purposes

• Helps in identifying the device ID and status (offline, online, unauthorized)

• Commonly used in Android development for testing and debugging

• Example: 'adb devices' command will display a list of connected devices with their respective st
Answered by AI
Add your answer