Levrara Consulting Group Interview Questions and Answers

Common aptitude questions on mettl platform

Q1. Python Standard interview questions
Add your answer
Q2. SQL Standard interview questions (Easy)
Add your answer
Q3. CaseStudy and questions based on it.
Add your answer

Q1. Common hr questions
Add your answer
Q2. Puzzles
Add your answer
Q3. Project Discussion
Add your answer

Q1. Big data , Optimization , Python basic , SQL intermediate
Add your answer
Q2. Find max and min number without sorting Joins related Big data handling Optimization question
Add your answer

Q1. Schema , python , sql
Add your answer
Q2. Case study sql and python based
Add your answer

Sales data from a leading manufacturer

Q1. What is spark,explain its ecosystem
Add your answer
Q2. What are transformations, and how many types of transformations exist?
Add your answer
Q3. Explain about spark job process and its planning
Add your answer
Q4. What are the concepts of coalesce and repartition in data processing?
Add your answer
Q5. Explain about oom and driverhead memory
Add your answer
Q6. What is data skewness
Add your answer

Q1. Technical Accounting Questions
Add your answer
Q2. Technical Accounting Questions
Add your answer

Asked coding questions on Python and SQL
Python - find longest non repeating substring
SQL - join and window function

Develop a production-grade application in Python that analyzes data and provides answers to questions based on the dataset.

Q1. System design and project based questions
Add your answer
Q2. Scenario-based questions that can help assess how you handle various situations
Add your answer

Q1. What is Derivatives
Add your answer
Q2. What is financial Markets
Add your answer
Q3. V Lookup, X Lookup, H lookup
Add your answer
Q4. Experience in SQL And Power bi
Add your answer
Q5. Internship Experience
Add your answer

Q1. Transition from ASC 840 to ASC 842
Add your answer
Q2. Difference between lessee and lessor accounting under US GAAP
Add your answer

Q1. Detailed accounting of ASC 842
Add your answer

Some basic questions related to profit, time, and distance.

Identify the missing number in the array and remove the duplicate string from another string, then write the remaining portion.

Q1. What is rest api's
Ans. 
REST APIs are a set of rules and conventions for building and interacting with web services.
• REST stands for Representational State Transfer

• Uses standard HTTP methods like GET, POST, PUT, DELETE

• Data is transferred in JSON or XML format

• Stateless communication between client and server

• Example: GET request to retrieve data from a server
Answered by AI
Add your answer
Q2. What is components
Ans. 
Components in software development are modular, reusable parts of a system that perform specific functions.
• Components are building blocks of a software system

• They are designed to be modular and reusable

• Each component performs a specific function or set of functions

• Examples include buttons, forms, navigation bars in a web application
Answered by AI
Add your answer
Q3. Some related to github
Add your answer
Q4. Explain about api testing
Ans. 
API testing involves testing the functionality, reliability, performance, and security of APIs.
• API testing ensures that the API functions as expected and meets the requirements.

• It involves testing the input parameters, output, authentication, error codes, and response time.

• Tools like Postman, SoapUI, and JMeter are commonly used for API testing.

• API testing can be done manually or automated using scripts.

• Common types of...read more
Answered by AI
Add your answer

Q1. Explain about your project
Ans. 
Developed a web application for online food ordering and delivery service
• Used React.js for front-end development

• Implemented Node.js and Express.js for back-end functionality

• Integrated payment gateway for secure transactions
Answered by AI
Add your answer
Q2. What is the logical problem involving 2 rooms, 3 bulbs, and 3 switches?
Add your answer

Q1. What are the technologies you have worked on ?
Ans. 
I have worked on various technologies including Java, Python, SQL, and Tableau.
• Java

• Python

• SQL

• Tableau
Answered by AI
Add your answer
Q2. Help with skills on any of one technology that u have worked for ?
Ans. 
I have worked extensively with Java programming language.
• Developed web applications using Java EE

• Utilized Spring framework for dependency injection

• Implemented RESTful APIs with JAX-RS
Answered by AI
Add your answer