Telstra Data Analyst Interview Questions and Answers

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
Add your answer
Q2. Us healthcare provider patient
Add your answer

Q1. Scenariop based question us
Ans. 
As a Business Analyst, I would assess requirements, analyze data, and propose solutions to improve business processes.
• Identify stakeholders and gather requirements through interviews and surveys.

• Analyze current business processes to identify inefficiencies, e.g., using process mapping.

• Develop data models to visualize relationships and trends, such as sales data analysis.

• Propose actionable solutions, like implementing a...read more
Answered by AI
Add your answer
Q2. Sdlc lifecycle and phases
Add your answer

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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer

Q1. Difference between open and Capex costs
Ans. 
Open costs are ongoing expenses, while Capex costs are one-time investments in assets.
• Open costs (Opex) include salaries, utilities, and maintenance expenses.

• Capex costs involve purchasing equipment, buildings, or technology.

• Opex is typically recurring and affects the income statement directly.

• Capex is capitalized and depreciated over time, impacting the balance sheet.

• Example of Opex: Monthly rent for office space.

• Exam...read more
Answered by AI
Add your answer
Q2. Microsoft excel and chat got based questions
Add your answer

Q1. Tell me about your self
Add your answer
Q2. Tell me some challenge which you have faced
Ans. 
I faced a challenge in aligning stakeholder expectations during a project, which required effective communication and negotiation skills.
• Identified conflicting priorities among stakeholders, leading to project delays.

• Facilitated a series of workshops to gather input and clarify objectives.

• Developed a prioritized project roadmap that addressed key concerns.

• Regularly communicated updates to keep stakeholders informed and...read more
Answered by AI
Add your answer

Q1. Gave a use case like chatbot and asked how would I design it. SQL Technical questions - SCDs , moving averages , data warehousing concepts , query optimization techniques
Add your answer
Q2. SQL Query about removing duplicates
Ans. 
Learn how to write SQL queries to effectively remove duplicate records from a dataset.
• Use the DISTINCT keyword to select unique records. Example: SELECT DISTINCT column_name FROM table_name;

• Utilize GROUP BY to aggregate data and eliminate duplicates. Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name;

• For more control, use a Common Table Expression (CTE) or subquery to identify duplicates. Exampl...read more
Answered by AI
Add your answer

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related 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...read more
Answered by AI
Add your answer
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
Add your answer
Q3. Spark and it’s architecture
Add your answer
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
Add your answer

Q1. Questions on spark and kafka
Add your answer

Q1. How soon you will join
Add your answer