AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
NexGen Technologies Data Analyst Interview Questions and Answers
NexGen Technologies Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Apr 2023. There were 3 interview rounds.
Data analyst responsibility
Data mining and profiling
What is data cleaning?
(3 Questions)
- Q1. Capitalize the first character of string
- Ans.
Capitalize the first character of a string
Use a function to capitalize the first character of the string
Ensure to handle cases where the string is empty or already capitalized
Example: 'hello' -> 'Hello', 'data analyst' -> 'Data analyst'
- Q2. Write a program to print First 10 natural numbers
- Ans.
Program to print first 10 natural numbers
Use a loop to iterate from 1 to 10
Print each number in the loop
- Q3. Write a program to print First 10 even no
- Ans.
Program to print first 10 even numbers
Initialize a counter variable to keep track of even numbers
Use a loop to iterate through numbers and print even numbers
Stop the loop when 10 even numbers are printed
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Basic Apititude Questions
(2 Questions)
- Q1. Difference between WHERE and HAVING??
- Ans.
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
WHERE is used with SELECT statement to filter rows based on a condition
HAVING is used with GROUP BY statement to filter groups based on a condition
WHERE is applied before data is grouped, HAVING is applied after data is grouped
Example: SELECT * FROM table WHERE column = 'value'
Example: SELECT column, COUNT(*) FROM table GROUP B
- Q2. Where- Row Level Filters Having-Aggregate Filters
- Ans.
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
Row level filters are used to filter individual rows of data before any aggregations are performed.
Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.
Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...
(2 Questions)
- Q1. Why do you wanna join Uber?
- Q2. Best Company Ever
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
Asked a few questions regarding my experience
Selected
I applied via Company Website and was interviewed in Feb 2024. There was 1 interview round.
(3 Questions)
- Q1. Projects Worked
- Ans.
I have worked on various projects involving data analysis, visualization, and interpretation.
Developed predictive models using machine learning algorithms
Performed data cleaning and preprocessing to ensure accuracy
Created interactive dashboards for stakeholders to easily understand insights
- Q2. SQL functions used in the projects
- Ans.
Common SQL functions used in projects include COUNT, SUM, AVG, MAX, MIN, and GROUP BY.
COUNT: Used to count the number of rows in a table.
SUM: Used to calculate the sum of a column.
AVG: Used to calculate the average value of a column.
MAX: Used to find the maximum value in a column.
MIN: Used to find the minimum value in a column.
GROUP BY: Used to group rows that have the same values into summary rows.
- Q3. Machine learning alogriths
Skills evaluated in this interview
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. What are the key metrics you would be working with with EaseMyTrip?
I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Basic to Advanced level of SQL
- Q2. Discussed 1 -2 Business Cases studies
Basic questions based on Sql
Interview Preparation Tips
I applied via Job Portal and was interviewed in Jun 2023. There were 3 interview rounds.
Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.
(2 Questions)
- Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
- Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
- Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
Selected
I applied via Company Website and was interviewed in Jul 2023. There were 5 interview rounds.
A test designed to determine a person's ability in a particular skill or field of knowledge
A distance between a group of participants on a given subject.
A job or type of work that you are given to do
A detailed study of a person, group situation,ect overa period of time
Interview Preparation Tips
- Mainframes
NexGen Technologies Interview FAQs
Tell us how to improve this page.
NexGen Technologies Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
NexGen Technologies Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Software Engineer
128
salaries
|  ₹3 L/yr - ₹10 L/yr |
|
Software Developer
57
salaries
| ₹3.3 L/yr - ₹9.4 L/yr |
|
Softwaretest Engineer
51
salaries
| ₹3.8 L/yr - ₹7.5 L/yr |
|
Devops Engineer
47
salaries
| ₹4 L/yr - ₹8 L/yr |
|
Test Engineer
26
salaries
| ₹4 L/yr - ₹7.2 L/yr |
TCS
Wipro
Infosys
HCLTech
- Home >
- Interviews >
- NexGen Technologies Interview Questions >
- NexGen Technologies Data Analyst Interview Questions
