AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
NeenOpal Intelligent Solutions Interview Questions, Process, and Tips
Top NeenOpal Intelligent Solutions Interview Questions and Answers
- Q1. Q2.) Difference between list and tuple? a = [1,2,3,4,5,6,7,8,9] print(a[-1:-5]) Without running this code in compiler, tell the outputasked in Data Scientist interview
- Q2. You have a 7 minutes hourglass and a 4 minutes hourglass, now figure out a way to calculate 9 minutesasked in Data Analyst interview
- Q3. how to removes duplicates in sparkasked in Data Engineer interview
NeenOpal Intelligent Solutions Interview Experiences
13 interviews found
Anonymous
(2 Questions)
- Q1. Sql related Questions
- Q2. Dax related Questions
Senior Data Analyst Interview Questions asked at other Companies
I appeared for an interview in Jan 2025.
20 Questions in 20 min
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`.
Data Engineer Interview Questions asked at other Companies
(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
I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.
(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
- 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'])
Skills evaluated in this interview
Data Engineer Interview Questions asked at other Companies
NeenOpal Intelligent Solutions interview questions for popular designations
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
Excel, Python, SQL and Power BI
(3 Questions)
- Q1. Remove duplicates from an array without using any functions
- Ans.
Remove duplicates from an array without using any functions
Create an empty array to store unique values
Loop through the original array and check if the value is already in the unique array before adding it
Use nested loops to compare each element with all other elements in the array
- Q2. Create a single dimensional array from a multi dimensional array
- Ans.
To create a single dimensional array from a multi dimensional array, use the flatten method in Python.
Use the flatten method in Python to convert a multi dimensional array into a single dimensional array.
Example: multi_array = [[1, 2], [3, 4], [5, 6]]
single_array = [item for sublist in multi_array for item in sublist]
- Q3. You have a 7 minutes hourglass and a 4 minutes hourglass, now figure out a way to calculate 9 minutes
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
I applied via Campus Placement and was interviewed in Jul 2023. There were 3 interview rounds.
Two tasks, one python and one SQL based
(4 Questions)
- Q1. Q1.) Given sample data in text, read it in python Solution: Take the text to notepad, save it as CSV and then read it in python Check the number of null values Check the number of unique values Make a new...
- Ans.
Read sample data in text, check for null and unique values, create new column by multiplying two features
Save text data as CSV and read in Python using pandas
Use isnull() to check for null values
Use nunique() to check for unique values
Create a new column by multiplying two existing columns
Add the new column to the existing dataframe
- Q2. Q3.) Query the minimum & maximum marks from the student table. Will the output be in the form of columns or rows. What to do in order to get the output in rows?
- Q3. Q2.) Difference between list and tuple? a = [1,2,3,4,5,6,7,8,9] print(a[-1:-5]) Without running this code in compiler, tell the output
- Ans.
The code will output an empty list as a result of slicing from -1 to -5 in the list 'a'.
Slicing in Python allows you to access a subset of elements in a list or tuple.
When slicing, the start index is inclusive and the end index is exclusive.
In this case, a[-1:-5] will result in an empty list because the start index -1 is greater than the end index -5.
- Q4. Q4.) Fibonacci series in python
- Ans.
Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.
Use a loop or recursion to generate Fibonacci series in Python.
Start with 0 and 1 as the first two numbers in the series.
Add the previous two numbers to get the next number in the series.
Interview Preparation Tips
- Python
- MySQL
- Puzzles
- Loogical reasoning
Skills evaluated in this interview
Data Scientist Interview Questions asked at other Companies
SQL, Pandas, Power BI
(1 Question)
- Q1. SQL and Pandas questions
Data Scientist Interview Questions asked at other Companies
tejesh goteti
(1 Question)
- Q1. Questions on Sand timer
Data Analyst Interview Questions asked at other Companies
It was based upon Tableau
(1 Question)
- Q1. They asked some python based question
Interview Preparation Tips
Data Analyst Interview Questions asked at other Companies
I applied via Referral and was interviewed in May 2023. There were 4 interview rounds.
The assignment consisted of three sections where the third section is optional and it only need some basic knowledge of SQL and python
(1 Question)
- Q1. Here the HR will ask you some questions related to python, SQL, and aptitude (just some basic questions)
(1 Question)
- Q1. More of a discussion of your previous projects
Interview Preparation Tips
Data Scientist Interview Questions asked at other Companies
I applied via LinkedIn and was interviewed in Mar 2023. There were 2 interview rounds.
1. The assignment inculded some questions that need to be answered through analysing a give set of data through SQL
2. Then there was an assignment to figure out multiple values from a given set of data by using SQL through Python. Related Jupyter notebook was to be shared.
3. This was an optional assignment of creating a dashboard for a given set of data using Tableau
(3 Questions)
- Q1. HR round started with introduction followed by two above average level Puzzle Questions.
- Q2. For technical part I was asked to write two SQL query to get asked data. I was asked questions regarding how the result would look like for different SQL queries
- Q3. Then I was asked some multiple choice questions regarding Python related to different data types and some psuedo codes, followed by coding test to print the Fibonacci sequence.
Interview Preparation Tips
- SQL
- Python
- NumPy
- Pandas
- Matplotlib
- PyPlot
- Power Bi
Data Analyst Intern Interview Questions asked at other Companies
Top trending discussions
NeenOpal Intelligent Solutions Interview FAQs
Some of the top questions asked at the NeenOpal Intelligent Solutions interview -
The duration of NeenOpal Intelligent Solutions interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
NeenOpal Intelligent Solutions Interviews By Designations
- NeenOpal Intelligent Solutions Data Scientist Interview Questions
- NeenOpal Intelligent Solutions Data Analyst Interview Questions
- NeenOpal Intelligent Solutions Data Engineer Interview Questions
- NeenOpal Intelligent Solutions Data Analyst Intern Interview Questions
- NeenOpal Intelligent Solutions Senior Data Analyst Interview Questions
Interview Questions for Popular Designations
NeenOpal Intelligent Solutions Interview Process
based on 14 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
NeenOpal Intelligent Solutions Reviews and Ratings
based on 16 reviews
Rating in categories
|
Data Scientist
32
salaries
|  ₹4.2 L/yr - ₹11.7 L/yr |
|
Data Analyst
16
salaries
| ₹5.2 L/yr - ₹10 L/yr |
|
Business Analyst
8
salaries
| ₹7.2 L/yr - ₹10.8 L/yr |
|
Senior Associate Consultant
8
salaries
| ₹14 L/yr - ₹15 L/yr |
|
Data Engineer
7
salaries
| ₹8 L/yr - ₹12 L/yr |
Amazon Sellers Services
Primus Global Technologies
GAMMON INDIA
Practo
- Home >
- Interviews >
- NeenOpal Intelligent Solutions Interview Questions
