AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Technumen
Compare
Filter interviews by
Technumen Data Analyst Interview Questions and Answers
Technumen Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consultant and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Overall experience?
- Ans.
I have 5 years of experience as a Data Analyst.
5 years of experience as a Data Analyst
Proficient in data analysis tools such as SQL, Excel, and Python
Experience in data visualization and reporting using Tableau
Strong analytical and problem-solving skills
Ability to interpret and communicate complex data findings
Experience in working with large datasets and performing data cleaning and manipulation
Collaborated with cross...
- Q2. What is a Composite Key?
- Ans.
A composite key is a combination of two or more columns that uniquely identifies a record in a database table.
A composite key is used when a single column cannot uniquely identify a record.
It is created by combining two or more columns that have unique values.
It is commonly used in many-to-many relationships.
Example: A table that stores orders may use a composite key of order number and customer ID.
Example: A table tha...
Interview Preparation Tips
I don't know what to call it a Technical/timepass interview, but it was ridiculous. Finally feedback, "not selected". Either it was not the right panel for the interview or they have someone internally they prefer to hire. Anyways it was very unprofessional to rush candidates to attend an interview and they do not interview properly, no professional ethics.
The big question to management, how do you qualify a person to conduct an interview without any relevant or proper experience but you need a person well qualified and experienced just to turn him/her down?
If I were to give the interviewer my rating it would be an astounding -2/5.
Top trending discussions
Interview questions from similar companies
Interview Preparation Tips
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
Selected
I applied via Campus Placement and was interviewed before Nov 2023. There were 5 interview rounds.
2 coding questions in 45 min
(2 Questions)
- Q1. Basics of java and frameworks
- Q2. Basics of SQL and types of queries
30 min of logical reasoning and basic aptitude
30 min of GD over a general topic to check your communication skills
(2 Questions)
- Q1. Why do you want to join our company
- Q2. Why should we hire you
Selected
I applied via Company Website and was interviewed before Feb 2023. There were 3 interview rounds.
Online platform,
SQL coding
(1 Question)
- Q1. In a one-on-one technical round, all they will ask around your resume
(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.
Most questions were based on profit/loss and coding Questions are simple
Gave us topic on how education is important in our life
(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
- SQL
Selected
I applied via Campus Placement and was interviewed in Jul 2022. There were 7 interview rounds.
It comprised basic verbal,quants and logical questions of average difficulty.
This is an easy round to get through if you have a strong command of the English language and are able to speak confidently.Very general topics asked.
(4 Questions)
- Q1. Basic Machine Learning questions ( as I mentioned it in my resume)
- Q2. Testing how you would be able to apply those concepts to real world scenarios
- Q3. Generic logical puzzles
- Q4. Basic python programs (3 to 4 questions)
(2 Questions)
- Q1. Asked more about projects mentioned in resume.
- Q2. Tested basic business sense and awareness.
A game round comprising logical puzzles and games.
(3 Questions)
- Q1. Tell me about yourself ( standard intro)
- Ans.
I am a data analyst with a strong background in statistics and programming.
Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau
Experienced in analyzing large datasets and identifying trends and patterns
Skilled in creating reports and presentations to communicate data-driven insights
Strong problem-solving and critical thinking skills
Ability to work collaboratively in cross-funct...
- Q2. Asked more about the roles of teammates in group projects listed in resume.
- Q3. Asked more about myself and whether I could manage the commute to their office
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Jul 2023. There were 5 interview rounds.
Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question
Easy
50% went to next round
(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...
- 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
(1 Question)
- Q1. Common HR questions
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.
It was a 3 hour test with 144 questions
(1 Question)
- Q1. Why did you select this company?
Selected
I applied via Campus Placement
It was easy to approach!
Discussions about common topics like boon or bane to society
Asked about the scenarios
(1 Question)
- Q1. Technical round related to skills and resume
(1 Question)
- Q1. Discussions regarding work culture and compensations
I applied via LinkedIn and was interviewed before Oct 2021. There were 3 interview rounds.
8 python coding
With 2 aptitude
Game based assessment.
More than 8 games need to play
(2 Questions)
- Q1. Questions from python and also from SQL. SQL is must to place LatentView. Some projects related questions
- Q2. How many joins are in SQL what is lamda function in python Difference between tuples and list
- Ans.
Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.
There are four types of joins in SQL: inner join, left join, right join, and full outer join.
Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.
Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...
Interview Preparation Tips
Skills evaluated in this interview
Tell us how to improve this page.
Technumen Interviews By Designations
- Technumen Software Developer Interview Questions
- Technumen Java Developer Interview Questions
- Technumen Technical Lead Interview Questions
- Technumen Data Analyst Interview Questions
- Technumen Senior Software Engineer Interview Questions
- Technumen Front end Developer Interview Questions
- Technumen Guidewire Developer Interview Questions
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
|
Senior Consultant
47
salaries
|  ₹15 L/yr - ₹32 L/yr |
|
Senior Software Engineer
37
salaries
| ₹10 L/yr - ₹26.3 L/yr |
|
Associate Consultant
22
salaries
| ₹14 L/yr - ₹26 L/yr |
|
Consultant
22
salaries
| ₹15 L/yr - ₹31 L/yr |
|
Software Engineer
12
salaries
| ₹6 L/yr - ₹19 L/yr |
Tekwissen
Softenger
XcelServ Solutions
Damco Solutions
- Home >
- Interviews >
- Technumen Interview Questions >
- Technumen Data Analyst Interview Questions
