Upload Button Icon Add office photos

Filter interviews by

Amber Group India Data Engineer Interview Questions and Answers

Updated 10 Nov 2024

Amber Group India Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Abinash Mishra

posted on 10 Nov 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is the difference between Union and Union all
  • Ans. 

    Union combines and removes duplicates, Union all combines without removing duplicates

    • Union combines result sets and removes duplicates

    • Union all combines result sets without removing duplicates

    • Union is slower than Union all as it involves removing duplicates

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1.  overloading ,inheritance concepts,structures,pointers

Interview Preparation Tips

Interview preparation tips for other job seekers - have good understanding of basics and have expertise on any specific area.

Interview Questionnaire 

2 Questions

  • Q1. Basic Programming Questions, Data structures, SQL queries
  • Q2. This was the most simple one, they simply asked introduce yourself and fine with night shifts.

Interview Preparation Tips

General Tips: I joined HCL as a fresher and got Intervie

Interview Questionnaire 

1 Question

  • Q1. What I know and what I don't know

Interview Preparation Tips

Round: Test
Experience: Aptitude, reasoning, logical, etc. 2 hours

Interview Questionnaire 

2 Questions

  • Q1. C and C++ - technically related stuffs
  • Q2. Communicate and fluency

I was interviewed in Feb 2017.

Interview Preparation Tips

Round: Resume Shortlist
Tips: skill and experience is priority

Round: Test
Experience: subjective questions
Duration: 1 hour

Round: Technical Interview
Experience: c++ questions

Round: HR Interview
Experience: experience and past details

Interview Preparation Tips

Round: Test
Experience: CAT type questions were asked.
Duration: 75 minutes

Round: HR Interview
Experience: It was a nice experience.Basic simple questions were asked, like- family background, achievement,s extracurricular activities, projects, etc.
Tips: Be calm and confident.

College Name: NIT WARANGAL

Interview Questionnaire 

4 Questions

  • Q1. Tell about yourself
  • Q2. Basic c programs
  • Q3. Tell about your parents
  • Q4. Explain your standing project

Interview Preparation Tips

Round: Resume Shortlist
Experience: They have selected those who have no standing arrears
Tips: Clear  arrears before 5 sem

Round: Test
Experience: Quantitative is little tough but i am lucky that i am able to solve the problems
Tips: Use formulas
Duration: 65 minutes
Total Questions: 90 min

Round: Group Discussion
Experience: No group discussion
Tips: Prepare well for GD

Round: HR Interview
Experience: I have spoke for 2 min and hr was impressed for it. Wrote some programs. Explained my project
Tips: For any hr interview prepare about your self. Learn some basic c programs, learn your project diagram. If u have any questions ask to hr to impress him

General Tips: Start doing some apptitude questions
Skill Tips: Whatever you talk,  speak it clearly. Dont get tension
Skills: communication skill
College Name: SATHYABAMA UNIVERSITY
Motivation: Our seniors

Interview Questionnaire 

8 Questions

  • Q1. Explain ur Training project
  • Ans. 

    My training project involved designing and implementing a network infrastructure for a medium-sized company.

    • Researched and analyzed the company's requirements for network connectivity and security.

    • Designed a network architecture that included routers, switches, firewalls, and VPNs.

    • Configured and tested the network devices to ensure proper functionality.

    • Implemented security measures such as access control lists and intr...

  • Answered by AI
  • Q2. How the apps in the mobile works..??
  • Ans. 

    Mobile apps work by running code on the device to perform specific tasks and interact with the user.

    • Mobile apps are developed using programming languages like Java, Swift, or Kotlin.

    • Apps are installed on the device and run locally, utilizing the device's resources.

    • They can access device features like camera, GPS, and sensors.

    • Apps communicate with servers or APIs to fetch data or perform actions.

    • User interactions trigge...

  • Answered by AI
  • Q3. What is Big Data..??
  • Ans. 

    Big Data refers to large and complex sets of data that cannot be easily managed or processed using traditional methods.

    • Big Data is characterized by the 3Vs: Volume, Velocity, and Variety.

    • Volume refers to the vast amount of data generated and collected from various sources.

    • Velocity refers to the speed at which data is generated and needs to be processed in real-time.

    • Variety refers to the different types and formats of d...

  • Answered by AI
  • Q4. What do u mean by SMAC..??
  • Ans. 

    SMAC stands for Social, Mobile, Analytics, and Cloud.

    • SMAC is a combination of four technologies that are transforming businesses and industries.

    • Social refers to the use of social media platforms for communication and collaboration.

    • Mobile refers to the use of mobile devices and applications for accessing information and services.

    • Analytics refers to the use of data analysis tools and techniques to gain insights and make ...

  • Answered by AI
  • Q5. Tell me about urself
  • Ans. 

    I am a system engineer with expertise in designing and maintaining complex computer systems.

    • Experienced in configuring and troubleshooting network devices

    • Proficient in scripting languages like Python and Bash

    • Skilled in virtualization technologies such as VMware and Hyper-V

    • Knowledgeable in cloud computing platforms like AWS and Azure

    • Familiar with ITIL best practices for service management

  • Answered by AI
  • Q6. What r ur hobies and interests..??
  • Q7. What r ur strengths..??
  • Q8. Why u want to join our company..??

