Friday 7 July 2017

Automation Tester - 2 to 5 years exp - Xpanxion

We @ Xpanxion are having Walk in this Saturday(8th July'17) for QA Automation(Selenium JAVA) 

Experience: 2 - 5 years with mandatory min 2 in Selenium with Java.

Location: Aundh, Pune

Walk in Date : Saturday(8th July'17)

Walk in Time : 10:00 AM 12:00 Noon. 

 Venue: Xpanxion International Pvt. Ltd. (www.xpanxion.com) 

                4th Floor, Server Space,  

                A.G. Technology Park, Off ITI Road, 

                Near Sarja Hotel 

                Aundh, Pune 411007  

 Contact Person Veena Jawhare 

Note: Candidates with 15 days/less/Immediate Joiners will be preferred.

Job Description: 

Experience: 2 yrs - 5 yrs with mandatory min 2 in Selenium with Java.

The requirement is mentioned below -

Required skills - 

Strong experience as a QA Automation Engineer, coding in Java 
Experience in Selenium Webdriver, TDD/BDD.
Excellent automation development.
Excellent programming, debugging, and test automation skills.
Experience with designing and developing test automation frameworks, detailed test plans and driving product quality with passion.
Strong and proven record of test framework creation.
Strong and proven record of test methodologies.
Provide technical leadership, direction, and guidance to a focused workgroup in driving rationalization of automation frameworks.
Excellent Communication Skills and ability to collaborate in a multi-disciplinary team.

Mandatory Skills:

Java 

Selenium (Web Driver)

SQL Server

JIRA ( Any defect tracking too), GIT, Maven

A natural communicator who can explain, technical concepts in clear, plain English (both written and verbal)

Infogain - Manual and Automation Profile - 2 to 5 Experience

1. Brief description about your self

2. Type of Integration testing

3. Difference between Smoke and Sanity Testing

4. Bug Life cycle

5. Difference between failed and blocked test cases

6. Difference between regression and retesting.

7. Explain Gray box and Black Box testing.

Explain each with example.

Security Testing -- Selenium -

8. Difference between Absolute and Relative Path

9. How to find duplicate elements

10. Explain frame work - POM

11. Explain how to work with jenkins

12. Explain cucumber framework

13. Explain about appium -- complete start from installation to launch any app.

14. What is webservices? how does it work?

15. Any idea about SOAP UI.

QA Engineer - 2 to 6 yrs exp - Link Tech Pune

divya.kulkarni@linktech.co.in

Experience required for the Job: 2 - 6 years
Job Location: Pune

Hi,
Greetings from Link Technologies Pvt. Ltd.!!
We have a job opportunity in QA Engineer (Subcontract) for our Client in Pune.
Position :QA Engineer(Subcontract)
Experience : 2-6 years
Location: Pune
Job profile:
Automation testing using Selenium or Python scripting, Unix/Linux, SQL and web testing
•Experience working in Linux/Unix environment.
• Good debugging skills.
• Knowledge of relational databases.
• Experience with Performance testing using JMeter, Scale and Reliability testing.
• Experience with automation is a must.
• Preferable experience with Python/Mysql.
• Strong understanding of testing methodologies.
• Understanding of Web based application architecture and interfaces would be a plus.

If interested kindly share your updated profile along with the below
mentioned details:
Total Exp: Yrs
Exp in QA: Yrs
Exp in Automation testing: Yrs
Exp in Selenium/ Python scripting: Yrs
Exp on Linux/ Unix: Yrs
Exp in web testing: Yrs
Current CTC:
Expected CTC:
Notice Period:
Reason for change:

QA Engineer - 2 to 4 yrs - Banglore

We have opening for QA Engineer..

Job Location: Bengaluru/Bangalore and Hyderabad

Job Description:

Required Skills

    2-4 years of relevant experience in testing.
    Bachelors Degree or equivalent Diploma or Masters Degree preferred.
    An aggregate of 60% is mandatory either for Bachelors Degree or for Masters Degree.
    Experience in automation tools like UFT, QTP, Selenium
    hands on experience in Functional testing, System testing, SDLC, STLC.
    Manual testing experience, an understanding of Best Practices and principals of testing
    Experience with various testing methodologies
    Experience testing Web-based applications
    Basic SQL query skills, understanding of database schemas and .NET applications

Please send your updated resume to the email below:
Email: Lakshmia@orioninc.com

About Company: Orion India Systems Pvt. Ltd.
For more details log on to: www.orioninc.com

Thursday 6 July 2017

Experienced Testing Interview Questions and Answers Series

Experienced Testing Interview Q&A – Part 1





Apart from these you can suggest questions as well and that would be answered in next Part of Questions ans Answers series

SQL Interview Questions Part 1

SQL Interview Questions Part 1
1. How to get unique names from Employee table without using DISTINCT keyword.
SELECT name
FROM employee
GROUP BY name

2. SQL Query to find Max Salary from each department.(Only Employee table is used)
SELECT DeptId, MAX(Salary)
FROM Employee
GROUP BY DeptId

3. SQL Query to find Max salary from each department name wise.
(We have to use Employee and Department table as well.)
SELECT DeptName, MAX(Salary)
FROM Employee e
JOIN Department d
ON e.DeptId = d.DeptID
GROUP BY DeptName;

4. Get position of ‘o’ in name ‘John’ from employee table
Oracle Syntax:
SELECT INSTR(Employee_Name,’o’)
FROM employee
WHERE Employee_Name = ‘John’

5. Select first 3 characters of Employee_NAME from EMPLOYEE
Oracle Syntax:
SELECT substr(Employee_NAME,0,3)
FROM employee

6. Get employee details from employee table whose ends with ‘n’
Oracle Syntax:
SELECT *
FROM EMPLOYEE
WHERE EMPLOYEE_NAME like ‘%n’

7. Get names of employees from employee table who has ‘%’ in Last_Name.
Tip : Escape character for special characters in a query.
Oracle Syntax:
SELECT EMPLOYEE_NAME
FROM employee
WHERE EMPLOYEE_NAME like ‘%?%%’

8. Retrieve two highest paid employees from each department.
Oracle Syntax:
SELECT Deptno, Empno, Salary
FROM Employee e
WHERE
2 > (SELECT COUNT(e1.Salary)
FROM Employee e1
WHERE e.Deptno = e1.Deptno AND e.Salary < e1.Salary)
ORDER BY 1,3 DESC;

9. Retrieve fourth highest salary from Employee table.
SELECT DeptNo, EmpName, Salary
FROM Employee A
WHERE
3 = (SELECT COUNT(B.Salary)
FROM Employee B
WHERE A.Salary < B.Salary)
ORDER BY Salary DESC;

Introduction to Software Testing

What is Software Testing?

Software testing is a process of executing a program or application with the intent of finding the softwarebugs.

 It can also be stated as the process of validating and verifying that a software program or application or product: Meets the business and technical requirements that guided it's design and development.

Experienced Testing Interview Q&A – Part 4

1. Difference Between HTTP and HTTPS
URL for the HTTP begins with http:// and that for HTTPS with https://
HTTP used port 80 for communication. HTTPS uses port 443.
HTTPS requires an SSL digital certificate which is not required in case of HTTP.
As discussed earlier, HTTP is unsecured whereas HTTPS is secured.
HTTPS uses encryption which is not used in HTTP.
HTTPS operates at the transport layer of the OSI model. HTTP operates at the application layer.
=================================================================================================================

2. Difference Between GET and POST
GET request is sent via the URL string (appended to the URI with a question-mark as separator), which is visible. 
POST request is encapsulated in the body of the HTTP request and can’t be seen.

GET request goes via URL, so it has a limitation for its length.
POST Request have no limitations on length.

GET request is comparatively faster than POST request.

GET request is sent via URL string and as we all know that URL can be text-only, so GET can carry only text data.  
POST request has no such restriction and it can carry both text as well as binary data.

GET request is nothing but an URL hence it can be cached as well as Bookmarked. 
POST request don’t have such facilities.

GET is the default method of the HTML FORM element.
For POST method, we need to specify the method attribute and give it the value “POST”.

GET requests are restricted to use ASCII characters. 
POSTrequests can use the ‘enctype’ attribute with a value “multipart/form-data” to use the Universal Multiple-Octet Coded Character Set(UCS).
=================================================================================================================

3. Difference Between Usability Testing and GUI Testing.
Graphical User Interface testing is done to check the appearance of the application.
Usability Testing is done to check easiness of the application.
GUI Testing is done to test look and feel of the application.
Usability Testing is done to test user friendliness of the application
GUI Testing includes colors, fonts, font sizes, buttons, links, icons, are displayed as specified or not.
Usability Testing includes if application displayed all mandatory fields, cursor positioning for enter the data into the right field, tab button should work easily etc.
GUI Testing– In this testing we test only the front end of the application.
Usability Testing – In this Testing we test the overall working of application according to a non-technical user’s point of view.
=================================================================================================================

4.Difference between Ad-hoc Testing and Exploratory Testing.
Adhoc Testing begins with learning application first and then start working on testing process
Exploratory testing means test application while learning.
Adhoc Testing– Tester knows application in advance
Exploratory Testing – Tester dont know the functionality of the application at first.
Adhoc Testing – Documentation is not mandatory.
Exploratory Testing – Documentation is mandatory.
Adhoc Testing – Expert tester is not needed for this type of testing
Exploratory Testing – Expert Tester is needed for such type of testing
Adhoc generally is informal testing type with an aim to break the system. This testing is usually an unplanned activity.
Exploratory is testing approach that involves simultaneous learning, test design, and test execution.
Adhoc Testing Example– While Testing WhatsApp user can start with any module with intention to break application.Tester can start any random module.
Exploratory Testing Example – While Testing WhatsApp, first scope has to be defined(Test Attach Document functionality), so now tester has defined area
of testing and can explore this area and user his creativity to find issues
=================================================================================================================

5. Explain Version, Revision and Releases.
Version: An initial release or re-release of a configuration item associated with a complete compilation or recompilation of the item.
Different versions have different functionalityRevision:  Change to a version that corrects only errors in the design/code, but does not affect the documented functionality.
Release:  The formal distribution of an approved version.
=================================================================================================================


6.When you start testing the application?
Criteria to start testing may include following points:
Definition of all test scenario and test cases is completed
Functional and Business requirement should be cleared, confirmed and approved.
Test Environment is ready(Availability of hardware and software for initiating testing is ensured)
The bug tracking system is in place and accessible.
Test Data is available.
Unit Testing is done successfully by developers.
Tester is having significant knowledge of application under test
=================================================================================================================

7.How would you test software application without any formal documents like Requirement Document?
1) Have a meeting with Project Stakeholders who were part of project initiation(Business Analyst, Project Manager).
They can elaborate on functionalities present,Expected Results and Business rules that drives application
2) Have a session with developers as they are part while developing software and have considered some requirements.They
knows major functionality of software and can elaborate more.
3) Do some exploratory testing and learn application functionalities wise. Exploratory testing is good way to learn application
from tester point of view and usually self learning adds boost or confidence.Most of the small scale companies don’t have documentation. In this testing tester have to reply on his previous experience in testing similar kind to application
=================================================================================================================

