Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Aarav Global Products & Services Private Limited Team. If you also belong to the team, you can get access from here

Filter interviews by

Aarav Global Products & Services Private Limited Interview Questions and Answers

Updated 18 Sep 2022

Aarav Global Products & Services Private Limited Interview Experiences

Popular Designations

6 interviews found

Interview Questions & Answers

user image Anonymous

posted on 18 Sep 2022

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me something about your self and experience
  • Q2. Decision about experience and work profile

Interview Preparation Tips

Interview preparation tips for other job seekers - There is nothing much spacial other then every bank or mnc

I applied via Naukri.com and was interviewed in Dec 2021. There were 4 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. .net Framework,Solid principle,Design patterns,Joins and types.
  • Q2. Difference between interface and abstraction,Difference between encapsulation and abstraction, joins,keep and peek.
  • Ans. 

    Explanation of interface, abstraction, encapsulation, joins, keep and peek.

    • Interface is a blueprint of a class that defines the methods and properties that the class should implement.

    • Abstraction is a concept of hiding the implementation details and showing only the necessary information to the user.

    • Encapsulation is a mechanism of wrapping the data and code together in a single unit and restricting access to the data fr...

  • Answered by AI
  • Q3. Routings and types of routings
  • Ans. 

    Routings are paths that data or signals take through a system. Types include static, dynamic, and adaptive.

    • Static routing uses a pre-determined path for data to travel

    • Dynamic routing adjusts the path based on network conditions

    • Adaptive routing combines static and dynamic routing to optimize performance

    • Examples of routing protocols include OSPF, BGP, and RIP

  • Answered by AI
  • Q4. Tell me About roles and responsibilities.
  • Q5. DIFFERENCE BETWEEN SP AND FUNCTION
  • Ans. 

    SP is used to execute a set of SQL statements, while a function returns a single value.

    • SP can have input/output parameters, while functions only have input parameters.

    • Functions can be used in SELECT statements, while SP cannot.

    • Functions can be called from within SP, but SP cannot be called from within a function.

    • SP can modify data in tables, while functions cannot.

    • Examples of SP: sp_help, sp_rename, sp_addlogin.

    • Example

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared basic and middle level questions.

Skills evaluated in this interview

Software Developer and Consultant Interview Questions asked at other Companies

Q1. Difference between interface and abstraction,Difference between encapsulation and abstraction, joins,keep and peek.
View answer (1)

Interview Questionnaire 

1 Question

  • Q1. What are the components of sdl
  • Ans. 

    SDL stands for Software Development Life Cycle and its components include planning, analysis, design, implementation, and maintenance.

    • Planning: defining project scope, goals, and requirements

    • Analysis: gathering and analyzing data to identify problems and opportunities

    • Design: creating a detailed plan for the solution

    • Implementation: building and testing the solution

    • Maintenance: ongoing support and updates to ensure the s

  • Answered by AI

Skills evaluated in this interview

Business Analyst Interview Questions asked at other Companies

Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with one box with defective balls (each one of the defective balls weigh 9 gm). You are given an electronic weighing machine and only one chance at it. How will you find out which... read more
View answer (9)

IT Consultant Interview Questions & Answers

user image Anonymous

posted on 29 Jan 2022

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

Round 1 - Technical 

(1 Question)

  • Q1. Sql Linux MIS ATM reconciliation
Round 2 - HR 

