DataMetica Data Analyst Interview Questions and Answers

Done in notepad. Data analysis fundamental and coding fundamentals were covered.

Q1. Piviot tables, vlookups excel case study.
Add your answer
Q2. Window fucntions SQL question and pandas data manupilation.
Add your answer

Normal Aptitude Test

Python or SQL coding round

Reasoning, logical , English

Q1. What are the functions in Mysql
Ans. 
MySQL functions are built-in functions that can be used to perform various operations on data stored in a MySQL database.
• MySQL functions can be used for mathematical calculations, string manipulation, date and time operations, and more.

• Examples of MySQL functions include CONCAT() for concatenating strings, AVG() for calculating the average value of a column, and NOW() for retrieving the current date and time.

• MySQL func...read more
Answered by AI
Add your answer

Q1. What about you?
Add your answer

2 coding questions in 45 min

Q1. Basics of java and frameworks
Add your answer
Q2. Basics of SQL and types of queries
Add your answer

30 min of logical reasoning and basic aptitude

30 min of GD over a general topic to check your communication skills

Q1. Why do you want to join our company
Add your answer
Q2. Why should we hire you
Add your answer

Questions were tough- DP Array

Different GPOs policy were discussed

Q1. Questions were regarding Behavior
Add your answer

Basic coding questions.

Q1. General stuff like do you know about the company
Add your answer
Q2. Future goals, where do you see yourself in 5 years.
Add your answer