Real questions from top companies in General/Other
Have you worked on Data Warehousing projects?
How would you read data from a web API? What steps would you follow after reading the data?
Retrieve the most recent sale_timestamp for each product (Latest Transaction).
What is the difference between OLTP and OLAP?
What is the difference between SQL and NoSQL databases?
Agile in project management?
Basic logical or analytical puzzle
Calculate a 7-day moving average of orders for each city in the Swiggy database.
Calculate the total number of transactions (units sold) for each product.
Can you share an example of a project you worked on that had a significant impact on your organization?
Combine records by name with concatenated course values
Command to Read JSON Data and Options
Compare batch processing and stream processing for financial data.
Count occurrences of a specific word in a file
Daily Data Volume - quantify
Data Security in BFSI - encryption, IAM, auditing
Data Shuffling Causes and Techniques
Data Storage and Retrieval Optimization techniques
Data access strategy for clients
Data masking scenarios for secure data handling
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.