+ Contribute
You can choose to be
anonymous
Create Post
Write a review
Share interview advice
Contribute salary
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
6
Company Overview
Company Locations
Filter interviews by
Aarav Global Products & Services Private Limited IT Consultant Interview Questions and Answers
Updated
29 Jan 2022
1 interview found
Sort by:
Popular
IT Consultant Interview Questions
Anonymous
posted on 29 Jan 2022
I applied via Referral and was interviewed before Jan 2021.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. Sql Linux MIS ATM reconciliation
2
HR Round (4 Questions)
- Q1. What are your salary expectations?
- Q2. Share details of your previous job.
- Q3. What are your strengths and weaknesses?
- Q4. Tell me about yourself.
Interview Preparation Tips
Topics to prepare for Aarav Global Products & Services Private Limited IT Consultant interview:
Should be global certification
- Global certification
Should be global certification
Interview questions from similar companies
Interview experience
Average
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Job Fair and was interviewed in Sep 2022.
3 Interview Rounds
1
Resume Shortlist Round
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
2
One-on-one Round (2 Questions)
- Q1. What is Supervised machine learning? Which algorithm you think you can explain brilliantly? Why we use random forest then normal decision tree
- Q2. Example of case study
3
Case Study Round
Retail case study , company trends salw.. Total sale. Profit charts and reports
Interview Preparation Tips
Interview preparation tips for other job seekers - Be prepared, coding practice and case study is important.
Anonymous
posted on 30 Oct 2022
4 Interview Rounds
1
Resume Shortlist Round
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
2
Technical Round (1 Question)
- Q1. Selenium & Java related questions.
3
Technical Round (2 Questions)
- Q1. Questions related to different tools and frameworks worked on.
- Q2. API related questions & tools used
4
HR Round (1 Question)
- Q1. Questions related to Genpact as an Organization.
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare for 2 technical rounds based on the your work experience.
Questions will be asked on the basis of programming language & frameworks you have worked on.
Questions will be asked on the basis of programming language & frameworks you have worked on.
Interview experience
Good
Difficulty level
-
Duration
-
Result
Selected
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2
Technical Round (1 Question)
- Q1. Focus on job descriptions and your domain knowledge
3
HR Round (1 Question)
- Q1. Focus on job descriptions and domain knowledge
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed before Aug 2022.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
2
One-on-one Round (3 Questions)
- Q1. Not sure about it
- Q2. Not sure about it will different based on requirements
- Q3. I am not sure about it will different based on requirements
Interview Preparation Tips
Interview preparation tips for other job seekers - Infogain having limited client. If you are in more than 100days in bench management will take further decision for fire you immediately. Your job is not secure this environment such as.
Interview experience
Good
Difficulty level
Hard
Duration
More than 8 weeks
Result
Selected
I applied via LinkedIn and was interviewed before Sep 2022.
5 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
2
Aptitude Test Round
1 Hour test and basic reasoning questions
3
Group Discussion Round
Work life balance for 30 min
4
One-on-one Round (1 Question)
- Q1. How can IT companies resolve the timely deliveries of orders
5
HR Round (2 Questions)
- Q1. Describe about the individual
- Q2. Choose from WFH or WFO
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Be truthful in your resume. It is very easy to catch false or lies during the interview by asking basic questions.
View all tips
2
Coding Test Round
Java development , android development
3
Technical Round (1 Question)
- Q1. What is java , development of calculator ,development for web page
Interview Preparation Tips
Interview preparation tips for other job seekers - prepare good and try hard
keep try until you get offer
keep try until you get offer
Interview Questions
- Q1. The interview revolved around the case solution presentation
Interview Preparation Tips
Interview preparation tips for other job seekers - Be sure of whatever analysis you’ve done with the case provided. The entire case discussion round will revolve around your findings. More than the solution, your sound reasoning ability and communication skills will be tested. There were some mistakes which I noticed while presenting the solution but was able to explain what went wrong as I laid out the core approach right from the start.
I applied via Recruitment Consultant and was interviewed before Sep 2020.
1 Interview Round
Interview Questions
- Q1. Questions on ports used for various services.
- Q2. Questions on HSRP.
- Q3. Questions on switching technologies like VLAN, VTP, STP.
Interview Preparation Tips
Interview preparation tips for other job seekers - Questions are mostly based on your resume, make sure you only mention topics that you have knowledge on your Resume.
I applied via Approached by Company and was interviewed before May 2021.
4 Interview Rounds
1
Coding Test Round
Online questions were based on scenarios to write SQL queries. Also got few questions on Python as well for which I had only limited knowledge.
2
Technical Round (8 Questions)
- Q1. I'm listing some of the questions here which the interviewers (2 panel resources) asked me regarding Informatica ETL, Oracle DB and I might have missed some of ...read more
- Q2. What happens if Treat source row property as "Update" at session level but at target object "Delete" is checked?
- Q3. What are the different types of dimension tables?
- Q4. What schema type was used in your previous project? And explain why it was used?
- Q5. Difference between Joiner and Lookup transformations?
- Q6. Scenario: I have records in a flat file ending with ; character at the end of each them. How to load these records into DB based on this character? What propert...read more
- Q7. How version control happened in your previous project?
- Q8. Which SCD type you worked on before and explain on that?
3
One-on-one Round (1 Question)
- Q1. This round was taken by the project manager on a phone call. He asked me few basic fundamental questions related to my skills and the things which I worked on i...read more
4
HR Round (1 Question)
- Q1. Just F2F discussion with HR finalising on the compensation structure, learning opportunities and the organisational benefits as an employee.
Interview Preparation Tips
Interview preparation tips for other job seekers - If you're an experienced person, be confident about the things which you handled in previous project and be precise on to the point. Don't elaborate too much as the interviewers might build up questions based on that. Be strong in your technical areas of expertise. Expect scenario based questions related to your skills.
Aarav Global Products & Services Private Limited Interview FAQs
How many rounds are there in Aarav Global Products & Services Private Limited IT Consultant 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 Technical and HR.
Aarav Global Products & Services Private Limited Interviews By Designations
- Aarav Global Products & Services Private Limited Business Analyst Interview Questions ·
- Aarav Global Products & Services Private Limited IT Consultant Interview Questions ·
- Aarav Global Products & Services Private Limited Network Telecom Engineer Interview Questions ·
- Aarav Global Products & Services Private Limited Software Developer and Consultant Interview Questions
Interview Questions for Popular Designations
- Consultant Interview Questions ·
- Associate Consultant Interview Questions ·
- Senior Consultant Interview Questions ·
- Lead Consultant Interview Questions ·
- AST Consultant Interview Questions ·
- Technical Consultant Interview Questions ·
- SAP Fico Consultant Interview Questions ·
- Senior Associate Consultant Interview Questions
- Show more
Tell us how to improve this page.
People are getting interviews through
based on 1 Aarav Global Products & Services Private Limited interview
Referral
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Interview Questions from Similar Companies
Aarav Global Products & Services Private Limited IT Consultant
Salary
based on 18 salaries
₹ 4.4 L
₹
3.1L ₹
6.5L
42%
less
than the average IT Consultant Salary in India
View more details Aarav Global Products & Services Private Limited IT Consultant Reviews and Ratings
based on 80 reviews
Rating in categories
2.0
Skill development
1.8
Work-Life balance
1.8
Salary & Benefits
1.8
Job Security
1.8
Company culture
1.8
Promotions/Appraisal
1.8
Work Satisfaction
Reviews
Worst company. Not given my fnf. Terminated employee without any reason.
Compare Aarav Global Products & Services Private Limited with
KocharTech
Compare
RMSI
Compare
Xoriant
Compare
Sify Technologies
Compare
- Home >
- Interviews >
- Aarav Global Products & Services Private Limited Interview Questions >
- Aarav Global Products & Services Private Limited IT Consultant Interview Questions
Anonymous
11mon ago
This is totally fake company