Upload Button Icon Add office photos

Filter interviews by

AdvaRisk Data Engineer Interview Questions and Answers

Updated 20 Oct 2023

AdvaRisk Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 20 Oct 2023

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2023. There were 3 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 - Aptitude Test 

Its too easy . Just clear your basic concepts

Round 3 - Technical 

(2 Questions)

  • Q1. Concepts of oops
  • Q2. List vs tuple , goal in life

Interview Preparation Tips

Interview preparation tips for other job seekers - Python ,OOps , ML

Interview questions from similar companies

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

I applied via campus placement at Netaji Subhas Institute of Technology (NSIT) and was interviewed before Oct 2023. There were 3 interview rounds.

Round 1 - Coding Test 

It was demure and well balanced.

Round 2 - Technical 

(2 Questions)

  • Q1. Databases based on resume.
  • Q2. Sql based questions
Round 3 - One-on-one 

(2 Questions)

  • Q1. Sql based question
  • Q2. Resume and intern experiences.

Interview Preparation Tips

Interview preparation tips for other job seekers - be thorough with resume.

I applied via I don't remember and was interviewed in Aug 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. About experience DBMS questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't take the job if your gut says the interviewer wasn't polite during the interview.

I dint feel comfortable right from the start of the interview. The interviewer was condescending and not accepting even correct answers and claiming I failed to know basic stuff required for the role. I ended the interview in less than half the time it was scheduled for. I'm sure I don't want to work under such a person who wants to keep rejecting answers and pointing how you did not know answer to a question.

Interview is generally to understand how good the candidate is and how good the company is. After first 5 mins of the call I knew I dint want to work there. He added a team member just to tell him if there was any important thing he had to look into (like that other guy is some kind of service assistant to him).

Even after I accepted I wasn't the right fit for the role and bailed, he again pointed out how I barely knew anything that I should for the role (which is not necessary as the interview is over).
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. DSA question with Some Stack
  • Q2. Discussion around Current project
Round 2 - One-on-one 

(2 Questions)

  • Q1. Managerial discussion around resume and some basic java and spring question
  • Q2. Java and spring boot question
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed in Nov 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Questions from arrays and strings and some aptitude questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. How to merge 2 csv files
  • Ans. 

    To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.

    • Open both CSV files in a software like Microsoft Excel.

    • Copy the data from one CSV file and paste it into the other CSV file.

    • Save the merged CSV file with a new name.

    • Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.

  • Answered by AI
  • Q2. Basic questions on arrays
Round 3 - HR 

(1 Question)

  • Q1. 3 reasons why u choose this company
  • Ans. 

    I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.

    • Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.

    • Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.

    • Company culture - I value a positive work environment and the...

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. Questions on python

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
Not Selected

I applied via Naukri.com

Round 1 - Technical 

(4 Questions)

  • Q1. Asked to write a program to check whether string is valid or not. String consists of only three kind of special characters "(), [], {}". We need to return true if all special characters are in correct for...
  • Q2. What is useRef hook used for?
  • Ans. 

    useRef hook is used to persist a mutable value across renders without causing a re-render.

    • Used to store mutable values that do not trigger re-renders.

    • Commonly used for accessing DOM elements or storing previous values.

    • Does not cause a re-render when the value changes.

  • Answered by AI
  • Q3. What are the best practices to avoid rerenders and to improve performance
  • Ans. 

    Use memoization, virtual DOM, and shouldComponentUpdate to avoid unnecessary rerenders and improve performance.

    • Implement memoization to store the result of expensive function calls and avoid recalculating them.

    • Use virtual DOM to efficiently update only the parts of the UI that have changed.

    • Override shouldComponentUpdate to prevent unnecessary rerenders by comparing current and next props/state.

  • Answered by AI
  • Q4. What are callbacks, Promises, async await
  • Ans. 

    Callbacks, Promises, async await are asynchronous programming concepts in JavaScript.

    • Callbacks are functions passed as arguments to another function to be executed later.

    • Promises are objects representing the eventual completion or failure of an asynchronous operation.

    • async await is a syntax for writing asynchronous code that looks synchronous, making it easier to read and maintain.

    • Example: Using a callback to handle th...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Interviewer asked me basic SQL questions
  • Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Round 2 - Coding Test 

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It was an online assessment. Some coding questions. Some cs fundamental mcqs. SQL query, Rest Api question.

Round 2 - Assignment 

An assignment to create a game using nodejs/ go lang/ java.

Round 3 - Technical 

(2 Questions)

  • Q1. Discussion related to Assignment. Told some changes and told to add some more functionalities.
  • Q2. Some APIS were given. It was case study. You had to show the dishes to a customer according to his preferences.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Coding Test 

Questions were crayon box ,the bot and the game and happy neighbourhood for 90 mins

Round 2 - Technical 

(2 Questions)

  • Q1. Array basics was asked
  • Q2. Segment tree,prefix sum
Round 3 - Technical 

(1 Question)

  • Q1. Low level design was asked
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Design Booking Management System
  • Ans. 

    Design a Booking Management System for handling reservations and scheduling.

    • Create a user-friendly interface for customers to make bookings

    • Implement a database to store booking information

    • Include features for managing availability, cancellations, and payments

  • Answered by AI

Skills evaluated in this interview

AdvaRisk Interview FAQs

How many rounds are there in AdvaRisk Data Engineer interview?
AdvaRisk interview process usually has 3 rounds. The most common rounds in the AdvaRisk interview process are Resume Shortlist, Aptitude Test and Technical.
How to prepare for AdvaRisk 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 AdvaRisk. The most common topics and skills that interviewers at AdvaRisk expect are MongoDB, Python, ETL, MySQL and SQL.

Tell us how to improve this page.

AdvaRisk Data Engineer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 429 Interviews
Udaan Interview Questions
4.0
 • 335 Interviews
Meesho Interview Questions
3.7
 • 329 Interviews
CARS24 Interview Questions
3.6
 • 323 Interviews
Zepto Interview Questions
3.5
 • 197 Interviews
Blinkit Interview Questions
3.7
 • 179 Interviews
BlackBuck Interview Questions
3.8
 • 172 Interviews
Tata AIG Interview Questions
4.1
 • 153 Interviews
View all

AdvaRisk Data Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
16 salaries
unlock blur

₹4 L/yr - ₹10.5 L/yr

Operations Associate
7 salaries
unlock blur

₹1 L/yr - ₹3.1 L/yr

Product Manager
7 salaries
unlock blur

₹8 L/yr - ₹30 L/yr

Research Analyst
6 salaries
unlock blur

₹1.8 L/yr - ₹4.5 L/yr

Business Analyst
5 salaries
unlock blur

₹6 L/yr - ₹10.8 L/yr

Explore more salaries
Compare AdvaRisk with

ICICI Lombard General Insurance Company

3.7
Compare

Bajaj Allianz General Insurance

3.9
Compare

HDFC Ergo General Insurance

3.9
Compare

Tata AIG

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