Telstra Interview Questions, Process, and Tips

Leetcode easy and medium questions. It was easy to clear

Q1. Dry run bubble and insertion sort
Add your answer
Q2. One SQL query easy level
Add your answer

Q1. Discussion about projects
Add your answer
Q2. Do you have any questions
Add your answer

Python and SQL Questions (Easy to Medium)

Q1. Project Work Discussion
Add your answer
Q2. SQL Coding (Can be with an online compiler)
Add your answer
Q3. Python Coding (Can be with an online compiler)
Add your answer
Q4. PySpark Coding (All the coding answers have to be submitted to the interviewer)
Add your answer
Q5. PySpark Joins, and Databricks, and Vanilla Spark difference
Add your answer

Q1. SQL 2 Questions (Easy to Medium) (Maybe on the compiler)
Add your answer
Q2. Python (Easy) (Maybe on compiler)
Add your answer
Q3. Scenario-based questions on the project
Add your answer

Easy-medium level and it included two coding questions and some technical questions

Q1. How are structures and classes stored?
Ans. 
Structures and classes are stored in memory as a combination of data members and member functions.
• Structures and classes are stored in memory as a combination of data members and member functions.

• Data members of a structure or class are stored in contiguous memory locations.

• Member functions of a class are stored separately in memory and are shared among all instances of the class.

• Pointers to member functions are used t...read more
Answered by AI
Add your answer
Q2. What is final and finalize?
Ans. 
final is a keyword in Java used to restrict inheritance, overriding, and modification. finalize is a method used for cleanup operations before an object is garbage collected.
• final keyword is used to declare constants, prevent inheritance by marking a class as final, and prevent method overriding by marking a method as final

• finalize method is called by the garbage collector before an object is destroyed

• Example: final in...read more
Answered by AI
Add your answer

Based on your job description coding questions will be asked in different categories. If you are able to manage time. It is easy to crack

Q1. Optimization techniques in pyspark
Ans. 
Optimization techniques in pyspark involve partitioning, caching, and using efficient transformations.
• Partitioning data to distribute workload evenly

• Caching frequently accessed data to avoid recomputation

• Using efficient transformations like map, filter, and reduce

• Avoiding unnecessary shuffling of data
Answered by AI
Add your answer
Q2. Few coding questions. Find the first unique character in string
Add your answer

Q1. It is bit difficult for me. Mention your work experience
Add your answer