(4 Questions)

  • Q1. What are your salary expectations?
  • Ans. 

    I expect a competitive salary based on my experience and skills.

    • I have researched the average salary range for IT Consultants in the industry.

    • I have considered my level of experience and expertise.

    • I am open to negotiation based on the specific job requirements and benefits package.

    • I value fair compensation for the value I can bring to the organization.

  • Answered by AI
  • Q2. Share details of your previous job.
  • Ans. 

    I worked as an IT Consultant at XYZ Company.

    • Provided technical expertise and guidance to clients on various IT projects.

    • Analyzed client requirements and designed customized IT solutions.

    • Implemented and managed IT systems, including hardware, software, and networks.

    • Troubleshot and resolved technical issues for clients.

    • Conducted training sessions for clients to ensure smooth adoption of new technologies.

    • Collaborated with...

  • Answered by AI
  • Q3. What are your strengths and weaknesses?
  • Ans. 

    My strengths include problem-solving, technical expertise, and communication skills. My weaknesses include time management and perfectionism.

    • Strengths: Problem-solving - I have a strong ability to analyze complex issues and find effective solutions.

    • Strengths: Technical expertise - I have a deep understanding of various IT systems and technologies.

    • Strengths: Communication skills - I can effectively communicate technical...

  • Answered by AI
  • Q4. Tell me about yourself.
  • Ans. 

    I am an experienced IT consultant with a strong background in various technologies and a proven track record of delivering successful projects.

    • Over 10 years of experience in IT consulting

    • Expertise in network infrastructure design and implementation

    • Proficient in cloud computing technologies such as AWS and Azure

    • Strong problem-solving and analytical skills

    • Excellent communication and client management abilities

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Aarav Global Products & Services Private Limited IT Consultant interview:
  • Global certification
Interview preparation tips for other job seekers - Always make skills in IT field,

Should be global certification

IT Consultant Interview Questions asked at other Companies

Q1. Tell me if your system is infected by a virus how you will recover the data.
View answer (1)

Aarav Global Products & Services Private Limited interview questions for popular designations

 IT Consultant

 (1)

 Software Developer and Consultant

 (1)

 Business Analyst

 (1)

 Network Telecom Engineer

 (1)

Interview Questions & Answers

user image Anonymous

posted on 12 Dec 2021

I applied via Naukri.com and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Daily related senario and hardning and os related issue.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good interview experience

I applied via Recruitment Consulltant and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. They asked previous withdraw per month

Interview Preparation Tips

Interview preparation tips for other job seekers - Immediate joiner are most welcome and selection process is not take long time.next day I got my offer letter.

Jobs at Aarav Global Products & Services Private Limited

View all

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Mar 2018. There was 1 interview round.

Interview Preparation Tips

General Tips: Interview was short. Explained the role which was similar to the work I was doing before in my previous healthcare organization.

EDI related questions were asked. All type of file conversion and Excel formulas been asked.

Prepare well with on the above areas. It takes around 30 minutes.
Skills: Problem Solving, Analytical Skills, Presentation Skills, Time Management
Duration: <1 week

I appeared for an interview before Mar 2021.

Round 1 - Coding Test 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

21 students were shortlisted from the 1st MCQ round and in this round we were asked to write the codes (function only) of 3 questions in 1 hour time.

  • Q1. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Ans. 

    Find the minimum time required to rot all fresh oranges in a grid.

    • Use Breadth First Search (BFS) to simulate the rotting process

    • Track the time taken to rot all oranges and return -1 if any fresh oranges remain

    • Handle edge cases like no fresh oranges or all oranges already rotten

    • Consider using a queue to efficiently process adjacent oranges

  • Answered by AI
  • Q2. 

    Majority Element Problem Statement

    Given an array/list 'ARR' consisting of 'N' integers, your task is to find the majority element in the array. If there is no majority element present, return -1.

    Exampl...

  • Ans. 

    Find the majority element in an array, return -1 if no majority element exists.

    • Iterate through the array and keep track of the count of each element using a hashmap.

    • Check if any element's count is greater than floor(N/2) to determine the majority element.

    • Return the majority element or -1 if no majority element exists.

  • Answered by AI
  • Q3. 

    Maximum Path Sum Between Two Leaves Problem Description

    You are provided with a non-empty binary tree in which each node contains a non-negative integer value. Your task is to find and return the maximum ...

  • Ans. 

    Find the maximum path sum between two leaf nodes in a binary tree.

    • Traverse the tree to find the maximum path sum between two leaf nodes.

    • Keep track of the maximum sum found so far.

    • Consider all possible paths between leaf nodes.

    • Handle cases where the tree has only a single leaf node.

    • Implement a recursive function to calculate the maximum path sum.

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