8.What is Quality Gates ? Why it should be used?
Quality Gate is activity which is present between stages of a project life cycle.
This activity must be completed before moving to next phase of project life cycle.
Its a general criteria that must be satisfied before moving to next stage in project life cycle.
e.g. Software Requirement Specification(SRS) may have
Peer Review
A Requirement Traceability Matrix (From BRS to SRS)
Signed Off by Client, Project Manager.After completing above Quality Gate, then only project moves to next stage i.e. High Level Design Phase in Software Development Life cycleWhy to use it:
As per definition, it can be used to improve visibility of quality in SDLC Stages.
It is used to reduce project risk through phase by phase quality gates.
(You can compare Quality Gates with Entry and Exit Criteria used in Testing Phase. Both are on same lines.)
=================================================================================================================

9.If there are two defects in Application : One is with High Severity  and
Other with High Priority. Which one must be fixed first.
– Severity is related to testing/QA Term and its an impact of a defect on Application.
While Priority is related to Business Term and its a impact of a defect on Overall Business or End Users.
So defect with High Priority have to be fixed first as it affect end users or business.
=================================================================================================================

10.How do you define software product quality?
Software Product Quality can be defined in terms of following quality attributes
a)Reliability:
Software product should be reliable in terms of Availability, Fault tolerance and consistent.
Consistent means it should give correct results any-time and under any conditions.b) b)Maintainability:
Maintainability is the ability of the system to undergo changes with a degree of ease.
These changes could impact components, services, features, and interfaces when adding
or changing the functionality, fixing errors, and meeting new business requirements.c)Re-usability:
Reusability defines the capability for components and subsystems to be suitable for
use in other applications and in other scenarios.
Reusability minimizes the duplication of components and also the implementation time.d)Usability:
Usability defines how well the application meets the requirements of the user and consumer.
It defined how application is easy to use.
e)Testability:
Testability is a measure of how easy it is to create test criteria for the system and its
components, and to execute these tests in order to determine if the criteria are met.

