The questions below represent the types of technical and behavioral inquiries you will face during your Advanced Micro Devices interviews. They are designed to illustrate patterns in how interviewers evaluate your skills, rather than serving as a definitive memorization list. Focus on the underlying concepts each question tests.

SQL & Data Manipulation

Interviewers will test your ability to extract and manipulate complex datasets efficiently. Expect to write queries live or explain your optimization strategies.

• Write a SQL query to calculate the rolling 30-day average of equipment maintenance delays per facility.
• How would you optimize a slow-running query on a massive table in MS SQL Server?
• Explain the difference between a clustered and non-clustered index, and when you would use each.
• Write a query to identify duplicate inventory records and keep only the most recent entry based on a timestamp.
• How do you handle missing or NULL values when aggregating multivariate data?

Dashboarding & PowerBI

These questions evaluate your ability to translate raw data into actionable visual insights and manage BI infrastructure.

• Walk me through the steps you take to build a PowerBI dashboard from scratch.
• How do you implement row-level security in PowerBI to ensure HR data is only visible to authorized managers?
• Describe a time you had to design a complex DAX measure. What was the business logic behind it?
• How do you decide between using a table, a bar chart, or a scatter plot when visualizing compliance trends?
• Explain how you manage the refresh schedules and data model sizes for enterprise-level PowerBI reports.

ETL & Scripting (Python/C/C++)

You must demonstrate your ability to automate workflows and integrate disparate systems programmatically.

• Describe an ETL process you designed. How did you handle data validation during the transformation phase?
• Write a Python script to parse a directory of daily CSV reports, clean the data, and load it into a SQL database.
• How would you use Python or C++ to automate a business analytics process that currently takes four hours of manual work?
• Explain a specific data structure you used recently to solve a data processing bottleneck.
• How do you handle API rate limits when extracting data from a third-party HR system?

Behavioral & Process Improvement

These questions assess your culture fit, stakeholder management, and ability to drive execution excellence.

• Tell me about a time you identified an improvement opportunity for an existing application and successfully proposed a solution.
• Describe a situation where you had to collaborate with a difficult stakeholder in IT or HR to gain access to necessary data.
• How do you drive the standardization of a procedure across teams that are used to doing things their own way?
• Tell me about a time your data analysis uncovered a trend that senior leadership was not expecting. How did you present it?
• Describe a project where you had to integrate multiple systems to solve a business problem. What was your approach?

This visual timeline outlines the typical stages of the Advanced Micro Devices interview loop, from initial screening to the final technical and behavioral rounds. Use this to pace your preparation, ensuring you review both high-level behavioral narratives and deep technical concepts before the final onsite stage. Keep in mind that specific team availability may slightly alter the order of the final loop interviews.

5. Deep Dive into Evaluation Areas

To succeed in the Business Analyst interviews, you must demonstrate mastery across several core competencies. Interviewers will probe your past experiences to see how your skills align with the specific needs of our internal operations.

Data Analysis & Visualization

This is the core of your daily deliverables. You must prove your ability to take raw, multivariate data and turn it into standardized, easily consumable reports for senior leadership. Interviewers will assess your hands-on experience with PowerBI and your ability to write complex queries in MS SQL Server. Strong performance means not just knowing the syntax, but understanding how to design dashboards that drive higher compliance and user engagement.

Be ready to go over:

• Complex SQL Queries – Writing window functions, handling complex joins, and optimizing query performance for large datasets.
• PowerBI Dashboard Design – Choosing the right visualizations, managing data models within PowerBI, and implementing row-level security.
• Metric Development – Identifying and defining new KPIs for environmental, health, and safety (EHS) or operational efficiency.
• Advanced concepts (less common) – DAX optimization, custom visual development in PowerBI, and real-time dashboarding.

Example questions or scenarios:

• "Walk me through how you would design a PowerBI dashboard to track laboratory material inventory across multiple global sites."
• "Write a SQL query to identify the top three departments with the highest equipment preventive maintenance delays over the last quarter."
• "How do you handle a situation where the business requests a metric that the current data model cannot accurately support?"

System Integration & ETL

Because this role involves integrating data from space planning, HR, and IT systems, your knowledge of ETL (Extract, Transform, Load) and Data Structures is paramount. Interviewers want to see that you can build reliable pipelines that feed your analytics tools. You should be able to discuss how you handle data discrepancies, missing values, and system API integrations.

Be ready to go over:

• ETL Pipeline Design – Extracting data from disparate sources, transforming it for consistency, and loading it into a centralized warehouse.
• Data Structures – Choosing the appropriate data structures for efficient data processing and storage.
• System Architecture – Understanding how different enterprise systems communicate and share data securely.
• Advanced concepts (less common) – Event-driven architecture, handling schema evolution, and managing data latency.

Example questions or scenarios:

• "Describe an ETL pipeline you built from scratch. What challenges did you face when integrating data from two fundamentally different systems?"
• "If our space planning system outputs daily CSVs and our HR system uses a REST API, how would you architect a process to merge this data for a unified report?"
• "How do you ensure data integrity when automating the transfer of preventive maintenance records?"