Filter interviews by
Handler methods in Java are methods that are responsible for handling incoming requests and generating responses.
Handler methods are typically defined in classes annotated with @Controller or @RestController.
These methods are mapped to specific URLs using @RequestMapping or other mapping annotations.
Handler methods can have parameters such as HttpServletRequest, HttpServletResponse, or model attributes.
The return ...
A function to read data from Excel files using Python's pandas library.
Use the pandas library: `import pandas as pd`.
Read Excel file: `df = pd.read_excel('file.xlsx')`.
Access specific data: `value = df['ColumnName'][rowIndex]`.
Handle multiple sheets: `df = pd.read_excel('file.xlsx', sheet_name='Sheet1')`.
Export data back to Excel: `df.to_excel('output.xlsx', index=False)`.
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, HTT...
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 diffe...
What people are saying about Virtusa Consulting Services
OOPS concept is a programming paradigm that uses objects and classes for organizing code. Real-time example: Car
Encapsulation: Car class with private variables like speed, color, and methods like accelerate, brake
Inheritance: Creating a subclass ElectricCar that inherits from Car class
Polymorphism: Overriding the accelerate method in ElectricCar class to increase speed differently
I rate myself as highly proficient in Java with extensive experience in developing complex applications.
Strong understanding of core Java concepts such as OOP, multithreading, and collections
Experience in developing enterprise-level applications using Java frameworks like Spring and Hibernate
Proficient in writing efficient and optimized code, with a focus on performance tuning
Familiarity with Java development tool...
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 exe...
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
Bug life cycle is the process of identifying, reporting, fixing, retesting, and closing bugs in software development.
Bug identification: Bug is identified by testers during testing.
Bug reporting: Testers report the bug with detailed information.
Bug fixing: Developers fix the reported bug.
Bug retesting: Testers retest the fixed bug to ensure it is resolved.
Bug closing: Once the bug is confirmed fixed, it is closed.
Object-oriented programming concepts that focus on data abstraction, encapsulation, inheritance, and polymorphism.
Abstraction: Hiding the complex implementation details and showing only the necessary features to the outside world.
Encapsulation: Binding data and methods that operate on the data into a single unit.
Inheritance: Ability of a class to inherit properties and behavior from another class.
Polymorphism: Abi...
I applied via Campus Placement and was interviewed in Dec 2024. There were 3 interview rounds.
Online assessment (Technical, English, Reasoning)
Balance sheet shows assets, liabilities, and equity at a specific point in time. Trial balance lists all ledger accounts with their balances.
Balance sheet is a snapshot of a company's financial position at a specific point in time.
Trial balance is a list of all ledger accounts with their balances to ensure debits equal credits.
Balance sheet includes assets, liabilities, and equity sections.
Trial balance is used to prep...
Standard costing formula calculates the expected cost of a product based on predetermined standards.
Standard costing formula includes direct materials, direct labor, and overhead costs.
It helps in comparing actual costs with standard costs to identify variances.
Formula: Standard Cost = Standard Quantity of Inputs x Standard Price of Inputs
Explanation of journal entries for Prepaid, Accruals, Depreciation, Provision for Bad debts, DTA, and DTL.
Prepaid expenses are initially recorded as assets and then expensed over time as they are used up.
Accruals are expenses incurred but not yet paid or revenue earned but not yet received.
Depreciation is the allocation of the cost of a fixed asset over its useful life, with accumulated depreciation representing the to...
Preparation of balance sheet involves listing assets, liabilities, and equity. Ratios are computed using financial data from the balance sheet.
List all assets, liabilities, and equity on the balance sheet
Calculate various financial ratios such as current ratio, debt to equity ratio, and return on equity
Use formulae like Current Ratio = Current Assets / Current Liabilities
Interpret the ratios to analyze the financial he...
DTA stands for Deferred Tax Asset and DTL stands for Deferred Tax Liability.
DTA is an asset recorded on a company's balance sheet that may be used to reduce taxable income in the future.
DTL is a liability recorded on a company's balance sheet that represents taxes that have been accrued but not yet paid.
DTA arises when a company has overpaid taxes or has tax deductions that exceed its taxable income.
DTL arises when a c...
Accumulated depreciation is a contra asset account that represents the total depreciation expense taken on an asset since it was acquired.
Accumulated depreciation is recorded on the balance sheet as a reduction from the gross amount of fixed assets to arrive at the net book value.
The accounting entry for accumulated depreciation involves debiting the depreciation expense account and crediting the accumulated depreciati...
Standard costing formula calculates the expected cost of a product based on predetermined standards.
Standard costing formula = Standard cost of direct materials + Standard cost of direct labor + Standard manufacturing overhead cost
Standard cost of direct materials = Standard quantity of materials x Standard price per unit
Standard cost of direct labor = Standard hours of labor x Standard rate per hour
Standard manufactur...
Budgeting involves setting financial goals and allocating resources, while forecasting predicts future financial outcomes based on past data and trends.
Budgeting is a plan for how to allocate resources and achieve financial goals
Forecasting predicts future financial outcomes based on past data and trends
Budgeting is typically done on an annual basis, while forecasting can be done on a shorter or longer term basis
Budget...
Variance analysis is a technique used to identify and analyze the difference between planned financial outcomes and actual results.
Variance analysis helps in understanding the reasons for deviations from budgeted or expected figures.
It involves comparing actual financial performance with budgeted or standard performance.
Common types of variances include price variance, quantity variance, and mix variance.
Variance analy...
I applied via Referral and was interviewed in Dec 2024. There were 2 interview rounds.
A linked list is a linear data structure where elements are stored in nodes, each pointing to the next node.
A linked list consists of nodes, each containing data and a reference to the next node.
Types of linked lists include singly linked lists, doubly linked lists, and circular linked lists.
Example of a singly linked list: Node1 -> Node2 -> Node3 -> NULL.
Doubly linked list allows traversal in both directions:...
Deep copy creates a new copy of an object with its own unique memory space, while shallow copy creates a new object that references the same memory locations as the original object.
Deep copy duplicates all nested objects, while shallow copy only duplicates the references to nested objects.
Deep copy ensures that changes to the copied object do not affect the original object, while shallow copy may lead to unintended sid...
Polymorphism allows objects to be treated as instances of their parent class, enhancing flexibility and code reusability.
Polymorphism can be achieved through method overriding and method overloading.
Example of method overriding: A base class 'Animal' has a method 'makeSound()', and subclasses 'Dog' and 'Cat' implement their own versions.
Method overloading allows multiple methods with the same name but different paramet...
Use a loop to swap characters of two strings without using strcpy function.
Create two arrays of characters to store the strings
Use a loop to iterate through each character of the strings and swap them
Ensure to handle cases where strings have different lengths
I appeared for an interview in Jun 2025, where I was asked the following questions.
I appeared for an interview in Jun 2025, where I was asked the following questions.
I appeared for an interview in May 2025, where I was asked the following questions.
They will see logical and lateral thinking
Apache Spark architecture includes a cluster manager, worker nodes, and driver program.
Apache Spark architecture consists of a cluster manager, which allocates resources and schedules tasks.
Worker nodes execute tasks and store data in memory or disk.
Driver program coordinates tasks and communicates with the cluster manager.
Spark applications run as independent sets of processes on a cluster, coordinated by the SparkCon...
reduceBy is used to aggregate data based on key, while groupBy is used to group data based on key.
reduceBy is a transformation that combines the values of each key using an associative function and a neutral 'zero value'.
groupBy is a transformation that groups the data based on a key and returns a grouped data set.
reduceBy is more efficient for aggregating data as it reduces the data before shuffling, while groupBy shu...
RDD is a low-level abstraction representing a distributed collection of objects, while DataFrame is a higher-level abstraction representing a distributed collection of data organized into named columns.
RDD is more suitable for unstructured data and low-level transformations, while DataFrame is more suitable for structured data and high-level abstractions.
DataFrames provide optimizations like query optimization and code...
The different modes of execution in Apache Spark include local mode, standalone mode, YARN mode, and Mesos mode.
Local mode: Spark runs on a single machine with one executor.
Standalone mode: Spark runs on a cluster managed by a standalone cluster manager.
YARN mode: Spark runs on a Hadoop cluster using YARN as the resource manager.
Mesos mode: Spark runs on a Mesos cluster with Mesos as the resource manager.
I appeared for an interview in Nov 2024.
Use 'hdfs diskbalancer' command to check disk utilisation and health in Hadoop
Run 'hdfs diskbalancer -report' to get a report on disk utilisation
Use 'hdfs diskbalancer -plan <path>' to generate a plan for balancing disk usage
Check the Hadoop logs for any disk health issues
Spark Architecture consists of Driver, Cluster Manager, and Executors. Driver manages the execution of Spark jobs.
Driver: Manages the execution of Spark jobs, converts user code into tasks, and coordinates with Cluster Manager.
Cluster Manager: Manages resources across the cluster and allocates resources to Spark applications.
Executors: Execute tasks assigned by the Driver and store data in memory or disk for further pr...
Optimization techniques in Spark improve performance and efficiency of data processing.
Partitioning data to distribute workload evenly
Caching frequently accessed data in memory
Using broadcast variables for small lookup tables
Avoiding shuffling operations whenever possible
Tuning memory settings and garbage collection parameters
I am unable to provide this information as it is confidential.
Confidential information about salaries in previous organizations should not be disclosed.
It is important to respect the privacy and confidentiality of past employers.
Discussing specific salary details may not be appropriate in a professional setting.
To create a pivot table in SQL from a non-pivot table, you can use the CASE statement with aggregate functions.
Use the CASE statement to categorize data into columns
Apply aggregate functions like SUM, COUNT, AVG, etc. to calculate values for each category
Group the data by the columns you want to pivot on
Creating triggers in a database involves defining the trigger, specifying the event that will activate it, and writing the code to be executed.
Define the trigger using the CREATE TRIGGER statement
Specify the event that will activate the trigger (e.g. INSERT, UPDATE, DELETE)
Write the code or actions to be executed when the trigger is activated
Test the trigger to ensure it functions as intended
Lifecycle hooks in Angular are methods that allow you to tap into the lifecycle of a component or directive.
Lifecycle hooks include ngOnInit, ngOnChanges, ngDoCheck, ngOnDestroy, etc.
ngOnInit is used for initialization logic, ngOnChanges is used for reacting to input changes, ngOnDestroy is used for cleanup tasks, etc.
Example: ngOnInit() { console.log('Component initialized'); }
Round 1 and 2 was good
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 503 interview experiences
Difficulty level
Duration
based on 5.4k reviews
Rating in categories
8-10 Yrs
Not Disclosed
8-12 Yrs
Not Disclosed
Senior Consultant
3.7k
salaries
| ₹8.3 L/yr - ₹32 L/yr |
Software Engineer
3.4k
salaries
| ₹3.6 L/yr - ₹14.2 L/yr |
Consultant
3.2k
salaries
| ₹6.1 L/yr - ₹21 L/yr |
Lead Consultant
3.2k
salaries
| ₹10.5 L/yr - ₹34 L/yr |
Associate Consultant
2.6k
salaries
| ₹4.7 L/yr - ₹16 L/yr |
Cognizant
TCS
Infosys
Accenture