CIBERsites India Tester Interview Questions and Answers

Aptitude and combined coding tests

Q1. Design a parking app or design a web or mobile app where farmers can directly sell their produce
Ans. 
Design a web/mobile app for farmers to directly sell their produce.
• Create a user-friendly interface for farmers to list their produce

• Include features for farmers to set prices and quantities

• Implement a search function for buyers to find specific produce

• Include a secure payment system for transactions

• Allow farmers to track their sales and manage inventory
Answered by AI
Add your answer

Q1. You have to explain the design of your previous round
Add your answer

Worst experience company is not so good

Q1. What is object oriented programming
Ans. 
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
• OOP focuses on creating objects that interact with each other to solve problems

• Encapsulation, inheritance, and polymorphism are key principles of OOP

• Examples of OOP languages include Java, C++, and Python
Answered by AI
Add your answer
Q2. Questions on data structute
Add your answer

Q1. How are you different from other testers ?
Ans. 
I have a strong background in automation testing and a keen eye for detail.
• Extensive experience in automation testing using tools like Selenium and Appium

• Ability to write complex test scripts and perform regression testing efficiently

• Strong analytical skills to identify and troubleshoot issues effectively

• Proven track record of finding critical bugs missed by other testers
Answered by AI
Add your answer

Q1. Cisco Servers Installation
Add your answer
Q2. HPe servers installation
Add your answer

Q1. Basic SQL questions……………………………………..
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Tell me about yourself.
Add your answer

Apitude test with coding test two sql questions,

Q1. What is ETL, Layers of ETL, Do you know any ETL automation tool
Ans. 
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database.
• ETL involves three main layers: Extraction, Transformation, and Loading.

• Extraction: Data is extracted from various sources such as databases, files, APIs, etc.

• Transformation: Data is cleaned, validated, and transformed into a consistent format.

• Load...read more
Answered by AI
Add your answer
Q2. Python star pattern 1 12 123, Differnce between List and Dictionary
Ans. 
Python star pattern 1 12 123 is a pattern printing question. List and Dictionary are data structures in Python.
• Python star pattern 1 12 123 can be achieved using nested loops.

• Lists are ordered collections of items, accessed by index. Dictionaries are key-value pairs, accessed by key.

• Example: List - [1, 2, 3], Dictionary - {'a': 1, 'b': 2, 'c': 3}
Answered by AI
Add your answer
Q3. 10-12 Queries based on joins, max function etc, difference between rank, dense rank, row_number and its syntax, how to combine two columns without concat function. What is Alias. What is the use of partiti...read more
Add your answer
Q4. Do you know GCP? Do you know bigquery?
Ans. 
Yes, I am familiar with Google Cloud Platform (GCP) and BigQuery.
• I have experience working with GCP services such as Compute Engine, Cloud Storage, and BigQuery.

• I have used BigQuery for analyzing large datasets and running complex queries.

• I am familiar with setting up data pipelines and ETL processes using GCP services.
Answered by AI
Add your answer
Q5. Q based on resume Shell scripting commands what is -x what is chmod 757 on owner group and others
Add your answer
Q6. What is SDLC, STLC
Ans. 
SDLC stands for Software Development Life Cycle and STLC stands for Software Testing Life Cycle.
• SDLC is a process used by software development teams to design, develop, and test high-quality software.

• STLC is a subset of SDLC focused specifically on the testing phase of the software development process.

• SDLC includes phases like planning, analysis, design, implementation, and maintenance.

• STLC includes phases like test pl...read more
Answered by AI
Add your answer

Q1. About batch processing
Add your answer
Q2. About exception handling
Add your answer

Q1. About project discussion in details
Add your answer
Q2. Aws services mainly
Add your answer

Q1. Handling a team
Add your answer
Q2. Micro service architecture
Add your answer

Q1. About personal things
Add your answer
Q2. About financial thing
Add your answer