Interview Preparation Tips

Round: Test
Experience: It was a challenging but exciting experience for me..!! I felt a lil bit shortage of time to complete the test.
Tips: Keep last 5 mins for guessing the answer and marking it.
Duration: 90 minutes
Total Questions: 74

Round: Technical Interview
Experience: It gave me a wonderful platform to speak about my project..!!
I cudn't answer many of the questions..!!
Tips: Tell ur answer watever u know confidently..!!
Answer the questions upto the point.
Don't let ur answers puzzle u.

Round: HR Interview
Experience: I spoke very confidently..!!
Tips: Improve ur communication skills.
Tell ur answers after feeling it from ur heart.
Watever u say, say it confidently.
Don't boast urself..don't bluff dere.
Always smile in between.

Skill Tips: learn new words daily and put a habbit of public speaking.
Skills: Communication Skills
College Name: KIIT UNIVERSITY

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Questions vary from HR to HR

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resume is the most important part of your whole placement process. Your resume reflects your whole profile, what you are. So, we had to do that properly. Main thing is the format of the resume. For getting the proper format itself we had to go through a lot, but our staffs do guide us so that's not a problem.
Tips: Stick to the proper and latest format and make sure your resume shouldn't be more than 2 pages, that's ideal for a fresher. Write only those points that are valid and if any question asked related to that, you can answer.

Round: Test
Experience: We had gone through a lot of practice tests during the placement classes and if your English is good, you will easily get through it. They just give basic grammer which we have already learnt in our school days. The Quant's part is also easy and basic maths that we have done in our primary school (7-10). Reasoning part completely based on your IQ level.
Tips: Focus on your vocabulary. Read books, articles and whatever you can. Just keep yourself up to date. Practice the basic quants. There are various books for both Quant's and reasoning. Just keep practising.
Duration: 30 mins minutes
Total Questions: depends (20-30)

Round: HR Interview
Experience: I had a very tough experience. Since I'm from Biotechnology department, I was asked questions like why do I want to work in an IT company. They were actually testing my patience and I got through it. Your HR interview depends on your HR itself, even the time limit. My interview went for almost half an hour, but for few it got over even in 10-15 mins, so it depends.
Tips: Just be confident. Presentation is very important. Present yourself in a confident manner and be calm and patience. You should have good communication skill.

General Tips: Be confident and patient. Make sure you choose the proper job for yourself and have interest in that field. You will get through it. Placement is not that tough as you think. Just have confidence in yourself and you will get it. All the best.
Skills: Quants, verbal, reasoning, Soft skills, Communication skill
College Name: SATHYABAMA UNIVERSITY
Motivation: I have always wanted to go in this and Infosys is considered as one the top IT companies in India and more over they offer you the best training. An infocician is highly recognised outside. Last but not the least, you have the biggest and the best campus for Infosys.
Funny Moments: Nothing as such, but I had really a funny HR round. For half an hour he kept Me asking the same question just to check my patience level. We had a great time during the placement classes. All the staffs were very friendly and interactive.

Amber Group India Interview FAQs

How many rounds are there in Amber Group India Data Engineer interview?
Amber Group India interview process usually has 1 rounds. The most common rounds in the Amber Group India interview process are Technical.

Tell us how to improve this page.

Amber Group India Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Assistant Manager
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Engineer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Deputy Manager
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Production Engineer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive - Stores
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Amber Group India with

Reliance Industries

4.0
Compare

Tata Group

4.2
Compare

Adani Group

3.9
Compare

Mahindra & Mahindra

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