TEKIZMA Interview Questions and Answers

Q1. Give diffrence between rank n dense rank of sql
Ans. 
Rank assigns unique rank to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.
• Rank leaves gaps in ranking sequence if there are ties, while dense rank does not.

• Rank function is used to assign unique rank to each distinct row based on specified column values.

• Dense rank function is used to assign consecutive ranks to rows with the same values based on specified column values.

• Examp...read more
Answered by AI
Add your answer
Q2. Explain end to end ETL testing
Ans. 
End to end ETL testing involves testing the entire process of extracting, transforming, and loading data from source to target systems.
• Understand the data flow from source to target systems

• Verify data extraction from source systems

• Validate data transformation logic

• Check data loading into target systems

• Perform data reconciliation between source and target systems
Answered by AI
Add your answer
Q3. Scenario based questions
Add your answer

Q1. Reverse string. Find min Find max from list
Ans. 
Reverse a string and find min/max from a list of strings.
• To reverse a string, use built-in functions or loop through characters in reverse order.

• To find min/max from a list of strings, convert strings to numbers if needed and use built-in functions.

• Example: Reverse string 'hello' -> 'olleh'. Find min/max from list ['5', '10', '2'] -> min: 2, max: 10.
Answered by AI
Add your answer

Q1. Interview was based on my skills on java selenium Testng Cucumber Restassured Jenkins Maven appium jira Javacore etc
Add your answer
Q2. Interviewer will try to test the understanding and your skill set
Add your answer

General aptitude questions and technical mcqs were asked

Q1. Asked questions about sql and about front end development?
Ans. I wrote the query and redesigned their webpage
Answered Anonymously
Add your answer
Q2. Questions about resume
Add your answer
Q3. Asnwered with confidence and clarity
Add your answer

Q1. Basic oops concept
Add your answer

Collections,string reverse