i
Filter interviews by
I applied via Naukri.com and was interviewed in Dec 2021. There were 4 interview rounds.
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...
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
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
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
I applied via Referral and was interviewed before Jan 2021. There were 2 interview rounds.
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.
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...
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...
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
Aarav Global Products & Services Private Limited interview questions for popular designations
I applied via Naukri.com and was interviewed before Dec 2020. There were 4 interview rounds.
I applied via Recruitment Consulltant and was interviewed before Apr 2021. There were 2 interview rounds.
Top trending discussions
I applied via Recruitment Consultant and was interviewed in Mar 2018. There was 1 interview round.
posted on 11 Mar 2022
I appeared for an interview before Mar 2021.
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.
You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:
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
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.
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.
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 ...
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.
Round duration - 60 minutes
Round difficulty - Medium
This was a technical round with DSA based questions.
You are given a Singly Linked List of integers. The task is to find the N-th node from the end of the list.
If the given list is (1 -> -2 -&g...
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.
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...
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.
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...
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
Round duration - 60 minutes
Round difficulty - Easy
Technical Interview round with questions based on DSA
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...
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
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...
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.
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.
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...
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
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.
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...
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.
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.
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.
I appeared for an interview in Sep 2017.
I appeared for an interview in Sep 2019.
based on 9 interviews
Interview experience
based on 142 reviews
Rating in categories
Senior Consultant
54
salaries
| ₹2 L/yr - ₹11.7 L/yr |
Consultant
47
salaries
| ₹1.9 L/yr - ₹6 L/yr |
IT Consultant
18
salaries
| ₹3.1 L/yr - ₹6.5 L/yr |
Project Manager
13
salaries
| ₹6.5 L/yr - ₹15 L/yr |
Linux Administrator
12
salaries
| ₹2.8 L/yr - ₹7.6 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant