Covansys Interview Questions and Answers

Mcq questions on python aws database and networks ans os

8 members in a panel and they gave a topic generally a social issue or a general topic you can a lot about

Q1. Project based questions
Add your answer
Q2. Python and pandas core question
Add your answer
Q3. Dsa question combination sum
Add your answer
Q4. Database queries
Add your answer

Q1. Question to test your soft skills
Add your answer
Q2. About behavioral attitude and how likely you are to fit in their organization
Add your answer

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. Explain capital markets
Ans. 
Capital markets are where financial securities are bought and sold, including stocks, bonds, and commodities.
• Capital markets facilitate the buying and selling of financial securities such as stocks, bonds, and commodities.

• They provide a platform for companies and governments to raise capital by issuing securities to investors.

• Investors can trade these securities through exchanges like the New York Stock Exchange (NYSE)...read more
Answered by AI
Add your answer
Q2. Explain Reconciliation, explain bond market, futures and options
Ans. 
Reconciliation involves comparing two sets of records to ensure they are in agreement. Bond market, futures, and options are financial instruments used for trading.
• Reconciliation is the process of comparing two sets of records to ensure they are in agreement, typically used in accounting to verify transactions.

• The bond market is where investors buy and sell debt securities issued by governments or corporations, with th...read more
Answered by AI
Add your answer

Q1. How do you handle audit queries
Ans. 
I handle audit queries by thoroughly reviewing the information, communicating effectively with stakeholders, and providing detailed responses.
• Thoroughly review the audit query to understand the scope and requirements

• Communicate with relevant stakeholders to gather necessary information and clarify any doubts

• Provide detailed responses with supporting documentation and explanations

• Follow up on any outstanding queries to
Answered by AI
Add your answer
Q2. How to handle team
Ans. 
Handle team by setting clear expectations, providing support, fostering open communication, and recognizing achievements.
• Set clear expectations and goals for the team members.

• Provide necessary support and resources to help team members succeed.

• Foster open communication and encourage feedback from team members.

• Recognize and reward achievements to motivate the team.

• Address conflicts and issues promptly to maintain a posi
Answered by AI
Add your answer

Q1. API related questions. focused on RPA
Add your answer
Q2. POwer Automate best practice
Add your answer
Q3. Deployment related questions
Add your answer
Q4. Diff types of API
Add your answer
Q5. Multiple datasource use in PA
Add your answer

Q1. Questions on Jetpack compose, kotlin, hilt, permission, Testing,
Add your answer

Q1. Questions on mvvm, clean architecture.
Add your answer

Q1. Client round with questions on android permission, Android security
Add your answer

Q1. Salary discussed
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