Filter interviews by
I was interviewed in Dec 2024.
Basics of Sql Queries and Explain the Queries
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
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.
I applied via Not sure and was interviewed in Oct 2024. There were 4 interview rounds.
What people are saying about Virtusa Consulting Services
I applied via Campus Placement
This test includes questions on quantitative reasoning and logical reasoning.
The coding test consists of four questions, with each student receiving a different set of coding questions. Two of the questions are of easy level, while the other two are of medium level.
Virtusa Consulting Services interview questions for popular designations
I would join Virtusa because of its reputation for innovation, collaborative work environment, and opportunities for growth.
Virtusa is known for its innovative solutions and cutting-edge technology.
The collaborative work environment at Virtusa fosters creativity and teamwork.
Virtusa offers ample opportunities for professional growth and career advancement.
I am impressed by Virtusa's commitment to diversity and inclusio
Current technologies are more advanced, efficient, and user-friendly compared to previous technologies.
Current technologies have faster processing speeds and higher storage capacities.
Previous technologies often required manual input and were less intuitive for users.
Current technologies offer more connectivity options and seamless integration with other devices.
Examples: Smartphones vs. flip phones, cloud computing vs
The future of my current skill as an Associate Architect is promising, with advancements in technology and sustainable design shaping the industry.
Continued focus on sustainable architecture and green building practices
Integration of technology such as Building Information Modeling (BIM) and virtual reality in design processes
Emphasis on resilient design to address climate change challenges
Collaboration with other disc...
I would communicate openly with the team to understand their concerns and work together to find a solution.
Listen to the team members' concerns and perspectives
Facilitate a discussion to gather different viewpoints
Collaborate with the team to brainstorm potential solutions
Implement a plan that addresses the issues raised
The notice period is one month.
Notice period is one month
Standard notice period in the industry
Allows for transition time before leaving current position
Get interview-ready with Top Virtusa Consulting Services Interview Questions
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
Parallel test execution in Cucumber allows running multiple test scenarios simultaneously for faster results.
Use tools like TestNG or JUnit to run Cucumber tests in parallel
Configure the test runner to specify the number of threads to use for parallel execution
Ensure that the tests are independent and do not interfere with each other
Consider using a parallel plugin like Cucumber-JVM-Parallel to manage parallel executio
Browser history can be handled by clearing cache, cookies, and browsing data regularly.
Regularly clear cache, cookies, and browsing history to improve browser performance
Use incognito mode for private browsing to prevent history from being saved
Disable browser history tracking if needed for privacy reasons
Browser history can be managed by clearing cache, cookies, and browsing history regularly.
Regularly clear cache, cookies, and browsing history to improve browser performance
Use private browsing mode to prevent saving browsing history
Disable browser history tracking in browser settings
Use browser extensions or plugins to manage and delete browsing history
Consider using a VPN for additional privacy and security
I applied via Job Fair and was interviewed in Jul 2024. There were 4 interview rounds.
Neural Hack 6 - Round 1 - 7 DSA Question I have solved 5 only
Round 2 - 5 DSA Problem I'm able to solve only 3 not able to top 100 but call for interview
The most efficient sorting algorithm is Quick Sort due to its average time complexity of O(n log n).
Quick Sort is efficient due to its divide and conquer approach.
It has an average time complexity of O(n log n) and a worst-case time complexity of O(n^2).
Example: Sorting an array of integers using Quick Sort.
OOPS stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects, which can contain data and code.
OOPS focuses on creating objects that interact with each other to solve a problem
Key principles of OOPS include encapsulation, inheritance, polymorphism, and abstraction
Encapsulation: bundling data and methods that operate on the data into a single unit
Inheritance: allows a class to...
I developed a mobile app for tracking daily water intake and exercise routines.
Implemented user-friendly interface for easy input of water intake and exercise details
Integrated push notifications to remind users to drink water and exercise regularly
Used Firebase for backend data storage and retrieval
Faced challenges with optimizing app performance on older devices
Encountered issues with syncing data across multiple dev
Code to reverse an array of strings
Use a loop to iterate through half of the array and swap elements at opposite ends
Create a temporary variable to hold one element during swapping
Ensure to handle odd length arrays by not swapping the middle element
Company policies outline rules and guidelines for employees to follow.
Company policies cover areas such as dress code, attendance, code of conduct, and benefits.
Examples of company policies include a policy on remote work, a policy on social media usage, and a policy on harassment.
Employees are expected to adhere to company policies to maintain a positive work environment and ensure compliance with legal regulations.
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
SNS is a pub/sub messaging service while SQS is a message queue service in AWS architecture.
SNS allows for push notifications to multiple subscribers, while SQS is used for decoupling services and handling asynchronous tasks.
SNS is used for real-time messaging and event-driven architecture, while SQS is used for reliable message processing and scaling.
SNS supports multiple message delivery protocols like HTTP, HTTPS, E...
Eventbridge is a serverless event bus service provided by AWS for connecting applications using events.
Eventbridge allows different AWS services, SaaS applications, and custom applications to communicate with each other through events.
It simplifies the process of building event-driven architectures by decoupling producers and consumers of events.
Eventbridge can be used to trigger automated workflows, connect different ...
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
PySpark is a Python API for Apache Spark, used for big data processing and analytics.
PySpark is a Python API for Apache Spark, a fast and general-purpose cluster computing system.
It allows for easy integration with Python libraries and provides high-level APIs in Python.
PySpark can be used for processing large datasets, machine learning, real-time data streaming, and more.
It supports various data sources such as HDFS, ...
PySpark is a Python API for Apache Spark, while Python is a general-purpose programming language.
PySpark is specifically designed for big data processing using Spark, while Python is a versatile programming language used for various applications.
PySpark allows for distributed computing and parallel processing, while Python is primarily used for sequential programming.
PySpark provides libraries and tools for working wit...
Some of the top questions asked at the Virtusa Consulting Services interview -
The duration of Virtusa Consulting Services interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 457 interviews
Interview experience
based on 4.8k reviews
Rating in categories
Senior Consultant
4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Consultant
3.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
3.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
3.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
2.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
TCS
Infosys
Accenture