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 was interviewed 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

Interview Preparation Tips

Round: Test
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40

Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.

Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.

Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P

General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore

I was interviewed in Mar 2017.

Interview Questionnaire 

1 Question

  • Q1. Views on their recruiting process
  • Ans. 

    I believe the recruiting process is thorough and well-organized.

    • The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.

    • They have a clear timeline for the hiring process and keep candidates informed of their progress.

    • Feedback is provided to candidates after interviews to help them improve for future opportunities.

  • Answered by AI

Interview Preparation Tips

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

(1 Question)

  • Q1. NLP based question
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Coding Test 

It was a 3 hour test with 144 questions

Round 2 - HR 

(1 Question)

  • Q1. Why did you select this company?
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jul 2023. There were 5 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Aptitude Test 

Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question

Round 3 - Group Discussion 

Easy
50% went to next round

Round 4 - One-on-one 

(3 Questions)

  • Q1. Technical: SQL, DBMS, Basic programming questions- palindrome, fibonacci, discussion on projects and internships
  • Q2. Difference between UNION and UNION ALL
  • Ans. 

    UNION combines and removes duplicates, UNION ALL combines without removing duplicates.

    • UNION merges the results of two or more SELECT statements and removes duplicates.

    • UNION ALL merges the results of two or more SELECT statements without removing duplicates.

    • UNION is slower as it has to remove duplicates, while UNION ALL is faster.

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

    • Example: SELECT column...

  • Answered by AI
  • Q3. Types of SQL commands
  • Ans. 

    SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.

    • SELECT: retrieves data from a database

    • INSERT: adds new records to a table

    • UPDATE: modifies existing records in a table

    • DELETE: removes records from a table

    • CREATE: creates a new table, view, or index

    • DROP: deletes a table or index

  • Answered by AI
Round 5 - HR 

(1 Question)

  • Q1. Common HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on basics

Skills evaluated in this interview

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

I applied via Company Website and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Online platform,
SQL coding

Round 2 - Technical 

(1 Question)

  • Q1. In a one-on-one technical round, all they will ask around your resume
Round 3 - HR 

(1 Question)

  • Q1. Basic HR question on salary and personal backgroung

I applied via Referral and was interviewed in Aug 2022. There were 4 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 

Most questions were based on profit/loss and coding Questions are simple

Round 3 - Group Discussion 

Gave us topic on how education is important in our life

Round 4 - Technical 

(2 Questions)

  • Q1. Most Questions are on sql and machine learning as per my resume
  • Q2. Find the top two logged in people of each state in facebook

Interview Preparation Tips

Topics to prepare for LatentView Analytics Data Analyst interview:
  • SQL
Interview preparation tips for other job seekers - This one is a great opportunity to start your career as data analyst be sure with sql if you mentioned it.

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
NeenOpal Intelligent Solutions Data Engineer Salary
based on 5 salaries
₹10 L/yr - ₹12 L/yr
At par with the average Data Engineer Salary in India
View more details
Data Scientist
32 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate Consultant
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Machine Learning Engineer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare NeenOpal Intelligent Solutions with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

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