Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Virtusa Consulting Services Senior Data Engineer Interview Questions and Answers

Updated 23 Dec 2024

Virtusa Consulting Services Senior Data Engineer Interview Experiences

2 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. More questions on spark and java
  • Q2. More questions on sql
Round 2 - Technical 

(2 Questions)

  • Q1. Over all project architecture
  • Q2. Sample data and its transformations
  • Ans. 

    Sample data and its transformations

    • Sample data can be in the form of CSV, JSON, or database tables

    • Transformations include cleaning, filtering, aggregating, and joining data

    • Examples: converting date formats, removing duplicates, calculating averages

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Why are u leaving current job
  • Ans. 

    Seeking new challenges and opportunities for growth in a more dynamic environment.

    • Looking for new challenges and opportunities for growth

    • Seeking a more dynamic work environment

    • Interested in expanding skill set and knowledge

    • Want to work on more innovative projects

  • Answered by AI
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What do you know about Spark architecture?
  • Ans. 

    Spark architecture is based on a master-slave architecture with a cluster manager to coordinate tasks.

    • Spark architecture consists of a driver program that communicates with a cluster manager to coordinate tasks.

    • The cluster manager allocates resources and schedules tasks on worker nodes.

    • Worker nodes execute the tasks and return results to the driver program.

    • Spark supports various cluster managers like YARN, Mesos, and s...

  • Answered by AI
  • Q2. How many stages will be created if a spark job has 3 wide transformations and 2 narrow transformations?
  • Ans. 

    There will be 4 stages created in total for the spark job.

    • Wide transformations trigger a shuffle and create a new stage.

    • Narrow transformations do not trigger a shuffle and do not create a new stage.

    • In this case, 3 wide transformations will create 3 new stages and 2 narrow transformations will not create new stages.

    • Therefore, a total of 4 stages will be created.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Virtusa Consulting Services Senior Data Engineer interview:
  • Spark
  • Python
  • SQL

Skills evaluated in this interview

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in 7 Eleven
Q3. How do you handle data pipeline when the schema information keeps ... read more
asked in 7 Eleven
Q4. Difference between Parquet and ORC file. Why industry uses parque ... read more
asked in 7 Eleven
Q5. What is Normalisation and Denormalisation? When do we use them? G ... read more

Senior Data Engineer Jobs at Virtusa Consulting Services

View all

Interview questions from similar companies

I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Java questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic questions

I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. .net questions - routing in asp.net MVC ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing . Prepare well for interview on .Net technology stack

I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Good

Round 2 - Technical 

(1 Question)

  • Q1. Basic question from C++.Some questions from Data structure and computer architecture.

Interview Preparation Tips

Topics to prepare for TCS Software Engineer interview:
  • C++
Interview preparation tips for other job seekers - Prepare well. Aptitude is not very easy so you have to prepare well.

Interview Preparation Tips

Round: Resume Shortlist
Experience: I had sent my resume to the hiring group, Selection through telephonic interviews. I was interviewed by three different research groups  (once by each).
Tips: Factors in decreasing order of importance: CGPA each stage. Ability to explain your projects precisely. Ability to solve ''standard" logarithmic problems.  The way you think and put down your Answer is the most important. The final answer .s not so I important, and they prod you when you think out aloud anyway.

Round: Technical Interview
Experience: Almost- by default they ask about your previous projects/internships if they are relevant to the group. Ofher questions depend on the group you are interviewed by and your own profile, In my case it was machine learning, text mining etc. I was told about the research problem they were dealing with then and asked f or comments/suggestions/.inputs and a discussion followed.
Tips: Basically these are specialized Interviews so it's good to have sound knowledge of your domain (analytical and application skills are very much required).

Skill Tips: CGPA>9.0, 1f not (like me) relevant work done in the domain and in past internship.A recommendation from the professor is also a good add on.
College Name: IIT Madras

Interview Preparation Tips

Round: Test
Experience: There was an apititude test basically in line with CAT pattern. It was conducted online for about 45 min duration. The questions were rather simple but each question was time bound (around 45 sec or so).
Tips: As such I did not have any structured study plan. I did refresh some of my basics in mechanics and analysis. I was more inclined to get a job in aerospace division. Read as per your interest.
Duration: 45 minutes

Round: Group Discussion
Experience: Initially, we are seated randomly in a circular manner and each one was given two minutes to describe the topic. It was followed by an tense debate where participants converged and diverged on different sets of issue. They were particularly looking for interpersonal skills and out of the box thinking.

Round: Interview
Experience: The interview was purely management type.More questions were thrown at team building, bio-data, why this company? , project, what you Can contribute for the firm?, where you see yourself in next 5 -10 years, ambitions, some amount of optimization tools and techniques, concluding remarks....Interpersonal skills and clarity in answering where mainly
IBM was a more relaxed interview, which basically dealt with management and interpersonal skills. Questions like “if one of our team mate is very stubborn, lazy, adamant, how will you tackle the situation” were asked.
Tips: College (B Tech) curricular activities, NTSC certificate, Math Olympiad certificate, all India quiz competition awards were noted and appreciated. That really was a booster. That helps in implanting an idea that you are not just blah blah blah.

