Upload Button Icon Add office photos

Filter interviews by

NeenOpal Intelligent Solutions Data Engineer Interview Questions and Answers

Updated 12 Feb 2025

NeenOpal Intelligent Solutions Data Engineer Interview Experiences

3 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 12 Feb 2025

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I appeared for an interview in Jan 2025.

Round 1 - Aptitude Test 

20 Questions in 20 min

Round 2 - Coding Test 

Q1. To measure exactly 9 minutes using the 4-minute and 7-minute sand timers, follow these steps:

1. Start both the 4-minute and 7-minute timers at the same time.
2. When the 4-minute timer runs out, flip it immediately. At this point, 4 minutes have passed, and there are 3 minutes left on the 7-minute timer.
3. When the 7-minute timer runs out, 3 minutes have passed since you flipped the 4-minute timer, totaling 7 minutes. At this point, the 4-minute timer has been running for 3 minutes (1 minute left).
4. When the 4-minute timer runs out again (after 1 more minute), a total of 8 minutes has passed.
5. Finally, flip the 4-minute timer one last time. Wait for 1 more minute, which will give you a total of 9 minutes.

Q2. The SQL query provided will select all customers who do not have any orders. It retrieves customer IDs from the `Customers` table where the `customer_id` is not present in the `Orders` table.

Q3. The first SQL query retrieves the second oldest customer from the `Customers` table by selecting their `first_name` and `age`, ordering the results by age in descending order, and skipping the oldest customer with an offset of 1.

The second SQL query counts how many orders each customer has placed and selects customers who have placed more than one order, grouping the results by `customer_id` and including their `first_name`.

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

(1 Question)

  • Q1. THey ask about your experience and projects youve worked on create table fact_product ( order_date varchar, order_id varchar, product_id varchar, quantity int, price int ); insert into fact_pr...

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 13 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. List vs tuple difference
  • Ans. 

    List is mutable, tuple is immutable in Python.

    • List can be modified after creation, tuple cannot be modified

    • List uses square brackets [], tuple uses parentheses ()

    • List is used for collections of items that may need to be changed, tuple is used for fixed collections

  • Answered by AI
  • Q2. How to removes duplicates in spark
  • Ans. 

    Use dropDuplicates() function in Spark to remove duplicates from a DataFrame.

    • Use dropDuplicates() function on the DataFrame to remove duplicates based on all columns

    • Specify columns to check for duplicates by passing them as arguments to dropDuplicates() function

    • Example: df.dropDuplicates() or df.dropDuplicates(['col1', 'col2'])

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Practo user image Pratik Chaudhari

posted on 17 Nov 2015

I applied via Referral

Interview Preparation Tips

Round: Resume Shortlist
Experience: Sent resume to an HR through Linkedin and got the call for interview

Round: Technical Interview
Experience: Had 3 rounds of technical interviews with Product Owner, Product Manager and VP Product. Most of the questions were related to maths, statistics and a few on machine learning. Even though I did not have much background on these, I was asked to give my inputs and try to find a solution. We discussed recommendation engines for Quora, Linkedin and e-commerce websites. Then they asked me how can we remove the bias that comes in the practo ratings of the doctors due to feedback from various channels. How can we identify if the customer is booking an appointment by looking at reviews or ratings? How can we identify spam reviews before publishing them? How can we build a product which can help users write a better quality review? Most of the questions were related to data science and how we can improve the products using data. The data analyst role for which I was being interviewed, was a first of its kind role in Practo. The JD was to basically work with the product team and help them in improving products, building new features etc. using data science/ data analytics.

Skills: Product Sense, Attitude, Data Science, Data Analysis, Basics Of Machine Learning
College Name: IIT Madras
Motivation: being the leader of the healthcare industry, high growth startup, opportunity to solve interesting problems using data
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Sql questions database modelling

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

I applied via Approached by Company and was interviewed in May 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Project discussion, spark, python, sql, big data discussion
Round 2 - Behavioral interview 

(1 Question)

  • Q1. Project discussion and company profile alignment discussion
Round 3 - Case Study 

Data Modelling question and project discussion

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Assignment 

Assignment was based on figma

Interview experience
5
Excellent
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Easy to moderate general aptitude questions were asked

Round 2 - Coding Test 

Easy to moderate questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Just prepare aptitude topics well
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

MCQ - OS,DBMS,C++,Python

Round 2 - Coding Test 

STRING, ROMAN TO INTEGER

Interview Preparation Tips

Interview preparation tips for other job seekers - Do prepare well
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

Good very good have a nice day

Round 2 - One-on-one 

(2 Questions)

  • Q1. Very godo as well as very good
  • Q2. Very well manage the team as wells

Interview Preparation Tips

Interview preparation tips for other job seekers - dsfiasdfuasidfa aspdfaspod psdfasdpf pasdos dpf asdpfspfo[

NeenOpal Intelligent Solutions Interview FAQs

How many rounds are there in NeenOpal Intelligent Solutions Data Engineer interview?
NeenOpal Intelligent Solutions interview process usually has 1-2 rounds. The most common rounds in the NeenOpal Intelligent Solutions interview process are Technical, Aptitude Test and Coding Test.
How to prepare for NeenOpal Intelligent Solutions 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 NeenOpal Intelligent Solutions . The most common topics and skills that interviewers at NeenOpal Intelligent Solutions expect are AWS, Azure, Data Processing, ETL and Export.
What are the top questions asked in NeenOpal Intelligent Solutions Data Engineer interview?

Some of the top questions asked at the NeenOpal Intelligent Solutions Data Engineer interview -

  1. how to removes duplicates in sp...read more
  2. List vs tuple differe...read more

Tell us how to improve this page.

NeenOpal Intelligent Solutions Data Engineer Interview Process

based on 3 interviews

Interview experience

2.7
  
Poor
View more

Interview Questions from Similar Companies

Deltax Interview Questions
2.7
 • 84 Interviews
Practo Interview Questions
3.1
 • 74 Interviews
Wayfair Interview Questions
3.6
 • 56 Interviews
Busibud Interview Questions
4.0
 • 42 Interviews
View all
NeenOpal Intelligent Solutions Data Engineer Salary
based on 7 salaries
₹8 L/yr - ₹12 L/yr
At par with the average Data Engineer Salary in India
View more details
Data Scientist
32 salaries
unlock blur

₹4.2 L/yr - ₹11.7 L/yr

Data Analyst
16 salaries
unlock blur

₹5.2 L/yr - ₹10 L/yr

Business Analyst
8 salaries
unlock blur

₹7.2 L/yr - ₹10.8 L/yr

Senior Associate Consultant
8 salaries
unlock blur

₹14 L/yr - ₹15 L/yr

Data Engineer
7 salaries
unlock blur

₹8 L/yr - ₹12 L/yr

Explore more salaries
Compare NeenOpal Intelligent Solutions with

Amazon Sellers Services

4.0
Compare

Primus Global Technologies

3.9
Compare

GAMMON INDIA

3.8
Compare

Practo

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