ITC Infotech Automation interview experience

-

In this article we will cover the interview experience of ITC Infotech Pvt Ltd for the role of Automation Testing for the client Fidelity in Gurgaon location.

ITC Infotech Automation interview experience

Company - ITC Infotech
Location - Gurgaon
Job Role - Automation Engineer
Date of Interview - 18th April 2021
Interviewer - Priyanka Arora

  • Tell me about yourself
  • What is a test plan?
  • What user roles are associated with Agile?
  • What do we do for Sprint 0?
  • Difference between String, StringBuilder and StringBuffer?
  • Can we perform get operation using Put?
  • What do you understand by Constructor?
  • What is the difference between abstract class and interface?
  • What do you understand by inheritance?
  • What do you understand by polymorphism?
  • Can there be 2 foreign keys?
    • Yes a table can have multiple foreign keys and each foreign key may be associated with different parent table.
    • Each table can have only one non null unique primary key.
To conclude, the interviewer was really cooperative and asked only high level questions and almost agreed with every answer.

Round 2 - Client interview

Next round was taken by the client of ITC - Fidelity.

Date of Interview - 23rd April 2021
Interviewer - Pratush(Test Lead) and Utkarsh Sinha(Test Manager)

  • Define waits in selenium?
  • Define OOPS concepts?
  • Give example of OOPS in your framework?
  • Explain your framework?
  • What is your role in your current organization?
  • Write an SQL query to find top 5 employees who are having even salary?
    • To find even salary we use below query 
      • Select * from Employee Where MOD(salary,2)=0;
    • To find odd salary we use below query
      • select * from Employee where MOD(salary,2) =1;
    • To find the top 3 employees , we use TOP keyword
      • select Top 3 * from employees;
  • Write down the test cases for a lift/ Elevator?
  • Write down the test cases for a pen?
  • Give the example of high Severity and low priority?
  • How can you extract unique records from a list without using Set?
  • What is the difference between git pull and git fetch?

How can you extract unique records from a list without using Set?

Date of interview - 7th May 2021
Interviewer - Shaifi Mehta and Saumya

  • What is the difference between priority and Severity?
    • Priority is defined as the order by which the defect should be fixed. Whereas severity is the impact of a bug in business.
    • Priority is defined by the client requirement and severity is defined by the QA.
    • Examples of Priority and Severity -
      • High Priority and high severity - Key feature doesn't work, for an example - we are getting error 404 not found.
      • High Priority and low severity - Company logo is in the wrong color
      • Low priority and high severity - Feature that is rarely used that doesn't work. For example - some link in the footer.
      • Low priority and low severity - Some caption in the image is written in the wrong font.
  • How do you add a column into the table? What is the command used?
    • Alter Table Employee
    • Add Birthday Date;
  • What is Union command?
  • Suppose we have a table called Employee and it has columns like emp_name, state, dept and covid (+ve or -ve) and if we want to extract the emp name with the dept name having covid +ve? How would you do it?
  • Can Where and Having be used in a single query?
    • A query can contain both Having and Where clause
    • For an example -
      • SELECT titles.pub_id, AVG(titles.price)  
      • FROM titles INNER JOIN publishers  
      •    ON titles.pub_id = publishers.pub_id  
      • WHERE publishers.state = 'CA'  
      • GROUP BY titles.pub_id  
      • HAVING AVG(price) > 10
  • How do you extract min row from a table?
  • How can you update a row in SQL?
  • How do you select unique rows from a table?
  • How do you find the 3rd highest salary of an employee from a table using NOT keyword?
  • Conditional operators in SQL?
  • What is the difference between DDL and DML? What are the commands used?
  • Difference between for and for-each loop?


Comments

Post a Comment

Popular posts from this blog

Azure Tutorials Series - Azure Networking

-
Image
In this article, we will learn about Azure networking concepts such as architecture, microservices, virtual networks, VPNs, subnet, VPN gateways and most importantly Network Security Group(NSG). All these terms are to be understood if you appearing for AZ900 Microsoft Azure Fundamentals exam. Azure Networking In previous articles we have learnt about Micro- services and how they work, these are alos loosely coupled architecture. Some of the features includes Independent components interact with each other with the help of queues Can be updated and deployed independently Highly scalable Supports Asynchronous messaging N-tier Architecture Supports loosely coupled architecture Application divided into multiple tiers such that higher tier can access lower tier but not vice versa Tiers are re-usable and can be updated or replaced easily without any hassle. Three-tier in general Web Tier(front end) Application tier(back end) Data tier(Storage) Virtual Network Isolated network shared by few g...
Read more

Testing in CI/CD

-
If you are part of testing fraternity you would have heard CI/CD numerous times by now. It's the talk of the software testing town. In this article, we will cover the basics of CI/CD, what actually it is and how it is implemented in software testing. What is continuous integration? In simple terms, development teams can integrate their code into a shared repository. This helps in maintaining code quality and identifying potential issues with the local version of the code at an early stage. What is continuous delivery? Everything that is being continuously merged by the development team, is continuously deployed to the live environment. Continuous delivery is often coined as ‘Continuous Deployment’ as well. Since most developers work in parallel, continuously integrating their code into one repository would mean that the master branch is continuously updated with new features. In order to ensure that there is no compromise in the code quality with so many changes...
Read more

Azure Tutorials Series - IaaS vs PaaS vs SaaS

-
Image
We already have covered Public vs Private vs Hybrid differentiation in the previous article. In this article we will be covering three categories of cloud computing with relevant examples and details. Most of you might already be using these services in your daily day-to-day tasks unaware of the face that your organisation has already started the transition into the cloud. For an example, Office 365 is a active SaaS(Software as a service) that most of us uses, VMs are examples of IaaS(Infrastructure as a service) and Azure SQL Database is PaaS(Platform as a service). Now how do we differentiate between the three categories as a user? Will cover the details below. Infrastructure as a Service(IaaS) Service provider provides you the hardware User gets some control over the hardware, can customise operating system, storage and VMs. Ensuring service is up and running is shared responsibility While cloud provider makes sure that the hardware is functioning correctly, user needs to make sure ...
Read more