AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Virtusa Consulting Services Interview Questions and Answers
351 Interview questions
SCD Type 2 allows tracking historical data by creating new records for changes while preserving old records.
Use effective date columns: Add 'start_date' and 'end_date' to track the validity of each record.
Add a 'current_flag' column: This indicates whether a record is the most recent version (1 for current, 0 for historical).
Create a new record for changes: When a change occurs, insert a new record with updated va...
Temporary tables are session-specific, while global temporary tables are accessible across sessions.
Temporary tables are created with 'CREATE TABLE #TempTable' and are only visible to the session that created them.
Global temporary tables are created with 'CREATE TABLE ##GlobalTempTable' and can be accessed by any session.
Temporary tables are dropped automatically when the session ends, while global temporary table...
DataStage optimization techniques enhance performance and efficiency in ETL processes.
Use partitioning to distribute data processing across multiple nodes, improving parallelism.
Implement data filtering early in the process to reduce the volume of data being processed.
Utilize bulk loading techniques for databases to speed up data insertion.
Optimize transformer stages by minimizing the number of columns and using e...
Design an Employee class and an abstract class to represent different employee types in a software application.
Create an abstract class 'Employee' with common attributes like name and ID.
Define abstract methods like 'calculateSalary()' that subclasses must implement.
Implement concrete classes like 'FullTimeEmployee' and 'PartTimeEmployee' that extend 'Employee'.
Use polymorphism to handle different employee types u...
What people are saying about Virtusa Consulting Services
Java streams can efficiently extract distinct employee types from a list using functional programming techniques.
Use Stream API: Convert the list of employees to a stream using `stream()` method.
Map to Employee Type: Use `map()` to transform the employee objects to their types (e.g., `employee.getType()`).
Distinct Values: Apply `distinct()` to filter out duplicate types.
Collect Results: Use `collect(Collectors.toS...
KPO analysts require analytical skills, domain knowledge, and proficiency in tools for data analysis and reporting.
Strong analytical skills: Ability to interpret complex data sets and derive actionable insights.
Domain expertise: Knowledge in specific industries like finance, healthcare, or IT to provide relevant analysis.
Technical proficiency: Familiarity with data analysis tools such as Excel, SQL, or Python for ...
Java testing involves various methodologies to ensure code quality, functionality, and performance through systematic testing processes.
Unit Testing: Testing individual components (e.g., JUnit for testing methods in isolation).
Integration Testing: Ensuring different modules work together (e.g., using TestNG for testing interactions).
Functional Testing: Validating the software against functional requirements (e.g.,...
I prioritize clear communication, empathy, and proactive problem-solving during client escalations.
Listen actively to the client's concerns to fully understand the issue.
Acknowledge the client's feelings and express empathy for their situation.
Provide a clear and concise explanation of the steps being taken to resolve the issue.
Set realistic expectations regarding timelines and outcomes.
Follow up with the client a...
A multi-to-multi table relationship allows multiple records in one table to relate to multiple records in another table.
In a multi-to-multi relationship, two tables are connected through a junction table.
Example: Students and Courses - A student can enroll in multiple courses, and a course can have multiple students.
The junction table (e.g., Enrollments) would contain foreign keys referencing both Students and Cou...
Yes, I am proficient in VLOOKUP, HLOOKUP, and Pivot Tables, essential for data analysis and reporting in Excel.
VLOOKUP: Used to find data in a table by searching for a value in the first column. Example: =VLOOKUP(A2, B2:D10, 3, FALSE) retrieves data from the third column.
HLOOKUP: Similar to VLOOKUP but searches for data in the first row. Example: =HLOOKUP(B1, A1:E5, 3, FALSE) finds data in the third row.
Pivot Tabl...
Virtusa Consulting Services Interview Experiences
612 interviews found
Anonymous
I applied via Walk-in and was interviewed before Sep 2019. There were 4 interview rounds.
Interview QuestionnaireÂ
3 Questions
- Q1. A program on recursion.
- Ans.
Recursion is a programming technique where a function calls itself to solve a problem.
Recursion involves a base case and a recursive case
Recursion can be used to solve problems like factorial, Fibonacci sequence, and binary search
Recursion can be less efficient than iterative solutions for some problems
- Q2. Is a string mutable/immutable with an example
- Ans.
A string can be both mutable and immutable depending on the programming language.
In languages like Java and Python, strings are immutable.
In languages like C++ and C#, strings are mutable.
Immutable strings cannot be modified once created, while mutable strings can be modified.
Example of immutable string: 'hello world'.replace('o', '0') returns 'hell0 w0rld'.
Example of mutable string: string s = 'hello'; s[0] = 'j'; s n...
- Q3. OOPS concept with examples
- Ans.
OOPS is a programming paradigm based on the concept of objects.
OOPS stands for Object-Oriented Programming System
It focuses on creating objects that contain both data and functions
Encapsulation, Inheritance, and Polymorphism are the three main pillars of OOPS
Example: A car is an object that has properties like color, model, and functions like start, stop, and accelerate
Interview Preparation Tips
PRAKASH B
Selected
I applied via Campus Placement and was interviewed in Dec 2024. There were 3 interview rounds.
Online assessment (Technical, English, Reasoning)
(6 Questions)
- Q1. Difference between Balance sheet and trial balance
- Ans.
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...
- Q2. Standard costing formula
- Ans.
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
- Q3. Journal entries for Prepaid Accruals Depreciation with accumulated depreciation concept Provision for Bad debts DTA and DTL
- Ans.
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...
- Q4. Case study on Ind AS 115
- Q5. Preparation of balance sheet and computation of various ratios
- Ans.
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...
- Q6. Accounting principles
(6 Questions)
- Q1. What is DTA and DTL
- Ans.
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...
- Q2. Accounting entry for accumulated depreciation
- Ans.
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...
- Q3. Few resume based questions
- Q4. Standard costing formula
- Ans.
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...
- Q5. Difference between budgeting and forecasting
- Ans.
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...
- Q6. Meaning of variance analysis
- Ans.
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...
Interview Preparation Tips
First technical interview was for 45 - 50 mins
Second technical interview was for 20 mins
Bhuvaneswari majji
I applied via Referral and was interviewed in Dec 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Run time polymorphism code
- Q2. Linked list code
- Ans.
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:...
- Q3. Deep copy shallow copy differences
- Ans.
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...
(2 Questions)
- Q1. More deep questions about polymorphism code
- Ans.
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...
- Q2. Code for interchange of strings without strcpy
- Ans.
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
Interview Preparation Tips
Naveen kumar reddy
Selected
They will see logical and lateral thinking
(2 Questions)
- Q1. Oops. Solid principles. Previous project explanation
- Q2. Questions on full stack
(2 Questions)
- Q1. About company policies
- Q2. Salary
Interview Preparation Tips
SHIKHA
(4 Questions)
- Q1. What is the architecture of Apache Spark?
- Ans.
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...
- Q2. What is the difference between the reduceBy and groupBy transformations in Apache Spark?
- Ans.
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...
- Q3. What is the difference between RDD (Resilient Distributed Datasets) and DataFrame in Apache Spark?
- Ans.
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...
- Q4. What are the different modes of execution in Apache Spark?
- Ans.
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.
(7 Questions)
- Q1. Command to check disk utilisation and health in Hadoop
- Ans.
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
- Q2. Spark Architecture & the significance of each member of spark Architecture
- Ans.
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...
- Q3. Partitioning and bucketing
- Q4. Spark optimization techniques
- Ans.
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
- Q5. Second highest salary
- Ans.
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.
- Q6. Pivot table creation in SQL from not pivot one
- Ans.
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
- Q7. How to create triggers
- Ans.
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
Interview Preparation Tips
They are focusing on concept basically
Skills evaluated in this interview
Selected
(2 Questions)
- Q1. All about angular framework and Typescript
- Q2. Javascript precoded question
(3 Questions)
- Q1. In this round as well as Angular related question
- Q2. Lifecycle hook of angular
- Ans.
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'); }
- Q3. Lazy loading concept
Skills evaluated in this interview
Round 1 and 2 was good
Interview Preparation Tips
(2 Questions)
- Q1. Previous experience
- Q2. Scenario based question on design requirments
(2 Questions)
- Q1. Technical questions on client requirements
- Q2. In depth process flow, OSS and BSS in detail
(1 Question)
- Q1. Availability to join, compensation
Selected
I applied via Referral and was interviewed in Sep 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Technical questions on scrum and agile
- Q2. Technical questions on SAFE agile
(2 Questions)
- Q1. Situation based question on project management
- Q2. Situation based question on scrum master
(2 Questions)
- Q1. Past experiences abd project management
- Ans.
I have extensive experience in project management, including leading cross-functional teams and implementing Agile methodologies.
Led multiple cross-functional teams to successfully deliver projects on time and within budget
Implemented Agile methodologies such as Scrum and Kanban to improve team efficiency and productivity
Utilized tools like Jira and Trello to track project progress and facilitate communication among te...
- Q2. Scrum and SAFE question
Interview Preparation Tips
Selected
I appeared for an interview in Dec 2024.
Basics of Sql Queries and Explain the Queries
(3 Questions)
- 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...
- Q2. SQL Queries with some scenario based
- 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.
Virtusa Consulting Services Interview FAQs
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.
Tell us how to improve this page.
Virtusa Consulting Services Interviews By Designations
- Virtusa Consulting Services Associate Engineer Interview Questions
- Virtusa Consulting Services Software Engineer Interview Questions
- Virtusa Consulting Services Software Developer Interview Questions
- Virtusa Consulting Services Lead Consultant Interview Questions
- Virtusa Consulting Services Senior Consultant Interview Questions
- Virtusa Consulting Services Associate Software Engineer Interview Questions
- Virtusa Consulting Services Associate Consultant Interview Questions
- Virtusa Consulting Services Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Engineer Interview Questions
- Software Engineer Interview Questions
- Software Developer Interview Questions
- Lead Consultant Interview Questions
- Senior Consultant Interview Questions
- Associate Software Engineer Interview Questions
- Associate Consultant Interview Questions
- Senior Software Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 500 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Virtusa Consulting Services Reviews and Ratings
based on 5.4k reviews
Rating in categories
|
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 |
|
Lead Consultant
3.3k
salaries
| â‚ą10.5 L/yr - â‚ą34.6 L/yr |
|
Consultant
3.2k
salaries
| â‚ą6.1 L/yr - â‚ą21 L/yr |
|
Associate Consultant
2.6k
salaries
| â‚ą4.7 L/yr - â‚ą16 L/yr |
Cognizant
TCS
Infosys
Accenture
- Home >
- Interviews >
- Virtusa Consulting Services Interview Questions
