20+ Coretelligent Interview Questions and Answers

QA plays a crucial role in identifying and communicating the discrepancies between built functionality and requirements.

• QA should thoroughly review the requirements documentation to understand the expected functionality.

• QA should conduct thorough testing to identify any discrepancies between the built functionality and the requirements.

• QA should communicate any discrepancies found to the development team and stakeholders for resolution.

• QA should work closely with the developm...read more

Implemented automated test scripts using Selenium for regression testing, introduced code review process for test scripts, and conducted training sessions on new testing tools.

• Implemented automated test scripts using Selenium for regression testing

• Introduced code review process for test scripts

• Conducted training sessions on new testing tools

I currently hold 2 offer letters. My current CTC is $80,000 and my expected CTC is $90,000.

• I hold 2 offer letters

• Current CTC is $80,000

• Expected CTC is $90,000

Various tools used for database, build deployment, bug tracking, and test case/plan tracking in QA engineering.

• Database: SQL Server, MySQL, Oracle

• Build Deployment: Jenkins, TeamCity, Bamboo

• Bug Tracking: Jira, Bugzilla, Redmine

• Test Case/Plan Tracking: TestRail, HP ALM, Zephyr

Yes, I am comfortable with coming to the office regularly in a hybrid model.

• I value face-to-face interactions with team members for better collaboration and communication.

• I am able to manage my time effectively to balance office and remote work.

• I understand the importance of being present in the office for certain tasks or meetings.

• I am adaptable and flexible in my work environment.

I have extensive experience in automation testing and have also taken courses in AI and machine learning.

• I have worked on creating automation frameworks using tools like Selenium and Appium.

• I have taken online courses on AI and machine learning to enhance my skills in these areas.

• I have implemented AI-based testing techniques like neural networks for test automation.

RCA and backtracking process involves identifying root causes of issues and revisiting previous steps to find solutions.

• Root Cause Analysis (RCA) is used to identify the underlying cause of a problem or defect in the project.

• Backtracking process involves revisiting previous steps or decisions to find a solution or correct an issue.

• Examples of RCA in current project could include analyzing code changes that led to a bug, or investigating communication breakdowns that caused de...read more

STLC stands for Software Testing Life Cycle, which is a systematic process for testing software applications.

• STLC consists of various phases such as Requirement Analysis, Test Planning, Test Design, Test Execution, and Test Closure.

• Each phase has specific objectives and deliverables to ensure the quality of the software.

• STLC helps in identifying defects early in the development cycle, reducing the cost of fixing them later.

• It ensures that the software meets the specified requ...read more

Contract testing in API involves verifying the interactions between different services based on predefined contracts.

• Contract testing ensures that each service meets the expectations set by the contract.

• It helps in detecting issues early in the development cycle.

• Popular tools for contract testing in APIs include Pact and Spring Cloud Contract.

Stored procedures are precompiled SQL statements stored in the database for reuse and improved performance.

• Stored procedures are used to encapsulate business logic in the database.

• They can improve performance by reducing network traffic and optimizing execution plans.

• Stored procedures can be called from application code to perform complex operations on the database.

• They can also help with security by controlling access to data through the procedure.

• Examples: sp_GetCustomerByI...read more

Questions related to OOPS concepts in software engineering.

• Method overloading is having multiple methods with the same name but different parameters, while method overriding is having a method in a subclass with the same name and parameters as a method in its superclass.

• Inheritance is the ability of a class to inherit properties and methods from its parent class. It allows for code reuse and promotes modularity.

• Encapsulation is the practice of hiding the internal details of a...read more

Answers to SQL related questions for Software Engineer interview

• Primary key uniquely identifies a record in a table, while unique key ensures that no two records have the same value for a specific column

• Normalization is used to eliminate data redundancy and improve data integrity. Types include 1NF, 2NF, 3NF, BCNF, 4NF, 5NF

• SQL queries can be used to retrieve data from one or more tables using joins. Delete and update statements can be used to modify data in a table

SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.

• SQL is a standard language used to manage databases, while MySQL is a specific implementation of a relational database management system.

• SQL is used to interact with databases to perform tasks like querying, updating, and deleting data.

• MySQL is an open-source RDBMS that uses SQL as its query language.

• SQL can be used with various database management sy...read more

ACID properties in DBMS stand for Atomicity, Consistency, Isolation, and Durability.

• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that multiple transactions can be executed concurrently without affecting each other.

• Durability ensures that once a transaction is committed, its effects are permanent even in case...read more

Encapsulation, Inheritance, Polymorphism, Abstraction

• Encapsulation: Bundling data and methods that operate on the data into a single unit

• Inheritance: Ability of a class to inherit properties and behavior from another class

• Polymorphism: Ability to present the same interface for different data types

• Abstraction: Hiding the complex implementation details and showing only the necessary features

TDS on goods purchased above 50 lac is applicable at the rate of 1% under section 194Q of the Income Tax Act.

• TDS is deducted at the rate of 1% on the total value of goods purchased if it exceeds 50 lac in a financial year.

• Section 194Q of the Income Tax Act governs TDS on purchase of goods.

• The responsibility of deducting TDS lies with the buyer of the goods.

• The TDS amount deducted needs to be deposited with the government and a TDS certificate must be issued to the seller.

In my current company, the monthly routine involves processing invoices, reconciling accounts, preparing reports, and communicating with vendors.

• Processing invoices received from vendors

• Reconciling accounts to ensure accuracy

• Preparing monthly financial reports

• Communicating with vendors regarding payment status

• Reviewing and approving expense reports