Mastech InfoTrellis Big Data Specialist Interview Questions and Answers

Q1. Tell me about yourself?
Add your answer
Q2. Tell me about your recent Project in Detail?
Add your answer
Q3. What is the Diff between Parameters and Hyper Parameters?
Add your answer
Q4. Can we use Logistic Regression for Multi Class Classification?
Add your answer
Q5. What will happen if we will increase the value of K in KNN?
Add your answer
Q6. If you have 50 GB of training data and you want to train your Neural Network on you Local 2 GB RAM, what will you do?
Add your answer
Q7. What is imbalanced Data?
Add your answer

Q1. Bias variance trade off
Add your answer
Q2. What is AB testing
Ans. 
AB testing is a method used to compare two versions of a webpage or app to determine which one performs better.
• AB testing involves creating two versions (A and B) of a webpage or app with one differing element

• Users are randomly assigned to either version A or B to measure performance metrics

• The version that performs better in terms of the desired outcome is selected for implementation

• Example: Testing two different call...read more
Answered by AI
Add your answer
Q3. Basic traditional ML question about ML metrics, bagging boosting etc.
Add your answer

It was a classification problem

Q1. Questions about assignment
Add your answer
Q2. Questions from resume.
Add your answer
Q3. Questions based on probability, statistics and loss functions
Add your answer

Coding round had one SQL and one Python question. And some mcqs around python and math

Q1. It was on store and products querying with SQL
Add your answer
Q2. Same questions were asked in Python
Add your answer

Q1. It was a techno-managerial round with some guesstimates and about my recent projects
Add your answer

Q1. Java questions and data engineering
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Well designed to test the aptitude competence of the candidate.

Q1. Explanations for the answers given to the aptitude questions.
Add your answer
Q2. Questions from python.
Add your answer

Object oriented programming, logical technical

Q1. What is joins , ddl,dml,ddl,TCL command
Ans. 
Joins are used to combine rows from two or more tables based on a related column. DDL, DML, and TCL are SQL commands for data manipulation and transaction control.
• Joins are used in SQL to retrieve data from multiple tables based on a related column.

• DDL (Data Definition Language) commands are used to define the structure of database objects like tables, indexes, etc.

• DML (Data Manipulation Language) commands are used to ...read more
Answered by AI
Add your answer