Megha Engineering & Infrastructures Data Analyst Interview Questions and Answers

General apti (maths) + english

Q1. Introduce yourself
Ans. 
I am a data analyst with 5 years of experience in analyzing and interpreting complex data sets.
• Experienced in using statistical tools such as R and Python

• Proficient in data visualization techniques using Tableau

• Skilled in identifying trends and patterns in data to drive business decisions
Answered by AI
Add your answer
Q2. You had 100% marks in 10th but only 65% in 12th. why what happened
Ans. 
Different academic environments and personal growth led to a change in performance.
• Transition from 10th to 12th grade involved different subjects and teaching styles

• Increased workload and higher difficulty level in 12th grade may have impacted performance

• Personal factors such as motivation, study habits, or external circumstances could have played a role

• Focus on extracurricular activities or other interests may have di
Answered by AI
Add your answer

Q1. What are joins and its types?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL ...read more
Answered by AI
Add your answer
Q2. What are aggregate functions?
Ans. 
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
• Aggregate functions are used to perform operations on a group of rows and return a single result.

• Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• For example, SUM function calculates the total of a column, AVG calculates the average, COUNT counts the number of rows, MIN finds the minimu
Answered by AI
Add your answer

Q1. Coding questions in python eda part
Add your answer

Q1. Where do u see in next 5 years
Add your answer

30 questions and time was approx. 45 min to 60 min

There were some basic as well as some high level questions

Q1. Discussion about Past experience and projects. Relaxed atmosphere. Normal interview
Add your answer

Basic Business Aptitude

GD on any topic among a group of 5-10.

Q1. Have you ever worked in Siebel CRM or SAP?
Ans. 
Yes, I have worked in both Siebel CRM and SAP.
• I have experience working with Siebel CRM in a previous role, where I managed customer data and interactions.

• I have also worked with SAP in a different project, where I analyzed business processes and implemented solutions.

• My experience with both systems has given me a strong understanding of CRM and ERP functionalities.
Answered by AI
Add your answer

Q1. Current Experience
Add your answer
Q2. Location Preference
Add your answer

There was 10 member in a group and a common topic was given to all of us and the time limit was 10 min

Q1. A Detailed interview was held with experts for around 45 min and they ask about background test , Academics knowledge, Internship and Common knowledge
Add your answer

Q1. Basic details like what about yourself, knowledge about job profile, job roles and responsibility, and about company profile
Add your answer