This was a technical round with DSA based questions.

  • Q1. 

    N-th Node From The End Problem Statement

    You are given a Singly Linked List of integers. The task is to find the N-th node from the end of the list.

    Example:

    Input:
    If the given list is (1 -> -2 -&g...
  • Ans. 

    Find the N-th node from the end of a Singly Linked List of integers.

    • Traverse the list to find the length L of the list.

    • Calculate the position of the N-th node from the beginning as L - N + 1.

    • Traverse the list again to reach the calculated position and return the node's value.

  • Answered by AI
  • Q2. 

    LCA of Binary Tree Problem Statement

    You are given a binary tree consisting of distinct integers and two nodes, X and Y. Your task is to find and return the Lowest Common Ancestor (LCA) of these two nodes...

  • Ans. 

    Find the Lowest Common Ancestor (LCA) of two nodes in a binary tree.

    • Traverse the binary tree to find the paths from the root to nodes X and Y.

    • Compare the paths to find the last common node, which is the LCA.

    • Handle cases where one node is an ancestor of the other or when one node is the LCA itself.

  • Answered by AI
  • Q3. 

    Reverse Words in a String: Problem Statement

    You are given a string of length N. Your task is to reverse the string word by word. The input may contain multiple spaces between words and may have leading o...

  • Ans. 

    Reverse words in a string while handling leading/trailing spaces and multiple spaces between words.

    • Split the input string by spaces to get individual words

    • Reverse the list of words

    • Join the reversed words with a single space in between

    • Handle leading/trailing spaces by stripping them before and after reversing

  • Answered by AI
Round 3 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions based on DSA

  • Q1. 

    Minimum Time To Solve The Problems

    Given 'N' subjects, each containing a certain number of problems, and 'K' friends, assign subjects to friends such that each subject goes to exactly one friend, maintain...

  • Ans. 

    Assign subjects to friends to minimize maximum workload, find minimum time for most loaded friend.

    • Sort subjects in descending order

    • Assign subjects to friends one by one until all subjects are assigned

    • The maximum workload will be the sum of problems assigned to the friend with the most problems

    • Return the maximum workload as the minimum time required

  • Answered by AI
  • Q2. What is grammar in the context of compiler design?
  • Ans. 

    Grammar in compiler design defines the syntax and structure of a programming language.

    • Grammar specifies the rules for forming valid statements in a programming language.

    • It consists of a set of production rules that define how valid programs can be constructed.

    • There are different types of grammars such as context-free grammar, regular grammar, etc.

    • Example: In C programming language, the grammar specifies that a for loop...

  • Answered by AI
  • Q3. What is a token in compiler design?
  • Ans. 

    A token in compiler design is a basic unit of syntax that the compiler can understand and process.

    • Tokens are the smallest units of a program that are meaningful to the compiler.

    • Examples of tokens include keywords, identifiers, operators, and punctuation symbols.

    • Tokens are generated by the lexical analysis phase of the compiler.

    • Tokens are used by the parser to build the abstract syntax tree of the program.

  • Answered by AI
Round 4 - Video Call 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions on DSA and Compiler Design mainly. He told me that you’ll be having your final HR round in some time. I knew that I was going well because he seemed to be quite satisfied with my answers.

  • Q1. 

    Sum Root to Leaf Numbers

    You are given an arbitrary binary tree consisting of N nodes, each associated with an integer value from 1 to 9. Each root-to-leaf path can be considered a number formed by concat...

  • Ans. 

    Find the total sum of all root to leaf paths in a binary tree formed by concatenating node values.

    • Traverse the binary tree from root to leaf nodes, keeping track of the current path sum

    • Add the current path sum to the total sum when reaching a leaf node

    • Use modulo (10^9 + 7) to handle large outputs

  • Answered by AI
  • Q2. What is a regular language?
  • Ans. 

    A regular language is a language that can be recognized by a finite automaton.

    • Regular languages can be described by regular expressions.

    • Regular languages are closed under union, concatenation, and Kleene star operations.

    • Examples of regular languages include the set of all strings over an alphabet that contain an even number of 'a's.

  • Answered by AI
  • Q3. What are NP and NP-Hard problems?
  • Ans. 

    NP problems are decision problems that can be verified in polynomial time, while NP-Hard problems are at least as hard as the hardest problems in NP.

    • NP problems can be verified in polynomial time but not necessarily solved in polynomial time.

    • NP-Hard problems are at least as hard as the hardest problems in NP, but may not be in NP themselves.

    • Examples of NP problems include the subset sum problem and the traveling salesm...

  • Answered by AI
Round 5 - HR 

Round duration - 30 minutes
Round difficulty - Easy

That was the round for which I’ve been waiting for hours 
She was very friendly and nice to talk to. It didn’t seem that I was talking to the HR. It was more like talking to a friend. Finally we discussed about the pay-scale and work culture in Accolite.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAAccolite Digital Pvt Ltd interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I appeared for an interview in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

I appeared for an interview in Sep 2019.

Interview Questionnaire 

1 Question

  • Q1. Pl sql related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - y resume was referd through a guy. Later I got call from HR for interview schedule he asked me my expected ctc and Notice Period to which I clearly said 3 months. He scheduled my interview on weekends morning 8am I reached there by 8.30am The interview process got started late by 10am it was an walk in type interview 1 round was Technical I cleared that round and had a feedback session with HR he said we are processing u to next round which was Manager round there itself I told the HR my NP is 3months the Hr Told its not an issue.
Laterly after I had lunch by 2pm Hr came n told me that Manager is not available now so we will be conducting ur further round in weekdays.
Then there was no mail or call so I purposely mailed them still haven't got proper response from them, so at last I told my friend who referd me to ask for an update the same HR told him that they want Immediate joiner so we can't process him to further round. Wasted my whole day over there

Aarav Global Products & Services Private Limited Interview FAQs

How many rounds are there in Aarav Global Products & Services Private Limited interview?
Aarav Global Products & Services Private Limited interview process usually has 2 rounds. The most common rounds in the Aarav Global Products & Services Private Limited interview process are HR, Resume Shortlist and Technical.
How to prepare for Aarav Global Products & Services Private Limited 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 Aarav Global Products & Services Private Limited. The most common topics and skills that interviewers at Aarav Global Products & Services Private Limited expect are Java, Linux Administration, Oracle DBA, RAC and .Net.
What are the top questions asked in Aarav Global Products & Services Private Limited interview?

Some of the top questions asked at the Aarav Global Products & Services Private Limited interview -

  1. Difference between interface and abstraction,Difference between encapsulation a...read more
  2. DIFFERENCE BETWEEN SP AND FUNCTI...read more
  3. What are the components of ...read more

Tell us how to improve this page.

Aarav Global Products & Services Private Limited Interview Process

based on 9 interviews

Interview experience

2.8
  
Poor
View more

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.6
 • 336 Interviews
CitiusTech Interview Questions
3.4
 • 270 Interviews
NeoSOFT Interview Questions
3.6
 • 263 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Episource Interview Questions
3.9
 • 220 Interviews
Altimetrik Interview Questions
3.8
 • 217 Interviews
Incedo Interview Questions
3.1
 • 181 Interviews
Xoriant Interview Questions
4.1
 • 181 Interviews
View all

Aarav Global Products & Services Private Limited Reviews and Ratings

based on 142 reviews

2.8/5

Rating in categories

2.6

Skill development

2.7

Work-life balance

2.7

Salary

2.5

Job security

2.5

Company culture

2.5

Promotions

2.6

Work satisfaction

Explore 142 Reviews and Ratings
MongoDB / Postgress Database Administrator

New Delhi,

Delhi/Ncr

7-12 Yrs

Not Disclosed

Fullstack Developer

New Delhi,

Delhi/Ncr

7-12 Yrs

Not Disclosed

Explore more jobs
Senior Consultant
54 salaries
unlock blur

₹2 L/yr - ₹11.7 L/yr

Consultant
47 salaries
unlock blur

₹1.9 L/yr - ₹6 L/yr

IT Consultant
18 salaries
unlock blur

₹3.1 L/yr - ₹6.5 L/yr

Project Manager
13 salaries
unlock blur

₹6.5 L/yr - ₹15 L/yr

Linux Administrator
12 salaries
unlock blur

₹2.8 L/yr - ₹7.6 L/yr

Explore more salaries
Compare Aarav Global Products & Services Private Limited with

ITC Infotech

3.6
Compare

CMS IT Services

3.1
Compare

KocharTech

3.9
Compare

Xoriant

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