ORIENTAL PRESS Interview Questions and Answers

Q1. How should one conduct an interview session?
Ans. 
Conducting an interview session involves preparation, active listening, asking relevant questions, and providing a positive experience for the candidate.
• Prepare by reviewing the candidate's resume and job description

• Create a comfortable environment for the candidate to feel at ease

• Ask open-ended questions to encourage detailed responses

• Listen actively and take notes to remember key points

• Provide clear information about...read more
Answered by AI
View 1 more answer
Q2. What strategies can I employ to secure a job quickly?
Ans. 
Utilize networking, tailor your resume, apply to multiple positions, and follow up with potential employers.
• Network with professionals in your desired field to learn about job opportunities.

• Customize your resume and cover letter for each job application to highlight relevant skills and experiences.

• Apply to a variety of positions to increase your chances of securing a job quickly.

• Follow up with potential employers after...read more
Answered by AI
Add your answer

How should I complete my assignments?

How can I effectively complete my tasks?

What training is available to help me perform my job?

Q1. How can I effectively complete my job profile?
Add your answer
Q2. How should I approach interacting with my interviewer?
Add your answer

Q1. How can I prepare for my job role?
Add your answer
Q2. Please any employeer can help to control my training
Add your answer

It was a coding round interview along with interviewer via Virtual mode. I was given 2 coding questions on HackerRank for the interview:

1. one was an easy problem on counting minimum replacements.
2. "pat is an ordinary kid who works hard to be a great runner...." this was a challenging problem (which I managed to solve).
3. I was asked some basic Python questions, as the role was for a Python Developer.

Q1. LLD for Parking Lot
Add your answer
Q2. Which database are you going to use for Parking lot and Why ?
Ans. 
I would use a relational database like MySQL for the Parking lot as it provides structured data storage and supports complex queries.
• Relational databases like MySQL offer structured data storage for parking lot information

• Supports complex queries for managing parking lot data efficiently

• Ability to handle large amounts of data and transactions

• Provides data integrity and security features

• Can easily integrate with other s
Answered by AI
Add your answer
Q3. Questions related to OOPs
Add your answer
Q4. Questions related to Multi Threading
Add your answer
Q5. Questions related to Projects
Add your answer

Q1. I hate this since i was informed that this round was a technical.
Add your answer
Q2. Usual Mangerial questions, Project Related, etc
Add your answer

Q1. Mathematical operations and number based psychometric game with many levels.
Add your answer
Q2. Choose the odd shape/color combination out of many present on the screen, also a game with many levels.
Add your answer
Q3. Compare 3x3 tables with some patterns on it, choose the tables which are exactly similar, also a game with many levels.
Add your answer
Q4. Psychological test of your personality consisting of some 100 questions in which you have to choose one of the two images(the image which more appropriately describes you).
Add your answer

A very normal topic, ex. " Innovation vs Regulation in technological domain", group of 10-12, 1 min to analyse the topic ourselves and 8 min to discuss as a group.

Q1. Give us a brief introduction of yourself?
Ans. 
I am a recent graduate with a degree in Supply Chain Management, eager to learn and grow in the field of supply excellence.
• Recent graduate with a degree in Supply Chain Management

• Passionate about learning and growing in the field of supply excellence

• Strong communication and analytical skills

• Experience with inventory management software such as SAP
Answered by AI
Add your answer
Q2. Questions based on resume projects.
Add your answer
Q3. Questions based on your branch of study( like mechanical engineering domain questions)
Add your answer
Q4. Share me a scenario where you used your innovative idea to bring about a crucial change and what was the aftermath of it?
Add your answer
Q5. Share me some instance of your life where you were at your lowest and you bounced back and what was the cause and how did you proceed ahead?
Ans. 
I faced a difficult period during college due to personal issues, but I bounced back through perseverance and seeking support.
• Struggled with personal issues affecting my mental health

• Sought help from a counselor and opened up to friends and family

• Focused on self-care and building a support system

• Set small goals and celebrated small victories to regain confidence

• Gradually improved my situation and academic performance
Answered by AI
Add your answer
Q6. Some questions about why ABI, what thought comes to your mind when you hear ABI?
Add your answer

Q1. A brief introduction of yourself?
Ans. 
I am a recent graduate with a degree in Supply Chain Management, eager to learn and grow in the field of supply excellence.
• Recent graduate with a degree in Supply Chain Management

• Passionate about learning and growing in the field of supply excellence

• Strong communication and analytical skills

• Previous internship experience in logistics and procurement
Answered by AI
Add your answer
Q2. Cross questions about your intrest and your resume
Add your answer
Q3. Some scenario based questions where you showed your creativity and innovation.
Add your answer
Q4. Intra personal skills questions where you fought with someone and how did you solve the matter when the other was wrong and you still managed the situation.
Add your answer

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Q1. After 5 years company groth abd other any fild is work.
Add your answer
Q2. Who many currently working is company.
Ans. 
The company currently has 150 employees working.
• The company has a total of 150 employees currently working.

