JoulestoWatts Business Solutions Senior Software Engineer Interview Questions and Answers

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Q1. SQL query to join 3 tables
Ans. 
Use SQL JOIN to combine data from 3 tables based on a common key.
• Use INNER JOIN, LEFT JOIN, or RIGHT JOIN depending on the desired result

• Specify the columns to select from each table

• Use ON clause to specify the join condition
Answered by AI
Add your answer
Q2. Spring boot annotations
Add your answer
Q3. Hibernate annotations
Add your answer
Q4. Java 8 Streams + Lambda
Add your answer

Q1. Working style: Independent contributor or Team
Add your answer
Q2. Are green-field projects alright?
Ans. 
Green-field projects are great opportunities to start fresh and implement new technologies.
• Green-field projects allow for creative freedom and innovation

• They provide the opportunity to work with the latest technologies and tools

• Starting from scratch can lead to cleaner code and better architecture

• Examples: Developing a new mobile app, creating a new website from scratch
Answered by AI
Add your answer
Q3. Are you ok with learning new tech stacks?
Add your answer

Q1. Sql question, joins , store procedure
Add your answer
Q2. Mvc question, mvc frame work
Add your answer

Aptitude test

Current affairs

Q1. Puzzle , sql related questions
Add your answer

30 mins Aptitude Question

30 mins - 3 Coding Question

Q1. Describe Rest API
Ans. 
Rest API is a set of rules and conventions for building and interacting with web services using HTTP methods.
• Rest API stands for Representational State Transfer Application Programming Interface.

• It uses standard HTTP methods like GET, POST, PUT, DELETE to perform CRUD operations.

• RESTful APIs use URLs to access resources, and return data in JSON or XML format.

• Stateless communication allows for scalability and flexibilit...read more
Answered by AI
Add your answer
Q2. What is various Response code. Diffenrence b/w 200 & 201, 400 & 403
Ans. 
Response codes indicate the status of a HTTP request. 200 & 201 are success codes, while 400 & 403 are client error codes.
• 200 - OK: Request was successful

• 201 - Created: Request was successful and a new resource was created

• 400 - Bad Request: The server cannot process the request due to a client error

• 403 - Forbidden: The server understood the request, but refuses to authorize it
Answered by AI
Add your answer

Q1. What do u mean by data
Ans. 
Data refers to facts, statistics, or information collected for analysis or reference.
• Data is raw, unprocessed information.

• It can be in the form of numbers, text, images, or any other format.

• Examples include customer names, product prices, and sales figures.

• Data can be structured (organized in a specific way) or unstructured (not organized).
Answered by AI
Add your answer
Q2. What is preprocessed data
Ans. 
Preprocessed data is data that has been cleaned, transformed, and organized for analysis or modeling.
• Preprocessed data is often used in machine learning and data analysis to improve the accuracy and efficiency of models.

• Common preprocessing steps include removing missing values, scaling features, and encoding categorical variables.

• Examples of preprocessing techniques include normalization, standardization, one-hot enco
Answered by AI
Add your answer
Q3. What do u mean by info
Ans. 
Info refers to data or knowledge that provides details or context about a specific topic or subject.
• Info can be in the form of facts, statistics, or explanations.

• It helps to understand a topic better or make informed decisions.

• Examples of info include news articles, research papers, and educational resources.
Answered by AI
Add your answer
Q4. How to copy from 2 tables and paste in 3rd one in sql
Ans. 
Use SQL INSERT INTO SELECT statement to copy data from 2 tables and paste into a 3rd table.
• Use INSERT INTO SELECT statement to copy data from 2 tables and paste into a 3rd table.

• Specify the columns you want to copy from each table in the SELECT statement.

• Make sure the columns in the SELECT statement match the columns in the 3rd table where you are pasting the data.
Answered by AI
Add your answer
Q5. Reverse string using any language you know
Ans. 
Reverse a string using any programming language
• Use built-in functions like reverse() or slice() in languages like Python or JavaScript

• Iterate through the string in reverse order and append each character to a new string

• Use a stack data structure to push each character onto the stack and then pop them off to reverse the string
Answered by AI
Add your answer
Q6. A puzzle question was asked but i don't remeber it.
Add your answer