f)Security:
Security is the capability of a system to prevent malicious or accidental actions outside of the designed usage,
and to prevent disclosure or loss of information.
A secure system aims to protect assets and prevent unauthorized modification of information.

g)Scalability:
Scalability is ability of a system to either handle increases in load without impact on the performance
of the system, or the ability to be readily enlarged.

h) Performance:
Performance is an indication of the responsiveness of a system to execute any action within a given time interval.
It can be measured in terms of latency or throughput. Latency is the time taken to respond to any event.
Throughput is the number of events that take place within a given amount of time.

i)Interoperability:
Interoperability is the ability of a system or different systems to operate successfully by communicating and exchanging
information with other external systems written and run by external parties.
An interoperable system makes it easier to exchange and reuse information internally as well as externally.
=================================================================================================================

11.  If you have ‘n’ requirements and you have less time how do you prioritize the requirements?
 In such a scenario, the most critical requirements need to be finalized with discussion from the client and stakeholders.
In testing, requirements aren’t really ‘finalized’ by the testing team.
=================================================================================================================

12.How do you find the regression scenarios if a defect is fixed?
Regression scenarios would be run on all the test cases that  failed during manual testing because of the bug in software. Checking history of the bug may help identifying the regression scenarios. Also we have to decide by observing bug and what could be affected functionalities due to such bug.
=================================================================================================================

