Tiger Analytics Interview Questions, Process, and Tips

Q1. SQL database questions
Add your answer

Q1. About Selenium Xpath
Add your answer
Q2. About Pytest fixtures
Add your answer
Q3. SQL distinct and count
Add your answer

I was asked 2 coding problems in pyspark, after that a discussion round followed.

Q1. Explain databricks dlt, and when will you use batch vs streaming?
Ans. 
Databricks DLT is a unified data management platform for batch and streaming processing.
• Databricks DLT (Delta Lake Table) is a storage layer that brings ACID transactions to Apache Spark and big data workloads.

• Batch processing is used when data is collected over a period of time and processed in large chunks, while streaming processing is used for real-time data processing.

• Use batch processing for historical data analy...read more
Answered by AI
Add your answer
Q2. What is the difference between deltalake and delta warehouse
Ans. 
Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads, while Delta Warehouse is a cloud-based data warehouse service.
• Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads.

• Delta Warehouse is a cloud-based data warehouse service that provides scalable storage and analytics capabilities.

• Delta Lake is more fo...read more
Answered by AI
Add your answer

Q1. They asked about my experience, told about jd and tried to see if am suitable for this role
Add your answer

Q1. Asked about my experience, in details about Google analytics Adobe analytics, sql tableau and python
Add your answer

It was with the client. Tested if I am will be good for the role

Q1. Salary expectations and when I can join
Ans. 
I am open to discussing salary based on the market rate and my experience. I can join within a month.
• Discussing salary based on market rate and experience

• Open to negotiation

• Available to join within a month
Answered by AI
Add your answer

Simple dsa and aptitude question

Q1. Easy Dsa question
Add your answer
Q2. Simple 2 sql quesries based on limit
Add your answer

Q1. What is random forest
Ans. 
Random forest is an ensemble learning method used for classification and regression tasks.
• Random forest is a collection of decision trees that are trained on random subsets of the data.

• Each tree in the random forest independently predicts the target variable, and the final prediction is made by averaging the predictions of all trees.

• Random forest is robust to overfitting and noisy data, and can handle large datasets wi...read more
Answered by AI
Add your answer
Q2. Explain lasso in feature selection
Ans. 
Lasso is a feature selection technique that penalizes the absolute size of the regression coefficients.
• Lasso stands for Least Absolute Shrinkage and Selection Operator

• It adds a penalty term to the regression equation, forcing some coefficients to be exactly zero

• Helps in selecting the most important features and reducing overfitting

• Useful when dealing with high-dimensional data

• Example: In a dataset with multiple feature...read more
Answered by AI
Add your answer