Onward Technologies Inc Software Development Engineer II Interview Questions and Answers

Q1. Looker developer
Add your answer
Q2. Sql server
Add your answer

Q1. Looker developer
Add your answer
Q2. Sql server
Add your answer

Q1. How does consumer, producer work in kafka
Ans. 
Consumers read data from topics, while producers write data to topics in Kafka.
• Consumers subscribe to topics to read messages from them

• Producers publish messages to topics for consumers to read

• Consumers can be part of a consumer group to scale out consumption

• Producers can specify key for messages to control partitioning
Answered by AI
Add your answer

Q1. Questions on spring boot and question around spring annotations and its benifits
Add your answer
Q2. Questions on Java 8 - 21 versions such as virtual threads and stream API
Add your answer
Q3. Question on Databases fundamentals.
Add your answer

Q1. C#, Angular,.net
Add your answer
Q2. SQl,Jobject,Bidning
Add your answer

Q1. Code pairing round - you will be given story where you need to add one API to the share repository. It is a simple problem but needs good understanding of the shared code. You should follow clean code pri...read more
Add your answer
Q2. Add one API to the existing repository
Ans. 
The API allows users to retrieve weather data based on location.
• Create a new endpoint that accepts a location parameter

• Use a weather API service to fetch weather data based on the location

• Return the weather data in a standardized format, such as JSON
Answered by AI
Add your answer

Q1. Project you are working on, do some changes to the project, how well you understand the project
Add your answer
Q2. Add some feature to the project
Ans. 
The feature added to the project is a user authentication system.
• Implement a login page with username and password fields.

• Create a database table to store user credentials.

• Hash and salt passwords for secure storage.

• Implement password reset functionality.

• Add user roles and permissions for access control.
Answered by AI
Add your answer

Q1. Basic questions from oops, collections and springboot, basic queries.
Add your answer

Q1. Basics about big data tools. Use case on Pyspark. How to add the new column and what is AQE benefits and Delta table optimisation tenchiques.
Add your answer
Q2. Basics about Azure resources like ADF, Azure Databricks. Explained the project architecture and sone questions on that.
Add your answer
Q3. Pyspark optimisation techniques explain and write scd type 2 sample code.
Ans. 
Optimisation techniques in Pyspark and sample code for SCD type 2
• Use broadcast variables to reduce data shuffling

• Partition data based on key columns to improve performance

• Use cache() or persist() to avoid recomputing data

• Use coalesce() or repartition() to reduce the number of partitions

• For SCD type 2, use merge() function to update or insert new records

• Example code for SCD type 2: https://github.com/awantik/pyspark-101
Answered by AI
Add your answer

Q1. How huge data your are working? What are toughest problem you faced and resolved it ?
Ans. 
I have worked with huge data sets in the past.
• I have experience working with data sets ranging from a few gigabytes to several terabytes.

• One of the toughest problems I faced was optimizing a query that was taking too long to execute.

• I resolved it by analyzing the query plan and identifying the bottleneck, then optimizing the query accordingly.

• Another challenge I faced was dealing with data inconsistencies, which I reso...read more
Answered by AI
Add your answer
Q2. Explain you project architecture ? Show some sample codes of the same.
Ans. 
Our project architecture follows a microservices approach with containerization using Docker and orchestration with Kubernetes.
• We have divided our application into smaller, independent services that communicate with each other through APIs.

• Each service is containerized using Docker, allowing for easy deployment and scaling.

• We use Kubernetes for orchestration, which automates the deployment, scaling, and management of o...read more
Answered by AI
Add your answer

Q1. Compensation decision and clear your doubts regarding organisation.
Add your answer

Q1. It is secret bb m bklbkl ll
Add your answer

Coding test reading to your platform

Q1. Technical interview
Add your answer