Tessolve Semiconductor Senior Data Analyst Interview Questions and Answers

Q1. Previous experience
Add your answer

Q1. Functions in SQL Linear Regression
Ans. 
Functions in SQL are used to perform specific tasks on the data stored in a database.
• SQL functions can be used to manipulate data, perform calculations, and retrieve specific information from a database.

• Common SQL functions include aggregate functions (e.g., SUM, AVG), string functions (e.g., CONCAT, SUBSTRING), and date functions (e.g., DATEPART, GETDATE).

• Functions can be used in SELECT statements, WHERE clauses, and ...read more
Answered by AI
Add your answer
Q2. Machine Learning
Add your answer
Q3. Transformations in Informatica
Ans. 
Transformations in Informatica are used to manipulate and modify data during the ETL process.
• Transformations are used to filter, aggregate, join, and sort data.

• Examples of transformations include Filter, Aggregator, Joiner, and Sorter.

• Transformations can be used to perform calculations, data cleansing, and data validation.

• They can also be used to create new columns, merge data from multiple sources, and split data into
Answered by AI
Add your answer
Q4. Power BI Basic questions
Add your answer

Q1. Shuffle and merge in Haddop
Ans. 
Shuffle and merge are key processes in Hadoop for distributing data across nodes and combining results.
• Shuffle is the process of transferring data from mappers to reducers in Hadoop.

• Merge is the process of combining the output from multiple reducers into a single result.

• Shuffle and merge are essential for parallel processing and efficient data analysis in Hadoop.

• Example: In a word count job, shuffle will group words by...read more
Answered by AI
Add your answer

Q1. Why this company?
Add your answer

It's was divided into 4 stage:
1. Pseudocode which contains small computer coding
2. English verbal which contains questions on grammar
3. Aptitude test (game based)
4. 2 codes

Q1. 1. Introduce yourself?
Add your answer
Q2. 2. As you are Mechanical Engineer why are you interested for these job profile?
Add your answer
Q3. 3. Explain Oops Concepts?
Ans. 
Oops Concepts are fundamental principles of Object-Oriented Programming.
• Encapsulation - binding data and functions together

• Inheritance - acquiring properties and behavior of parent class

• Polymorphism - ability of objects to take multiple forms

• Abstraction - hiding implementation details and showing only necessary information
Answered by AI
Add your answer
Q4. 4. Ready to relocate?
Add your answer

Q1. Basic verbal ability test : easy level
Add your answer

Pseudocode test: basic programming skills was tested in this round

Q1. Gaming based test: you can practice from youtube
Add your answer

Q1. Technical interview : questions were based on your favourite subjects and topics from job description
Add your answer

Q1. Tell me yourself
Ans. 
Experienced data analyst with a background in statistics and programming.
• I have a Bachelor's degree in Statistics and a Master's degree in Data Science.

• I am proficient in programming languages such as Python, R, and SQL.

• I have experience working with large datasets and conducting statistical analysis.

• I have strong problem-solving skills and attention to detail.

• I have worked on projects involving data visualization and
Answered by AI
Add your answer
Q2. Are you Relocate
Add your answer