13.Let’s say you have a test-plan with over 200 testcases. How do you decide what should be automated and what should still be done manually?
In such case we need to consider two points
a) Priorities of Test Cases
b) Feasibility of automation for Test Cases listed
Some of the questions that the candidate should raise to evaluate:Now using following criteria we have to divide test cases in Automation and Manual way
a) Test cases taking lot of time to execute manually and are tedious in nature.
b) Parts of the application which needs regular regression(We can check defect history to get most error prone areas)
c) Test cases that can be done manually and easily.
d) The test cases that are not easy for manual testing.
(If Selenium tool is being used and test case is more involved with Windows controls i.e. non browser)
e) Areas of software application that could be changed in next weeks.This will prevent us from developing automated test cases for the same
=================================================================================================================

14.What to do when we are out of time, application is not bug free and tomorrow its going for production?
Step1)Make a list of all open defects and share across all key stakeholders like Requirement Owner (PO, Business Analyst), Dev Lead, Dev Manager, Test Lead, Test Manager, Delivery Manager (stakeholders may vary.. depends on your project)Step2)Schedule a defect triage meeting to prioritize all defects in following categories –
Category A: Issues which must be fixed. Software cant be released without that.
Category B: high-priority Issues that should be included in the solution if it is possible
Category C: Issues which is considered desirable but not necessary
Category D: Defects which will not be fixed (issues which does not generate any value addition to the software)
Step 3) All stakeholders should decide go/no go based on the following:
– Can we accommodate Category A issues within deadlines?

If Yes – Can we accommodate category B issues within deadlines? If No – Can we accommodate category B issues post the release?
If No – Which all issues from category A can be accommodated? Can release date be postponed? If Yes, are there any contractual obligations from customer?

Note – “accommodate” means – Issues should be fixed, code reviewed, tested with impact areas.

Remember that last minutes major fixes are usually dangerous. So take wise decision. This decision has to be taken by key stakeholders (not just test team). Make sure that team team give their inputs on impact and testing efforts based on the experience.
Also remember that – Testing team has “some” control on quality. Entire team (dev / test / pms etc) are responsible for the quality.
=================================================================================================================

15. What is defect measurement?
Defect Measurement is a process for analyzing the efficiency of developer and tester and the process on the base of the bug details collected from one
project.
Through Defect Measurement below are all the factors are measured
a) Efficiency of developer
b) Efficiency of tester
c) Whether the progress is in gear?
=================================================================================================================

16. Why not use exhaustive testing? how to prioritize test cases?
Exhaustive testing is a test approach in which all possible data combinations are used for testing.
It takes lot of times that’s why we need to use some testing techniques.

In other way we can priorities test cases so that testing efforts can be reduced and tester/QA can focus on more
important functionalities. We can priorities test cases according to perceived risks and customer expectations towards feature
and tester can reduce number of test cases.

Below are some factors to consider in prioritizing test cases:
– Functionalities used mostly by end users
– Functional Areas with history of bugs.(Examining defect history)
– Most visible functionalities to end users
– Newly added functionalities

17.How load testing is performed on a website? How does it work?
To access a website, a user sends a “request” to that website’s server, and the server sends back
a response in the form of the website/page you want to access.
To load test a website, QA engineers and Automation Engineers just need to multiply the number
of request sent to server to simulate different traffic loads.
The web server’s response for number of virtual users can then be measured by using performance tool.
This is used to determine performance issues and server capacity.
=================================================================================================================

18. What are different types of environments used in software releases?
Generally companies have four environments. Dev, QA/Testing,Staging and Production
a) Dev Environment: Its generally used by developers to commit the working copy of the code. It contains most recent version of the application.
Many developers merge their code to this environment.b) QA Environment: This environment is solely used by Testers/QA to test application.
c) Staging Environment: This environment is copy or mirror of production environment. It looks same as production environment as it may contain
very recent data from productions. We can call this as release candidate.The staging area contains the “next” version of the application
and tester tests application for the final release. Tester may find issues here as data is same as of production environment.

d) Production Environment: It is nothing but live site.
=================================================================================================================

19.What is meant by a test log ?
Test log creates an environment which consists of an integrated management environment where you can create and manage your entire test plan, other than your test cases.
-It helps in managing the development life cycle.
-It also helps in promoting the reusability of the test cases.
-It helps in improving the efficiency.
-It also helps in managing xml database.
-It helps in documenting both automated and manual tet cases.
=================================================================================================================

20.What is difference latent defects and masked defects?
Latent Defects: These are the defects which are present in the system. These defects remain for a long time and can also be detected in different versions of the software. It may be detected after the release. The main reason for this defect is because the exact set of conditions haven’t met.
For Example: February has 28 days. The system will not recognize the leap year and shows an error for leap year. This defect remains in the system and will be recognize in latent defect.

Masked Defects: The main functionality of these defect is that they will hide the other defects in the system. These defects can be observed in page navigation.
If there is a defect in the current page and it causes problem in moving to another page, then the defects in the next page can’t be seen.