Skill Tips: Be very sure about your mechanics, analysis and design. These three are the fundamentals.
I haven prepared for placements exclusively. Here were combined discussions. However, it really helps if you can revise and make your fundamentals were clear. The basic understanding should be there. An hour every day for two months will do the trick.
Be really choosy of the company you want to be in. Learn a lot more of the company and get an idea of what they are actually looking for. But still don’t freeze your mind to those realms alone.. Be open minded and cheerful. The first few questions will set the mood of the interview. If you are bale to crack that, then things will be really smooth. Really concentrate on your fundamentals, especially analysis and design.
Skills: Mechanics, Analysis , Design
College Name: IIT-Madras

Interview Preparation Tips

Round: Resume Shortlist
Experience: CGPA > 8 is necessary

Round: Test
Experience: Online Test + Written Test
Online Test - Duration 90 minutes + Written Test 30 minutes for Hardware profile
Online Test -Quants, Number Series ; Calculators were not allowed
Written Test - Semiconductor Basics

Round: Interview
Experience: Interview is held in either 1 round for non-core profile or several rounds of technical interviews for Hardware.
Technical round consisted of questions form topics like VLSI, Semiconductors (BJT, MOS), ASIC Design Flow, CMOS Process Flow.

Round: Group Discussion
Experience: Group Discussion is held for non-core profilesDuration varies from 20-30 minutes with 11 members.

General Tips: Never ever mention GRE or MS or any higher studies, for that matter, in any placement interview if you want to get placed in that company
Practicing quant, puzzle solving and GD from early in the semester would definitely help
Core placement: be thorough with the core fundaes
Practice general quant questions without a calculator
Skills: Quants, Puzzle Solving
College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: It had 3 parts: Data manipulation, number series and calculations.

Round: Test
Experience: Technical test on C. Typical questions on what will be the output of the program.

Round: Technical Interview
Experience: Questions were based on various areas of CSE, especially Programming languages and thesis work. Questions on Database connectivity in Java , CGI, DFA, DMA etc were also asked.
Tips: ISL works 80% in java and 20% in C. Thus, prepare Java well before appearing for the IBM-ISL. Must have basic knowledge in databases, Operating systems.

College Name: IIT KANPUR

Interview Preparation Tips

Round: Test
Experience: Initial shortlisting was based on 1 hour written test.
Questions on Quant,Codingand Algorithms were asked in the test
Tips: Focus on quant,coding and algorithms
Duration: 60 minutes

Round: Technical Interview
Experience: The subject knowledge and skills tested in Technical interview are:
1.Math
2.Coding
Tips: Good math knowledge is required.

Round: HR Interview
Experience: General HR question were asked in this round.

Skills: Data structure, Algorithms, Math, Coding
College Name: IIT MADRAS
Contribute & help others!
anonymous
You can choose to be anonymous

Virtusa Consulting Services Interview FAQs

How many rounds are there in Virtusa Consulting Services Senior Data Engineer interview?
Virtusa Consulting Services interview process usually has 2 rounds. The most common rounds in the Virtusa Consulting Services interview process are Technical and HR.
How to prepare for Virtusa Consulting Services Senior Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Virtusa Consulting Services. The most common topics and skills that interviewers at Virtusa Consulting Services expect are Python, Data Processing, Spark, Analytical Chemistry and Clinical Data Management.
What are the top questions asked in Virtusa Consulting Services Senior Data Engineer interview?

Some of the top questions asked at the Virtusa Consulting Services Senior Data Engineer interview -

  1. How many stages will be created if a spark job has 3 wide transformations and 2...read more
  2. What do you know about Spark architectu...read more
  3. Sample data and its transformati...read more

Recently Viewed

REVIEWS

Megha Engineering & Infrastructures

No Reviews

REVIEWS

Megha Engineering & Infrastructures

No Reviews

INTERVIEWS

Virtusa Consulting Services

No Interviews

INTERVIEWS

Virtusa Consulting Services

No Interviews

INTERVIEWS

Virtusa Consulting Services

No Interviews

INTERVIEWS

Turkish Engineering Consulting and Contracting

No Interviews

REVIEWS

Megha Engineering & Infrastructures

No Reviews

INTERVIEWS

Maa Shailja Electrical & Instrument Service

No Interviews

REVIEWS

Megha Engineering & Infrastructures

No Reviews

REVIEWS

Megha Engineering & Infrastructures

No Reviews

Tell us how to improve this page.

Virtusa Consulting Services Senior Data Engineer Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more
Virtusa Consulting Services Senior Data Engineer Salary
based on 24 salaries
₹10.6 L/yr - ₹33 L/yr
13% more than the average Senior Data Engineer Salary in India
View more details

Virtusa Consulting Services Senior Data Engineer Reviews and Ratings

based on 2 reviews

1.0/5

Rating in categories

2.0

Skill development

3.0

Work-life balance

3.9

Salary

1.0

Job security

1.0

Company culture

3.0

Promotions

1.0

Work satisfaction

Explore 2 Reviews and Ratings
Senior Data Engineer

Bangalore / Bengaluru

8-10 Yrs

Not Disclosed

Senior Data Engineer

Hyderabad / Secunderabad

7-9 Yrs

Not Disclosed

Explore more jobs
Senior Consultant
3.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Consultant
3.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
3.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
3.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
2.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Virtusa Consulting Services with

Cognizant

3.7
Compare

TCS

3.7
Compare

Infosys

3.6
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview