Goodlead Consulting Services Interview Questions and Answers

Q1. Basics of Python, Flask, ReactJs, RestApi Development
Add your answer
Q2. Python - Difference between is and ==
Add your answer
Q3. React - useEffect vs useState
Add your answer
Q4. Authentication in RestApi
Add your answer
Q5. React - Pure Component and Higher order components
Add your answer

Q1. Core Java OOPS Multithreading..
Add your answer
Q2. Codding question for collection like Array list and LinkedList
Add your answer

Q1. Spring related question like annotation POM file, ....
Add your answer
Q2. Cloud related experience/question
Add your answer

Q1. Previous experience question like project experience...
Add your answer

Q1. What is the SQL query using PIVOT to transform the given input table into the expected output?
Add your answer
Q2. What is the process flow for implementing an incremental load?
Add your answer
Q3. What are the steps involved in query optimization?
Add your answer
Q4. What is the process flow of Slowly Changing Dimension Type 2 (SCD 2), and what are the associated post commands?
Add your answer
Q5. Difference Between dimension tables and fact tables.Which one loaded firs?
Add your answer

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. Explain projects worked on and benefits
Add your answer
Q2. What is agile , SDLC, user stories
Ans. 
Agile is a project management methodology focused on iterative development, SDLC is the software development life cycle, and user stories are short descriptions of a feature told from the perspective of the end user.
• Agile is a project management approach that emphasizes flexibility, collaboration, and customer feedback.

• SDLC is the process of planning, creating, testing, and deploying software applications.

• User stories ...read more
Answered by AI
Add your answer

Q1. How will to create a new market in vietnam for LC/BG
Ans. 
To create a new market in Vietnam for LC/BG, we can start by conducting market research, building relationships with local businesses and government agencies, and offering tailored financial solutions.
• Conduct market research to understand the needs and preferences of Vietnamese businesses

• Build relationships with local banks, businesses, and government agencies to establish credibility and trust

• Offer tailored financial ...read more
Answered by AI
Add your answer
Q2. What is acceptance criteria
Ans. 
Acceptance criteria are conditions that a product must satisfy to be accepted by a user, customer, or stakeholder.
• Acceptance criteria are typically defined during the planning phase of a project.

• They are used to determine whether a product or feature is complete and functioning as expected.

• Acceptance criteria are often written in a specific format, such as 'Given X, when Y, then Z.'

• They help ensure that the product mee...read more
Answered by AI
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

The aptitude test was interesting, Had a bunch of fun puzzles

Q1. Tell me about yourself
Ans. 
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
• Experienced in gathering and analyzing business requirements

• Skilled in creating data models and visualizations

• Proficient in using tools like SQL, Excel, and Tableau

• Strong communication and presentation skills

• Certified in business analysis (e.g. CBAP)
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Add your answer