Magna International IT Analyst Interview Questions and Answers

Q1. What is Etl
Ans. 
ETL stands for Extract, Transform, Load, a process for integrating and preparing data for analysis.
• Extract: Collecting data from various sources like databases, APIs, or flat files.

• Transform: Cleaning and converting data into a suitable format, e.g., changing date formats or aggregating data.

• Load: Storing the transformed data into a target database or data warehouse for analysis.

• Example: Extracting sales data from mult...read more
Answered by AI
Add your answer
Q2. What is data warehouse
Ans. 
A data warehouse is a centralized repository for storing and analyzing large volumes of structured and unstructured data.
• Integrates data from multiple sources, such as databases, CRM systems, and external data feeds.

• Supports business intelligence activities, including reporting, data mining, and analytics.

• Uses ETL (Extract, Transform, Load) processes to prepare data for analysis.

• Examples include Amazon Redshift, Google...read more
Answered by AI
Add your answer

Coding was fully based on python.
First they told me to on the laptop camera because it was a virtual interview and then they told me to share my screen
1. Starting from self introduction
2. Summarise my project in 2 minutes
3. Then he ask back to back 5-6 python.
questions and I have to write in vs
code ( on shared screen) ,I have to
write the code and then execute it.
They asked. few side questions like
from html and sql.
4. Total duration of interview is 30
minutes

Q1. These is based on communication, salary discussion, responsibilities and work culture.
Add your answer
Q2. 1. He asked about cap between degree and job 2. Strength and can I work under pressure. 3. How can I manage if I assigned more than 1 project at a time
Add your answer

Q1. About stability
Add your answer

Q1. Aptitude is about the projects
Add your answer

Q1. Regarding my current roles and responsibilities
Add your answer

Pictorial and graphical questions

Q1. Oops and coding questions along with Data structures
Add your answer

Leet code test DSA problem

Q1. Based on CV and SMPS based questions about design, component selection etc
Add your answer

Q1. Based on CV and power electronic design
Add your answer

Q1. HR is a kind of heavy negotiator.
Add your answer