Upload Button Icon Add office photos

Filter interviews by

Telstra Data Engineering Analyst Interview Questions and Answers

Updated 18 Nov 2024

Telstra Data Engineering Analyst Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Asked few Python questions

I applied via Referral and was interviewed in Apr 2022. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basics of Python SQL Cloud and new technologies like Spark would be an advantage Panel was quite interactive and supportive
  • Q2. Code based on arrays and lists sorting
  • Ans. 

    Sorting arrays and lists of strings

    • Use built-in sorting functions like sorted() or sort()

    • Specify the key parameter to sort by a specific element in the strings

    • Use reverse=True to sort in descending order

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Much into the project that I have worked upon, data structures, code based on arrays and time complexity

Interview Preparation Tips

Topics to prepare for Telstra Data Engineering Analyst interview:
  • Python
  • MySQL
  • Spark
  • AWS
  • Azure
Interview preparation tips for other job seekers - Be calm, confident and don't blabber just say what you knows only ... Be prepared.. prepare basics of python SQL spark cloud.. coding on time complexities

Skills evaluated in this interview

Data Engineering Analyst Interview Questions Asked at Other Companies

asked in Accenture
Q1. Product Of Array Except Self Problem Statement You are provided w ... read more
asked in Accenture
Q2. Maximum Subarray Sum Problem Statement Given an array ARR consist ... read more
asked in Accenture
Q3. You have to 200 Petabyte of data to load how you will decide the ... read more
asked in Accenture
Q4. Suppose you adding a block and that takes much time you have to d ... read more
asked in Accenture
Q5. what is Broadcasting are you using Broadcasting and what is the l ... read more

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Question on spring, springboot and java

Interview Preparation Tips

Interview preparation tips for other job seekers - good company to grow now.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Sep 2024, where I was asked the following questions.

  • Q1. What is your roles and responsibilities ?
  • Ans. 

    As a Business Analyst, I bridge the gap between stakeholders and IT, ensuring project requirements are met effectively.

    • Gather and analyze business requirements from stakeholders, e.g., conducting interviews and workshops.

    • Create detailed documentation, such as business requirement documents (BRDs) and functional specifications.

    • Facilitate communication between technical teams and business units to ensure alignment on pro...

  • Answered by AI
  • Q2. How do you manage stakeholders ?
  • Ans. 

    Effective stakeholder management involves communication, understanding needs, and building relationships for project success.

    • Identify stakeholders: Map out all stakeholders involved in the project, such as clients, team members, and executives.

    • Understand their needs: Conduct interviews or surveys to gather insights on their expectations and concerns.

    • Regular communication: Schedule regular updates through meetings or re...

  • Answered by AI
  • Q3. What is your techniques for requirement gathering?
  • Ans. 

    Effective requirement gathering involves various techniques to ensure comprehensive understanding of stakeholder needs.

    • Interviews: Conduct one-on-one sessions with stakeholders to gather detailed insights. For example, interviewing doctors to understand patient management systems.

    • Surveys and Questionnaires: Distribute structured forms to collect quantitative data from a larger audience. For instance, using surveys to a...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. About yourself and roles
  • Q2. Network domain check skills
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.

    • Experienced in gathering and analyzing business requirements

    • Skilled in creating detailed reports and presentations

    • Proficient in using data visualization tools like Tableau

    • Strong communication and interpersonal skills

    • Certified in Agile methodologies

  • Answered by AI
  • Q2. Us healthcare provider patient
Round 2 - Technical 

(2 Questions)

  • Q1. Scenariop based question us
  • Q2. Sdlc lifecycle and phases
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Sql question related to windows function
  • 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
  • Q3. Python question related to file system, regex

Interview Preparation Tips

Interview preparation tips for other job seekers - First round was good, interviewer was supportive. They scheduled the second tech round after a week for the next week and then no one joined the call, furthermore the HR stopped answering my call, email or text and ghosted me.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • 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...

  • Answered by AI
  • 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

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn about SQL and GCP

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Questions on spark and kafka
Round 3 - HR 

(1 Question)

  • Q1. How soon you will join
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Coding Test 

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Round 2 - Technical 

(4 Questions)

  • Q1. Clustering and partition difference in data warehousing solutions
  • Ans. 

    Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.

    • Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

    • Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

    • Clustering is often used for data a...

  • Answered by AI
  • Q2. What are the different approaches to Optimising SQL
  • Ans. 

    Different approaches to optimizing SQL include indexing, query optimization, and database design.

    • Use indexing to improve query performance

    • Optimize queries by avoiding unnecessary joins and using appropriate functions

    • Design the database schema efficiently to reduce redundancy and improve data retrieval speed

  • Answered by AI
  • Q3. Spark and it’s architecture
  • Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
  • Ans. 

    To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.

    • Aggregate the data by customer and item purchased

    • Filter out transactions from February

    • Count the number of items bought by each customer

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - If it’s an entry level the basic knowledge plus in-depth understanding of the domine is more tha. Enough

Telstra Interview FAQs

How many rounds are there in Telstra Data Engineering Analyst interview?
Telstra interview process usually has 1-2 rounds. The most common rounds in the Telstra interview process are Technical and Coding Test.
How to prepare for Telstra Data Engineering Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Telstra. The most common topics and skills that interviewers at Telstra expect are Agile, Devops, Flex, Python and Continuous Integration.
What are the top questions asked in Telstra Data Engineering Analyst interview?

Some of the top questions asked at the Telstra Data Engineering Analyst interview -

  1. Code based on arrays and lists sort...read more
  2. Basics of Python SQL Cloud and new technologies like Spark would be an advantag...read more
  3. Much into the project that I have worked upon, data structures, code based on a...read more

Tell us how to improve this page.

Telstra Data Engineering Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Jio Interview Questions
4.0
 • 1.8k Interviews
Vodafone Idea Interview Questions
4.0
 • 557 Interviews
Ericsson Interview Questions
4.1
 • 411 Interviews
Nokia Interview Questions
4.1
 • 267 Interviews
BT Group Interview Questions
3.9
 • 181 Interviews
Verizon Interview Questions
4.1
 • 110 Interviews
AT&T Interview Questions
4.1
 • 53 Interviews
Ciena Interview Questions
4.2
 • 39 Interviews
CommScope Interview Questions
3.8
 • 34 Interviews
View all
Telstra Data Engineering Analyst Salary
based on 9 salaries
₹13.1 L/yr - ₹27 L/yr
169% more than the average Data Engineering Analyst Salary in India
View more details
Software Engineer
174 salaries
unlock blur

₹9.6 L/yr - ₹27.2 L/yr

Senior Software Engineer
122 salaries
unlock blur

₹19 L/yr - ₹49.5 L/yr

Associate Software Engineer
53 salaries
unlock blur

₹7 L/yr - ₹10.1 L/yr

Software Developer
48 salaries
unlock blur

₹7.9 L/yr - ₹22.5 L/yr

Scrum Master
48 salaries
unlock blur

₹14.6 L/yr - ₹50.8 L/yr

Explore more salaries
Compare Telstra with

Jio

4.0
Compare

Vodafone Idea

4.0
Compare

Ericsson

4.1
Compare

Nokia

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview