Autodesk Software Engineer Intern Interview Questions

0 views

Skip to first unread message

Danny Hosford

unread,

Aug 3, 2024, 3:58:55 PM8/3/24

to pozrehosta

This round was a pure DSA round. First, he asked for my introduction. Then he asked DSA questions about Group Anagrams. First few minutes I was struggling with this question. I was approaching the solution in the wrong direction but he gave me a hint to solve it using sorting. Then I cracked it (Make sure to speak out loud what you think). He asked only approach. Then he asked another question Count the number of islands and said you have only 10 min. For this question, he wants only code not approach. I have already solved this question earlier so I wrote the code in 5 minutes. He asked to have you solve this question earlier. I said I have solved a similar problem, not the same. And the interview ended.

This round started with my introduction. Then she asked how were your last two rounds and the name of the interviewer. She asked about my family background and my summer internship experience ( I was a Full Stack Developer at Uvi Health and she was one of the users) and asked questions like how many endpoints and features you have created and explain the logic behind them. Then she asked two easy DSA questions: Fibonacci number and swap two numbers without using extra variables. Then she asked HR questions like what do you know about Autodesk, where do you see yourself in the next 5 years, and strengths and weaknesses. In the end, she asked a few questions about computer fundamentals.

I was surprised when he said I will not ask about your introductions like other interviewers. And said this is HR round and according to you, how do you think it should be. What will you judge if you are an interviewer? After that he asked questions like, are you open to learning new technologies, what will you do if your teammate escaped before project submission, Are you an introvert or extrovert. In the end, he asked me if I had any questions.

At Autodesk, SQL is used quite frequently for analyzing user behavior of it's construction software products and to support it's construction cloud analytics product. That's why Autodesk asks SQL query questions in interviews for Data Science, Data Engineering and Data Analytics jobs.

Autodesk provides suites of software services for professionals in construction, manufacturing, media, and other sectors. An important business metric for Autodesk is the amount and frequency of product usage by its users. Let's consider we have a log table that records every single usage of Autodesk products including the time the user used the product, and which user used which product.

This query seeks to count the frequency of usage per user for the month of September 2022 by using the DATE_PART function to filter for that specific month and year, and then grouping by user_id. We use the HAVING clause to only return users with a usage_count greater than 500, which are the Whale Users.

At Autodesk, we have multiple software products and it's vital to measure user satisfaction. A unique review is submitted by a user for a product each month, identified by a user_id, product_id, submit_date and rating out of 5 stars. In this question, you're to write a SQL query that calculates the average rating (stars) of each product for each month. Assume that the submit_date is in the 'YYYY-MM-DD HH:MI:SS' format.

This query first extracts the month part from the submit_date field. Then, it calculates the average rating per month and product_id using the AVG function. Finally, it orders the result by month and product_id.

The CampaignID column is used to uniquely identify each row in the table, and the constraint ensures that there are no duplicate CampaignID values. This helps to maintain the accuracy of the data by preventing duplicate rows. The primary key is also an important part of the table because it enables you to easily identify and reference specific campaigns in your Facebook Ad data. You can use it to join to other tables in the database, such as a table with data on the results of the campaigns.

Autodesk, Inc. is a multinational software company that makes software services for the architecture, engineering, construction, manufacturing, media, education, and entertainment industries. Autodesk produces a wide range of products that facilitate the professional work of its customers, their tools range from AutoCAD to Maya, a render software for 3D animations.

Let's consider a business scenario where Autodesk wants to analyze the usage of its software products in client companies. They intend to observe the number of licenses active, the number of users per client company, and the overall usage duration of each software product. Given the daily usage data, design a database schema to model this situation and write a SQL query to get total usage in hours, per client company, per product for the month of July 2022.

This SQL query joins all three tables and sums the usage_hours grouping by client_name and product_name. The WHERE condition limits the calculation to the usage data of July 2022. The sorting order presents the results such that the company with the most usage hours comes first for each specific product.

When designing a database schema, a one-to-one relationship between two entities is characterized by each entity being related to a single instance of the other. An example of this is the relationship between a car and a license plate - each car has one license plate, and each license plate belongs to one car.

On the other hand, a one-to-many relationship is when one entity can be associated with multiple instances of the other entity. For example, a person can have multiple email addresses, but each email address only relates back to one person.

This query first joins the and tables on . It then selects customers from 'USA' and their total purchases in 'AutoCAD'. Finally, it filters the results for customers whose total purchases exceed $5000.

As an analyst at Autodesk, you need to understand the average duration of usage for their AutoCAD software. This could help help benefit the business strategy for understanding user interaction with the software. Write a SQL query that calculates the average duration of usage per user for AutoCAD.

This SQL query selects the user_id and calculates the average difference (in hours) between the start_time and end_time for each user where the software_name is AutoCAD. The gives the difference in seconds between the two times, which is then divided by 3600 to convert it to hours. The CSV function then calculates the average duration for each user. The result is a list of users and their average usage duration for the AutoCAD software.

Stored procedures are a lot like functions in programming. They're used to encapsulate and organize business logic into one unit of code, and they can accept multiple input parameters and return multiple output values.

At Autodesk, we are continuously releasing new versions of our software products and we would like to identify the best versions based on user reviews. Each product has a different number of reviews, and each review has a number of stars and a weight, where the weight implies the importance of the review based on the reviewer's profile.

The first CTE calculates the number of reviewers, the average number of stars, and the weighted average stars for each product version. The second CTE calculates the mean review score across the all reviews. The final SELECT statement applies the formula to return a list of product versions and their corresponding weighted ratings, sorted in descending order of the weighted rating.

The key to acing a Autodesk SQL interview is to practice, practice, and then practice some more!Beyond just solving the above Autodesk SQL interview questions, you should also solve the 200+ SQL questions on DataLemur which come from companies like Microsoft, Google, and Facebook.

Join as many Career Circles as you want by updating your career interests on Handshake. Updating your career interests will allow you to receive the latest Circle updates. Check out more information about the Circles here.

Are you looking to use real-time job market data to make informed decisions about your future career path, explore relevant salary data, or identify the skills you need to build or market to get your next role? Use the following tool to explore your options.

Thousands of internship and job opportunities are posted on Handshake by employers specifically looking to hire students. The following job and internship opportunities were pulled from Handshake for your career circle.

For thousands more opportunities, log in to Handshake. All UM students have a Handshake account that is automatically created for them when they enroll at the U. All you have to do is log in to Handshake to activate your account.

Access and explore on-demand LinkedIn Learning content (courses and videos) that can help you identify and build skills needed to be successful in your future career. Here, you can find relevant LinkedIn Learning content featured for your career circle.

Build valuable career skills and get a taste of industry experience via short virtual projects created by top companies across the globe on the Forage platform. Click on "View All Projects" to view all experiences for this career community. To check out projects across all the career communities and relevant practice interview questions, here.

Vault offers comprehensive industry and career guides that provide insights into industry work life and advice for students and alumni on kickstarting their careers. You can access 170+ guides on our Custom Career Content site to help you explore career paths and gain valuable information that will help you make informed career decisions.