1. Introduce yourself 2. Drew 2 tables and asked me who I would join them and asked 2-3 queries in SQL 3. Asked me basics of Excel and PowerBi 4. Asked core Java concepts and OOPs concepts and diff between functions and Methods 5. Asked me Python basics
Previous experience with SQL and data visualization software. Some technical questions.
Explain backpropagation in depth and the problem of vanishing gradients
Python question: Provide pseudocode for how to read and concatenate datasets from multiple CSV files in a directory.
Describe your current role and how it will translate here. Hey
Why do you want to work here?
Tech: 1) Question based on SQL (Joins, CTEs, Aggregations) 2) Machine learning and Data Cleansing 3) Data Visualization using PowerBI
SQL Questions Write a SQL query to find the second highest salary from a table of employees. How would you optimize a slow-running query? Explain the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. Cloud Questions What are some common AWS services you’ve used, and how did you utilize them in your projects? Explain the differences between AWS EC2 and AWS Lambda. How do you manage cloud resources to ensure cost efficiency? Coding Questions Write a Python function to reverse a linked list. How would you implement a stack using queues in Python? Solve a problem involving algorithmic complexity, like finding the nth Fibonacci number. Pandas Questions How would you handle missing data in a DataFrame using Pandas? Explain how to merge two DataFrames on a common key. Describe how you would perform data aggregation and summarization with Pandas. Python Questions About Projects and Internships Describe a challenging problem you solved during your internship and the approach you took. How did you use Python in your sentiment analysis project? Explain a particular function or library you frequently used in your projects and why.
Market sizing for a drug/ Strategy for biopharma/ Business opportunity for diagnostic compagny/ Growth strategy for a cro
How much money is spent on toothpaste every year in the US.
Viewing 8451 - 8460 interview questions