Sigmoid Data Engineer Interview Questions and Answers for Freshers

Q1. How would you write a REST API from scratch? Explain your role in the project.
Ans. 
To write a REST API from scratch, I would follow these steps:
• Define the resources and endpoints

• Choose a programming language and framework

• Implement CRUD operations for each resource

• Use HTTP methods and status codes correctly

• Add authentication and authorization

• Test the API using tools like Postman

• Document the API using tools like Swagger
Answered by AI
Add your answer

Q1. Windows function on sql
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a set of rows related to the current row

• They do not cause rows to become grouped into a single output row like aggregate functions

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
Answered by AI
Add your answer

Q1. Pandas questions
Add your answer

Q1. Asked regarding the previous project
Add your answer

Q1. Basics of sql and some coding questions
Add your answer
Q2. Data structures
Add your answer

Q1. Putin arrays strings
Add your answer

A train running at the speed of 60 km/hr crosses a pole of 9 seconds. what is hte length of train?

Print all prime numbers

First round was online coding round, second was coding in interview infornt of panel, third was DSA+basic Database questions