Telstra Data Analyst Interview Questions and Answers

Q1. Can you automate dashobaord on excel on daily routine, Do you know proper formulation of dashboard.
Add your answer
Q2. How many years experience do you have in sql. Please provide solution for some sql technical questions. Or can you properly provide adhoc requirement by urgently analysing on compony database. There was s...read more
Add your answer

Q1. It was an easy situational ques
Add your answer
Q2. It was an easy situational questiokn
Add your answer

Q1. Same as the first one
Add your answer
Q2. Same as the previous round
Add your answer

Q1. Current roles and responsibilities, Few queries to write, few questions related to DWH and what type of role you have done in past etc
Add your answer

Q1. Managerial round mostly questions like what challenges did you face, how did you overcome on that, what was the major success / appreciation you got
Add your answer

Q1. SQL joins and simple query
Add your answer
Q2. Phython basics and simle data fram
Add your answer
Q3. Hr round only formality
Add your answer

Q1. Sql question related to windows function
Add your answer
Q2. Unix basics - find a word in a set of files
Ans. 
Using Unix command 'grep' to find a word in a set of files
• Use 'grep' command followed by the word you want to search for and the file(s) you want to search in

• Add the '-r' flag to search recursively in all files in a directory

• Use '-i' flag for case-insensitive search

• Example: grep 'hello' file.txt

• Example: grep -r 'error' /path/to/directory

• Example: grep -i 'apple' file1.txt file2.txt
Answered by AI
Add your answer
Q3. Python question related to file system, regex
Add your answer

Q1. What is the difference between start schema and snowflake schema
Ans. 
Star schema is a denormalized schema with a single fact table and multiple dimension tables, while snowflake schema is a normalized schema with multiple dimension tables normalized into sub-dimension tables.
• Star schema has a single fact table surrounded by multiple dimension tables, while snowflake schema has dimension tables normalized into sub-dimension tables.

• In star schema, dimensions are denormalized, while in sno...read more
Answered by AI
Add your answer
Q2. How do you load data into bigquery using dataflow
Ans. 
Data can be loaded into BigQuery using Dataflow by creating a pipeline in Dataflow that reads data from a source and writes it to BigQuery.
• Create a Dataflow pipeline using Apache Beam SDK

• Read data from a source such as Cloud Storage or Pub/Sub

• Transform the data as needed using Apache Beam transformations

• Write the transformed data to BigQuery using BigQueryIO.write()
Answered by AI
Add your answer

Python and SQL coding test along with basic data science questions
Python was on basic syntax. SQL was on medium difficulty

Q1. Correlation vs causation Central limit theorem Support Vector Machines Confusion matrix Basics of Deep Learning - activation function, optimizers and initialisation techniques Z score, P value Differenc...read more
Add your answer

Q1. Questions about my background My hobbies and interests
Add your answer

Q1. Questions were based on DSA and C
Add your answer
Q2. It was basically a coding round with simple logic
Add your answer