• The number of employees may vary due to hiring or resignations.

• It is important to keep track of the current employee count for reporting purposes.
Answered by AI
Add your answer

Q1. After 5 year company is groth and any other field is working.
Add your answer
Q2. How many country is working project.
Ans. 
The project is working in multiple countries.
• The project is currently active in 10 countries.

• Each country has its own team of workers.

• The project requires coordination between different countries for smooth operation.
Answered by AI
Add your answer

Q1. Documents controller recording question
Add your answer
Q2. Controller accounts related to question
Add your answer

10 min, simple question on programming skills

Q1. Which Microservice communication pattern you have used?
Ans. 
I have used the asynchronous messaging pattern for Microservice communication.
• Implemented messaging queues like RabbitMQ or Kafka for decoupled communication

• Used message brokers to enable communication between Microservices

• Leveraged event-driven architecture for real-time updates and scalability
Answered by AI
Add your answer
Q2. Which Application Insight tool you have used?
Ans. 
I have used Application Insights for monitoring and analyzing the performance of .NET applications.
• Used Application Insights to track application performance metrics

• Analyzed telemetry data to identify performance bottlenecks

• Set up alerts and notifications for critical issues

• Integrated Application Insights with Azure DevOps for continuous monitoring
Answered by AI
Add your answer
Q3. Caching Technique is used in your project
Ans. 
We use in-memory caching technique in our project to improve performance and reduce database load.
• In-memory caching is used to store frequently accessed data in memory for quick retrieval

• Helps reduce database load and improve application performance

• Examples: using MemoryCache in .NET, Redis caching, caching frequently accessed data like user profiles or product information
Answered by AI
Add your answer
Q4. Api Gateways is used in MicrosServices
Ans. 
Yes, API Gateways are used in Microservices to manage and secure communication between services.
• API Gateways act as a single entry point for clients to access multiple microservices

• They handle authentication, authorization, rate limiting, logging, and monitoring

• Examples of API Gateways include Kong, Apigee, and AWS API Gateway
Answered by AI
Add your answer
Q5. Which single sign on technology/Mechanism is used in project
Ans. 
We are using OAuth 2.0 for single sign on in the project.
• OAuth 2.0 is a widely used authorization framework that enables a third-party application to obtain limited access to an HTTP service.

• It allows users to log in once and access multiple applications without having to log in again.

• OAuth 2.0 provides secure delegated access to resources without sharing user credentials.
Answered by AI
Add your answer
Q6. What is JWT token,why we use it
Ans. 
JWT token is a JSON Web Token used for secure transmission of information between parties.
• JWT token is a compact and self-contained way to transmit information between parties.

• It is digitally signed to verify its authenticity and integrity.

• JWT tokens consist of three parts: header, payload, and signature.

• They are commonly used for authentication and information exchange in web applications.

• Example: JWT tokens are often
Answered by AI
Add your answer
Q7. How to implement exception handling and filters in .net core web api
Ans. 
Exception handling and filters in .NET Core Web API
• Use try-catch blocks to handle exceptions in the code

• Implement global exception handling middleware to catch unhandled exceptions

• Use filters like [Authorize] for authentication and [ValidateAntiForgeryToken] for CSRF protection

• Create custom exception filters by implementing IExceptionFilter interface
Answered by AI
Add your answer

Technology making ours less human ( 15 min) online

Q1. Tell me about yourself
Add your answer
Q2. Tell me about you inters hip
Add your answer
Q3. Fixed assets with example
Ans. 
Fixed assets are long-term tangible assets that are used in the production of goods or services and are not intended for sale.
• Fixed assets are physical assets such as buildings, machinery, equipment, vehicles, and land.

• They are not intended for sale and are used for the production of goods or services over a long period of time.

• Examples of fixed assets include manufacturing plants, office buildings, delivery trucks, an
Answered by AI
Add your answer
Q4. Capital assets with example
Ans. 
Capital assets are long-term assets that are used in the production of goods or services and are not easily converted into cash.
• Capital assets are typically tangible assets such as buildings, machinery, equipment, and vehicles.

• They are used by a company to generate revenue over an extended period of time.

• Examples of capital assets include manufacturing plants, delivery trucks, office furniture, and computer systems.
Answered by AI
Add your answer
Q5. Why we use current ration
Ans. 
Current ratio is used to assess a company's ability to pay its short-term obligations with its short-term assets.
• Current ratio is a liquidity ratio that measures a company's ability to cover its short-term liabilities with its short-term assets.

• It is calculated by dividing current assets by current liabilities.

• A current ratio of 1 or higher is generally considered healthy, as it indicates that a company has enough curr...read more
Answered by AI
Add your answer