Slk Software Services ETL Tester Interview Questions and Answers for Experienced

Q1. Diff b/w where clause and having clause? diff b/w severity and priority
Ans. 
Difference between where and having clause and severity and priority
• Where clause is used to filter rows before grouping while having clause is used to filter groups after grouping

• Severity is the degree of impact of a defect on the system while priority is the order in which defects should be fixed

• Where clause is used with SELECT, UPDATE and DELETE statements while having clause is used with GROUP BY clause

• Severity is u...read more
Answered by AI
Add your answer
Q2. Write query last hour hour transaction details through net banking r card
Ans. 
Query for last hour transaction details through net banking or card
• Use the transaction table to filter transactions by timestamp

• Join with the net banking or card table to get additional details

• Filter for transactions within the last hour using a WHERE clause

• Order the results by timestamp to get the most recent transactions first
Answered by AI
Add your answer

Q1. L1 was scheduled and asked abt ETL basics, some sql queries related to string manipulation
Add your answer

Q1. After 1st round I was asked to submit resume again and BGV details. Submitted them and Waiting for round 2
Add your answer

Q1. Explain test framework
Ans. 
A test framework is a set of guidelines or rules used for creating and designing test cases and test scripts.
• Test framework provides a structure for organizing and executing automated tests.

• It includes tools, libraries, and coding standards to support testing activities.

• Examples of test frameworks include Selenium, JUnit, and TestNG.
Answered by AI
Add your answer

Q1. Roles and responsibilities
Add your answer

Aptitude was 1st round, technical apti, then followed by tec nn iCal round

Q1. Technical round was 2 nd, concepts related to testing Testing
Add your answer
Q2. Tsting related questions were asked in interview
Add your answer

Q1. Diff b/w where clause and having clause? diff b/w severity and priority
Ans. 
Difference between where and having clause and severity and priority
• Where clause is used to filter rows before grouping while having clause is used to filter groups after grouping

• Severity is the degree of impact of a defect on the system while priority is the order in which defects should be fixed

• Where clause is used with SELECT, UPDATE and DELETE statements while having clause is used with GROUP BY clause

• Severity is u...read more
Answered by AI
Add your answer
Q2. Write query last hour hour transaction details through net banking r card
Ans. 
Query for last hour transaction details through net banking or card
• Use the transaction table to filter transactions by timestamp

• Join with the net banking or card table to get additional details

• Filter for transactions within the last hour using a WHERE clause

• Order the results by timestamp to get the most recent transactions first
Answered by AI
Add your answer