SenseGiz Technologies Interview Questions and Answers

Q1. End to end architecture of current project
Add your answer
Q2. Basic spark code to read & write files
Add your answer
Q3. How to upsert data in table in spark
Add your answer
Q4. How do you handle sudden increase in data volume
Add your answer
Q5. Discussion on delta tables & ACID transactions
Add your answer
Q6. Explain autoloader and use case in Databricks
Add your answer
Q7. SQL question using window functions Lead, row number
Add your answer
Q8. Python question using hashmap & String
Add your answer

Q1. Current project understanding end to end
Add your answer
Q2. Data pipeline design for a ride sharing company, ask bunch of follow up questions on the conclude a particular design.
Add your answer
Q3. Explain how you follow SDLC(Agile, waterfall) ?
Add your answer
Q4. Why are you looking for a change now
Add your answer

Q1. Basic introductions
Add your answer
Q2. What kind of work are you looking for? what do you know about the company
Add your answer
Q3. Willing to relocate?
Add your answer
Q4. Personal hobbies and aspirations
Add your answer

General basic assessment.

Q1. They will give you few PDFs to read and then MCQ from that.
Add your answer

It was conducted in hacker earth
Around 1:55hr

Q1. Write a code for encrypting and decryption of character
Ans. 
Code for encrypting and decrypting characters using a simple algorithm
• Use a simple algorithm like shifting the characters by a fixed number of positions in the ASCII table

• For encryption, add the fixed number to the ASCII value of each character

• For decryption, subtract the fixed number from the ASCII value of each character
Answered by AI
Add your answer
Q2. Given a python code find the bugs
Ans. 
Identify bugs in a given Python code
• Check for syntax errors such as missing colons or parentheses

• Look for logical errors in the code that may cause unexpected behavior

• Test edge cases and boundary conditions to ensure code handles all scenarios

• Use debugging tools like print statements or a debugger to trace the flow of the code
Answered by AI
Add your answer

Q1. What is your experience in sales?
Add your answer
Q2. What was your target, and how frequently did you achieve it?
Add your answer
Q3. What are your expectations for working here at the company?
Add your answer

The assignment round consisted of two parts: the first part involved researching their company, writing a pitch, and identifying the appropriate personas, while the second part required me to pitch a product from my previous company and record the presentation.

Q1. How was your interview so far?
Add your answer
Q2. What are your salary expectations?
Add your answer

Mintu Babu lives in a smaller house than her brother and in a larger house than her parents. Her children reside with her, and she has no other relatives. If Mintu Babu's relative U lives in a larger house than her relative S, then all the following may be true except: \n\n1) S is U's father \n\n2) S is U's mother \n\n3) U is younger than S \n\n4) S is younger than U

Q1. 1. merge two linked list
Add your answer
Q2. 2. reverse a linked list.
Add your answer

2 DSA Questions, medium level

Q1. System Design for a application
Add your answer

Q1. High Level System Design
Add your answer

Q1. About yourself ?
Add your answer
Q2. Just asked questions on previous role
Add your answer
Q3. How many types of IOT devices are there
Ans. 
There are three main types of IoT devices: consumer, commercial, and industrial.
• Consumer IoT devices: Smart home devices like thermostats, lights, and security cameras.

• Commercial IoT devices: Smart meters, asset tracking systems, and connected vending machines.

• Industrial IoT devices: Sensors and actuators used in manufacturing, agriculture, and healthcare.
Answered by AI
Add your answer