Tiger Analytics Big Data Engineer Interview Questions and Answers

General maths and english Q was there

Sql codes were there one big one small

Q1. Asked me about python and sql with some hands on basic Q
Add your answer

Q1. Asked me some advance sql Q and python ds as well
Add your answer

Q1. Asked me about company and discussed about the role
Add your answer

Q1. If u are trying for bigdata then Py spark will be the interview question which they will ask
Add your answer

Q1. Pypark,Hadoop, Hive
Add your answer

Q1. How can you optmize dags?
Ans. 
Optimizing dags involves reducing unnecessary tasks, parallelizing tasks, and optimizing resource allocation.
• Identify and remove unnecessary tasks to streamline the workflow.

• Parallelize tasks to reduce overall execution time.

• Optimize resource allocation by scaling up or down based on task requirements.

• Use caching and memoization techniques to avoid redundant computations.

• Implement data partitioning and indexing for eff
Answered by AI
Add your answer
Q2. How can we handle unacknowledged messages in pubsub?
Ans. 
Unacknowledged messages in pubsub can be handled by implementing retries, dead letter queues, and monitoring mechanisms.
• Implement retries for unacknowledged messages to be redelivered.

• Use dead letter queues to store messages that repeatedly fail to be processed.

• Set up monitoring mechanisms to track unacknowledged messages and identify potential issues.
Answered by AI
Add your answer

Hackerearth, advanced sql queries on joins, string literals, sql conceptual MCQ

Q1. Questions on joins
Add your answer
Q2. Unions related question
Add your answer
Q3. Intersection related question
Add your answer
Q4. Sunstrong related
Add your answer

Q1. Find columns from a table where data type is timestamp.
Ans. 
Use SQL query to find columns with timestamp data type in a table.
• Use a SQL query like 'SHOW COLUMNS FROM table_name WHERE Type = 'timestamp''

• Alternatively, query the information_schema.columns table for column data types

• Check for variations of timestamp data types like datetime, timestamp, etc.
Answered by AI
Add your answer
Q2. Alter column name
Add your answer
Q3. Delete column from a table
Ans. 
To delete a column from a table, use the ALTER TABLE command.
• Use the ALTER TABLE command followed by DROP COLUMN to delete a column from a table.

• Specify the name of the column you want to delete after the DROP COLUMN keyword.

• Make sure to carefully consider the impact of deleting a column on the data and any dependent objects.
Answered by AI
Add your answer
Q4. Difference between drop, truncate and delete
Ans. 
Drop removes a table from the database, truncate removes all rows from a table, and delete removes specific rows from a table.
• DROP: Removes the entire table structure and data from the database.

• TRUNCATE: Removes all rows from a table but keeps the table structure.

• DELETE: Removes specific rows from a table based on a condition.

• Example: DROP TABLE table_name;

• Example: TRUNCATE TABLE table_name;

• Example: DELETE FROM table_n
Answered by AI
Add your answer
Q5. Difference between top and limit.
Ans. 
Top is used to select the first few rows from a dataset, while limit is used to restrict the number of rows returned in a query.
• Top is commonly used in SQL Server, while limit is commonly used in MySQL.

• Top is used with the SELECT statement in SQL Server to limit the number of rows returned, while limit is used in MySQL to restrict the number of rows returned.

• Example: SELECT TOP 5 * FROM table_name; (SQL Server) vs. SEL
Answered by AI
Add your answer
Q6. What is difference between count(*) and count(1)
Ans. 
count(*) counts all rows in a table, while count(1) counts the number of non-null values in a specific column.
• count(*) counts all rows in a table

• count(1) counts the number of non-null values in a specific column

• count(*) is generally used when you want to count all rows in a table, while count(1) is used when you want to count non-null values in a specific column
Answered by AI
Add your answer
Q7. FInd second index of "l" from a string "Hello". write a py code.
Ans. 
Find the second index of 'l' in the string 'Hello'.
• Use the find() method to find the first index of 'l'.

• Use the find() method again starting from the index after the first 'l' to find the second index.

• Handle cases where the first 'l' is not found or there is no second 'l'.
Answered by AI
Add your answer

Q1. Bigquery and GCP
Add your answer

Q1. More of project and attitute
Add your answer

Conceptual round with some pyspark coding

Q1. Python coding three questions and big data concepts
Add your answer

Q1. Conceptual with manager and prior experience related
Add your answer