Orion Systems Integrators Interview Questions and Answers

Q1. What are the different sizes available for a virtual warehouse in Snowflake, and which sizes are currently being utilized in your current project?
Add your answer
Q2. What are stored procedures in Snowflake, and how did you utilize them?
Add your answer

Q1. How did you verify the data after transferring it from one database to another?
Add your answer
Q2. What are the different types of duplicate checks that can be performed using SQL queries?
Add your answer

Q1. Are you open to relocating to Hyderabad?
Add your answer
Q2. What information do you have about ValueLabs?
Add your answer

Q1. What is the Singleton pattern ? in how many ways can this pattern be broken ?
Ans. 
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
• Singleton pattern can be implemented by making the constructor private and providing a static method to access the instance.

• The pattern can be broken by using reflection to access the private constructor and create multiple instances.

• Another way to break the Singleton pattern is by using multiple class loaders in Java.

• Th...read more
Answered by AI
Add your answer
Q2. What is the internal implementation of hashmap? Let's assume that you want to store duplicate keys in the hashmap, how can we achieve the same in hashmap ?
Ans. 
HashMap internally uses an array of linked lists to store key-value pairs. To store duplicate keys, we can use a custom implementation of HashMap.
• HashMap internally uses an array of linked lists to handle collisions.

• To store duplicate keys, we can create a custom HashMap implementation that allows multiple values for the same key.

• One approach is to use a HashMap with values as lists, where each key can have multiple va
Answered by AI
Add your answer

Q1. What microservices patterns are you aware ? let's assume that there is a microservice based architecture and service A is calling service B which in turn service C. If service b fails, how will you manage ...read more
Ans. 
Use compensating transactions and distributed tracing for managing transaction and logging in case of service B failure.
• Implement compensating transactions to rollback changes made by service B in case of failure.

• Use distributed tracing to track the flow of requests and identify where the failure occurred.

• Implement retry mechanisms to handle transient failures in service B.

• Use circuit breakers to prevent cascading fail...read more
Answered by AI
Add your answer
Q2. System Design question : Design a booking wesite for.eg: bookin.com ?
Add your answer

Q1. Engineering Technical Questions on manufacturing process
Add your answer
Q2. Sheet Metal Work Basic
Add your answer
Q3. Casting and Machining
Add your answer
Q4. Zero based costing
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. DIscussed on mIcroservice arch with AWS
Add your answer
Q2. Question related to spring boot annotations
Add your answer
Q3. Questions related to design pattern
Add your answer

Q1. Question related to previous project.
Add your answer
Q2. Some questions of MySQL
Add your answer
Q3. Multithreading related questions,
Add your answer

Q1. Tell me about yourself: Provide a snapshot of who you are, and how your background and skills align with the position. You can also highlight a key accomplishment that's relevant to the role.
Ans. 
I am a dedicated Junior Engineer with a strong background in production and a proven track record of successfully implementing process improvements.
• Bachelor's degree in Mechanical Engineering

• Experience in optimizing production processes to increase efficiency

• Proficient in CAD software for designing production layouts

• Implemented a new scheduling system that reduced production downtime by 20%
Answered by AI
Add your answer
Q2. How do you fix a mistake? Provide an example of how you handled a mistake in the workplace, and the actions you took to resolve it.
Ans. 
To fix a mistake, I analyze the root cause, take responsibility, communicate with stakeholders, and implement a solution.
• Analyze the root cause of the mistake to understand what went wrong

• Take responsibility for the mistake and acknowledge it to relevant parties

• Communicate with stakeholders to keep them informed about the situation

• Implement a solution to rectify the mistake and prevent it from happening again

• Example: I...read more
Answered by AI
Add your answer
Q3. Focus on highlighting your key strengths, accomplishments, and career goals.
Add your answer
Q4. Acknowledge your mistake: Take responsibility for your actions and explain what went wrong.
Ans. 
I take full responsibility for my mistake in not double-checking the production schedule, resulting in a delay in delivery.
• Acknowledge the mistake without making excuses

• Explain what went wrong and how it could have been prevented

• Discuss steps taken to rectify the mistake and prevent it from happening again
Answered by AI
Add your answer
Q5. Take care of yourself: Prioritize self-care and get some perspective.
Ans. 
Prioritizing self-care is essential for maintaining overall well-being and gaining perspective in life.
• Make time for activities that bring you joy and relaxation, such as reading, exercising, or spending time with loved ones.

• Practice mindfulness and self-reflection to understand your emotions and thoughts better.

• Set boundaries to protect your mental and physical health, such as saying no to additional work when you're ...read more
Answered by AI
Add your answer

Q1. What stresses you out the most?
Add your answer
Q2. Where do you see yourself in 3 years?
Add your answer

Q1. Name a time you had a dispute on a project
Add your answer
Q2. What are your biggest strengths?
Add your answer

Q1. Coding question on backtracking
Add your answer
Q2. About state in react
Add your answer

Q1. About my work in previous company
Add your answer
Q2. About database in detail
Add your answer

Q1. What do you mean by GIS
Add your answer
Q2. Django Web development and Rest APIs
Add your answer

Q1. The 1st round was JAM - Just a minute. They will give you a topic on the spot and we have to talk about this topic for 1-2min. Topics: The perfect prank you pulled, The best trip, Your pet's inner thoughts...read more
Add your answer

The 2nd round is GD: The GD was conducted properly for other batches. But for our batch the HR just collected everyone's resume and asked qns from our resume.
(Note: This is not an elimination round)

The 3rd round was Aptitude and Technical mcq test: 10 qns - DBMS, 20 - Quants, 20 - Java mcq
(Note: This round has negative markings)

Q1. Resume based and about projects
Add your answer
Q2. Basic sql queries Eg: SQL query to find the no of students in a department
Add your answer
Q3. Reverse a string - Python
Ans. 
Reverse a string in Python using slicing
• Use string slicing with a step of -1 to reverse the string

• Example: 'hello'[::-1] will return 'olleh'
Answered by AI
Add your answer

Q1. The last round was general hr: Since there were two many candidates the process took too much time. There was no questions asked during the hr round, who ever has agreed to the 2yrs bond were recruited
Add your answer