TCS Business Associate Interview Questions and Answers

To read data from a particular column in Excel through automation, use Excel VBA or Python libraries like openpyxl or pandas.

• Identify the column by its header or index

• Use a loop to iterate through the rows and extract the data from the column

• Store the data in a variable or write it to a file

• Examples: Excel VBA - Range("A:A").Value; openpyxl - sheet["A"]

• Examples: pandas - df["Column Name"] or df.iloc[:, column_index]

I use a hybrid framework for automation. Difficulties include handling dynamic elements and synchronization.

• I use a combination of data-driven and keyword-driven approaches for automation

• I faced challenges in handling dynamic elements such as pop-ups and alerts

• Synchronization between different components of the framework was also a challenge

• I overcame these difficulties by using explicit waits and dynamic locators

• For e...read more

Example of handling Java concepts and Selenium

• Implemented constructor in Java to initialize variables

• Used Selenium WebDriver to automate web testing

• Created test scripts using Java and Selenium

• Handled exceptions in Java while using Selenium

• Used Java concepts like inheritance and polymorphism in Selenium test scripts