AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Data Unveil Interview Questions and Answers
Data Unveil Interview Experiences
6 interviews found
Anonymous
Selected
I applied via LinkedIn and was interviewed in May 2024.Ā There were 2 interview rounds.
(1 Question)
- Q1. Basic Introduction and asked about aggregate functions in SQL
(2 Questions)
- Q1. Asked 3-4 sql questions based on case statement and window functions.
- Q2. Asked to explain the project on Which I have worked and technologies used like aws lambda,S3 ,redshift
Interview Preparation Tips
Data Analyst Interview Questions asked at other Companies
I applied via LinkedIn and was interviewed in Dec 2023.Ā There was 1 interview round.
(3 Questions)
- Q1. 1. Fetch last record of the column. 2. Dense rank vs rank 3. Fetch end of 5 character from the string of the column
- Ans.
The interview questions are related to SQL and data manipulation.
To fetch the last record of a column, you can use the ORDER BY clause with DESC keyword and LIMIT 1.
Dense rank and rank are both ranking functions in SQL, but dense rank assigns consecutive rank numbers to rows, while rank leaves gaps in the ranking sequence.
To fetch the end of 5 characters from a string column, you can use the RIGHT function in SQL.
- Q2. What type of data validation you performed.
- Ans.
I performed various types of data validation including format validation, completeness validation, and referential integrity validation.
Format validation: Ensuring that the data is in the correct format as per the defined specifications. For example, validating that a date field is in the format 'YYYY-MM-DD'.
Completeness validation: Checking if all the required fields are present and populated in the data. For example,...
- Q3. What customer do with data.
- Ans.
Customers use data for various purposes such as analysis, decision-making, reporting, and personalization.
Data is used for analysis to gain insights and identify patterns or trends.
Data helps in decision-making by providing information and supporting evidence.
Data is used for reporting to communicate information and track performance.
Data enables personalization by tailoring products or services based on customer prefe...
Interview Preparation Tips
If I get selected also, I will not be joining this company where basic technical knowledge is lacking.
Skills evaluated in this interview
ETL Tester Interview Questions asked at other Companies
(1 Question)
- Q1. Can you join in 15 days ?
Interview Preparation Tips
Data Analyst Interview Questions asked at other Companies
(1 Question)
- Q1. In context to experience
Assistant Manager- HR Interview Questions asked at other Companies
Data Unveil interview questions for popular designations
Selected
I was interviewed before Jan 2024.
(1 Question)
- Q1. The questions were about SQL
(1 Question)
- Q1. The questions were about SQL
Senior Database Developer Interview Questions asked at other Companies
Selected
I applied via Approached by Company and was interviewed before May 2023.Ā There was 1 interview round.
(1 Question)
- Q1. Sql basics and Joins
Interview Preparation Tips
Software Engineer Interview Questions asked at other Companies
Jobs at Data Unveil
Top trending discussions
Interview questions from similar companies
Interview Preparation Tips
Experience: I was fulfilling their criteria of 60% through out the academics.
Round: Test
Experience: Aptitude was easy. It contained basics of Quants & Logic . Verbal or English part was bit difficult and length. There was a sectional time and sectional cut off.
Round: Interview
Experience: There was only one interview. Both Technical and HR questions were asked in the same interview. Prepare puzzles from the book Puzzles to puzzle you by Shakuntala Devi. This book helped me a lot. Technical questions were very basic but nearly from every subject.
General Tips: BE CONFIDENT. Speak Confident in Interview even if you are not good with ur english.
Skills: English language, Communication Skills, Reasoning Abilities
College Name: Jawaharlal Nehru Engineering College Aurangabad
Interview QuestionnaireĀ
22 Questions
- Q1. What are the subjects you have command in?
- Q2. Tell me about your final year project?
- Q3. Tell me about the industrial training you had?
- Q4. How does an induction motor works?
- Q5. Why motor is rated in KW whereas Transformer and generator in KVA?
- Ans.
Motors are rated in KW because they consume power, while transformers and generators are rated in KVA because they produce power.
Motors convert electrical energy into mechanical energy, so they consume power and are rated in KW.
Transformers and generators produce electrical energy, so they are rated in KVA based on their apparent power.
KVA takes into account both the real power (KW) and the reactive power (KVAR) produc...
- Q6. What is the type of motor used in ceiling fans?
- Ans.
The type of motor used in ceiling fans is an induction motor.
Ceiling fans typically use single-phase induction motors.
These motors are designed to provide a constant speed and are efficient in converting electrical energy into mechanical energy.
The motor consists of a stator and a rotor, with the stator being the stationary part and the rotor being the rotating part.
The stator contains windings that create a rotating m...
- Q7. Hoe does a thermal power plant works?
- Ans.
A thermal power plant generates electricity by converting heat energy into mechanical energy.
Thermal power plants use fossil fuels or nuclear energy to heat water and produce steam.
The steam drives a turbine, which is connected to a generator that produces electricity.
The heat source can be coal, natural gas, oil, or nuclear reactions.
The steam is condensed back into water and recycled in a closed-loop system.
Thermal p...
- Q8. Write a program to make a GP
- Ans.
A program to generate a geometric progression (GP).
Take the first term, common ratio and number of terms as input.
Use a loop to calculate each term of the GP.
Print the generated GP as output.
- Q9. Write a program to print factorial using recursion
- Ans.
A program to print factorial using recursion
Define a function to calculate factorial recursively
Base case: if the number is 0 or 1, return 1
Recursive case: multiply the number with factorial of (number - 1)
Print the factorial of a given number
- Q10. Write the logic to reverse a string without using string fnctions
- Ans.
Logic to reverse a string without using string functions
Iterate through the string from the last character to the first
Create a new string and append each character to it in reverse order
- Q11. Tell me about yourself?
- Q12. What are your hobbies?
- Q13. Apart from your technical pat and studies what have you done in college?
- Q14. What do you prefer, ethics or values?
- Q15. Suppose you are working in office and somebody came and slapped you, what will you do?
- Q16. Tell me about yourself for 5 minutes
- Q17. What are your views about Mr. Narendra Modi as PM of India
- Q18. Any extra curricular activities you have participated in school or college
- Q19. What are your strengths?
- Q20. What are your weaknesses?
- Q21. Being an Electrical engineer why do you want to join an IT company
- Q22. What do you know about TCS?
Interview Preparation Tips
Experience: In email writing one question was given describing the situation and maximum word limit. It has the keywords given to be used. 1 question, 10 minutes.This section is generally used to check your verbal ability. Make sure to use all the keywords given and complete it within time, with no spelling mistakes of course. Missing a keyword or a spelling mistake could be your goodbye to qualified list.The second section had 30 questions of quantitative aptitude. Duration 70 mins. There are questions from various sections, such as Time and speed, Time and distance, Data interpretation,etc.There are 2-3 star marked questions which have more weight-age. There my also be a dummy question who doesn't have any matching answer. Make sure uh don't attempt these questions.26-27 questions is the cut-off for qualified list.But you have to do the email writing part correctly.
Tips: Practice email writing online from various websites such as technicalbaba.com, indiageeks.comPractice quantitative aptitude as it is a must in any interview you will face. you can use R.S.Agarwal or CAT material.
Duration: 90 minutes
Total Questions: 30 + 1
Round: Interview
Experience: Greeting the interviewer is a must. Be confident and enthusiastic. Have your resume properly ready.Ā Technical questions from your subject will be asked. Not a must that you should know any programming language like C, C++, JAVA.
Tips: Prepare 3-4 subjects of your core branch. Never try to flatter the interviewer. Be confident and answer the questions appropriately. Dont say directly " I DON'T KNOW". Atleast try even if you dont know the answer.
Round: Interview
Experience: There are certain questions which doesnt have direct answers. You have to be diplomatic about them. You should be able to see all the possible situation when a question like that is asked.
Round: Interview
Experience: The HR head may manipulate you, try to stress you, etc. Be calm and confident.Think before you speak. Prepare your answers before hand for general questions. Write your introduction on a paper and prepare it well so that you speak it confidently...
Tips: Be yourself. Be confident. Never argue with the interviewer.All the best
General Tips: Be presentable in the interview. Wear a watch. Show respect to the interviewer. Prepare 3-4 technical subjects well. Read last 15 days newspaper. Be confident when you speak. Improve your English if you are weak in it.
Skill Tips: ""
Skills: Verbal ability, Attitude, Technical knowledge, General knowledge
College Name: IMS ENGINEERING COLLEGE, GHAZIABAD
Motivation: TCS is a semi government company with a decent package and high job security.
Skills evaluated in this interview
Interview QuestionnaireĀ
7 Questions
- Q1. Say something about yourself?
- Q2. Asked on college project
- Q3. Which programming language do you know?
- Ans.
I know multiple programming languages including Java, Python, and C++.
Proficient in Java with experience in developing web applications using Spring framework
Familiar with Python for data analysis and machine learning
Experience in C++ for developing high-performance applications
Also familiar with HTML, CSS, and JavaScript for front-end development
- Q4. What is class, encapsulation and other feature of OOP?
- Ans.
Class is a blueprint for creating objects, encapsulation is the process of hiding data and methods within a class.
Class is a template or blueprint that defines the properties and behaviors of an object.
Encapsulation is the process of bundling data and methods together within a class, hiding the internal details from the outside world.
Other features of OOP include inheritance, polymorphism, and abstraction.
Inheritance a...
- Q5. Write a program to find the sum of the squares of each term of Fibonacci series
- Ans.
Program to find the sum of squares of each term of Fibonacci series
Generate Fibonacci series using loop or recursion
Calculate square of each term
Add all squares to get the sum
- Q6. What can I do for you?
- Q7. Why would you like to join Cognizant?
- Ans.
I would like to join Cognizant because of its reputation as a leading global technology and consulting company.
Cognizant has a strong presence in the industry and is known for its innovative solutions.
I am impressed by Cognizant's commitment to digital transformation and its ability to deliver value to clients.
The company offers excellent career growth opportunities and a supportive work environment.
Cognizant's diverse...
Interview Preparation Tips
Experience: Questions were simple but demanded faster solving ability especially the Quantitative ability section.
Tips: Solve every bit of R.S.Aggarwal for Aptitude problems. www.indiabix.com is a good site to solve questions from all the sections.
Duration: 90 minutes
Round: Interview
Experience: Started with self description to explaining what projects I was involved in. Talked about my role in the project. Then answered questions from C++ programming language and then wrote the program that the interviewer gave me to do.
Tips: Be Confident. Have the problem solving & "Yes I can Do" attitude. Go with a open mind. Listen to the interviewer carefully. Do not stammer. Keep yourself calm and cool. Be honest.
Round: Interview
Experience: Faced normal questions
Tips: Be confident & keep smiling. Keep track of your body language. Be fluent in speaking English.
General Tips: Be confident and a "can do" attitude will help you grab the job.
Skill Tips: """"
Skills: Communication Skill, Proficiency in English, Basic Computer Progamming Knowledge, Learning ability, Aptitude
College Name: IIT Madras
Skills evaluated in this interview
Interview Preparation Tips
Experience: CGPA + resume + online test - based shortlisting
Round: Test
Experience: Online Test:Quant, DI, verbal, and coding45 minutes coding + 15 minutes verbal + 30 minutes quant
Tips: Time constraint will be the major problem. CAT preparation would sufficeBrush up your coding skills- concentrate in either C or C++ or whichever language you're comfortable withE.g.: The coding question- Write a function to find if a number is palindromeBrush up through basic data structuresGraph theory and few sorting algorithms
Duration: 90 minutes
Round: Interview
Experience: (2 interviews, 20 minutes each)Resume- basedCoding skills and the approach towards the problem will also be tested
Tips: Be thorough with the work done in your internships and projects. Be ready to answer why you are interested in the company.Maintain your confidence level in the interviews. They also look for good communication skills, and even leadership, which is evident from the way you conduct yourself through the interview.Practice quant questions, prepare answers for all the basic HR questions.Coding, go through sorting algorithms, FOR, Graph theory.Digital IC design is very important courses. You should be through with this courses if you are interested in digital profile.
College Name: IIT Madras
Data Unveil Interview FAQs
Tell us how to improve this page.
Data Unveil Interviews By Designations
Interview Questions for Popular Designations
Data Unveil Interview Process
based on 7 interviews
Interview experience
Interview Questions from Similar Companies
Data Unveil Reviews and Ratings
based on 20 reviews
Rating in categories
6-10 Yrs
Not Disclosed
|
Operations Analyst
7
salaries
|  ā¹4 L/yr - ā¹7.5 L/yr |
|
Data Analyst
4
salaries
| ā¹5 L/yr - ā¹11 L/yr |
|
Senior Business Analyst
4
salaries
| ā¹14 L/yr - ā¹18 L/yr |
|
IT Operations Analyst
3
salaries
| ā¹3 L/yr - ā¹4.6 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- Data Unveil Interview Questions
