Friday 12 June 2015

SQL Basics

What is SQL?

SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL is an ANSI (American National Standards Institute) standard



What Can SQL do?


SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
------------------------------------------------------------------

RDBMS


RDBMS stands for Relational Database Management System.

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables.

A table is a collection of related data entries and it consists of columns and rows.


Some of The Most Important SQL Commands




SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index



SQL SELECT Statement

The SELECT statement is used to select data from a database.

The result is stored in a result table, called the result-set.

SQL SELECT Syntax

SELECT column_name,column_name
FROM table_name;
and

SELECT * FROM table_name;

Eg: SELECT CustomerName,City FROM Customers;
Eg:SELECT * FROM Customers;


The SQL SELECT DISTINCT Statement


In a table, a column may contain many duplicate values; and sometimes you only want to list the different (distinct) values.

The DISTINCT keyword can be used to return only distinct (different) values.

SQL SELECT DISTINCT Syntax

SELECT DISTINCT column_name,column_name
FROM table_name;

Eg: SELECT DISTINCT City FROM Customers;

The SQL WHERE Clause

The WHERE clause is used to extract only those records that fulfill a specified criterion.

SQL WHERE Syntax

SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;

Eg: SELECT * FROM Customers
WHERE CustomerID=1;

Operators in The WHERE Clause
The following operators can be used in the WHERE clause:

Operator    Description
=    Equal
<>    Not equal. Note: In some versions of SQL this operator may be written as !=
>    Greater than
<    Less than
>=    Greater than or equal
<=    Less than or equal
BETWEEN    Between an inclusive range
LIKE    Search for a pattern
IN    To specify multiple possible values for a column



The SQL AND & OR Operators


The AND operator displays a record if both the first condition AND the second condition are true.

The OR operator displays a record if either the first condition OR the second condition is true.

Eg: for AND operator
SELECT * FROM Customers
WHERE Country='Germany'
AND City='Berlin';

Eg: for OR operator
SELECT * FROM Customers
WHERE City='Berlin'
OR City='München';

Eg: for both AND and OR
SELECT * FROM Customers
WHERE Country='Germany'
AND (City='Berlin' OR City='München');



The SQL ORDER BY Keyword

The ORDER BY keyword is used to sort the result-set by one or more columns.

The ORDER BY keyword sorts the records in ascending order by default.
To sort the records in a descending order, you can use the DESC keyword.

SQL ORDER BY Syntax

SELECT column_name,column_name
FROM table_name
ORDER BY column_name,column_name ASC|DESC;

Eg: SELECT * FROM Customers
ORDER BY Country,CustomerName;

The SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.


SQL INSERT INTO Syntax

It is possible to write the INSERT INTO statement in two forms.

The first form does not specify the column names where the data will be inserted, only their values:

INSERT INTO table_name
VALUES (value1,value2,value3,...);
The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

Eg: INSERT INTO Customers
VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');
or this SQL statement (including column names):

Eg :INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');

Eg: INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');

**he CustomerID column is an AutoNumber field and is automatically updated with a unique number
for each record in the table.

AutoNumber is a type of data used in Microsoft Access tables to generate an automatically incremented
numeric counter. The default AutoNumber type has a start value of 1 and an increment of1.

The SQL UPDATE Statement


The UPDATE statement is used to update existing records in a table.

SQL UPDATE Syntax

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

Eg: UPDATE Customers
SET ContactName='Alfred Schmidt', City='Hamburg'
WHERE CustomerName='Alfreds Futterkiste';


The SQL DELETE Statement


The DELETE statement is used to delete rows in a table.

SQL DELETE Syntax

DELETE FROM table_name
WHERE some_column=some_value;

Eg: DELETE FROM Customers
WHERE CustomerName='Alfreds Futterkiste' AND ContactName='Maria Anders';

Delete All Data
It is possible to delete all rows in a table without deleting the table.
This means that the table structure, attributes, and indexes will be intact:

DELETE FROM table_name;

or

DELETE * FROM table_name;
------------------------------------------------------------------

The SQL SELECT TOP Clause
The SELECT TOP clause is used to specify the number of records to return.

The SELECT TOP clause can be very useful on large tables with thousands of records.
Returning a large number of records can impact on performance.

Note: Not all database systems support the SELECT TOP clause.

SQL Server / MS Access Syntax

SELECT TOP number|percent column_name(s)
FROM table_name;

SQL SELECT TOP Equivalent in MySQL and Oracle
MySQL Syntax

SELECT column_name(s)
FROM table_name
LIMIT number;
Example

SELECT *
FROM Persons
LIMIT 5;
Oracle Syntax

SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number;
Example

SELECT *
FROM Persons
WHERE ROWNUM <=5;

Eg: SELECT TOP 2 * FROM Customers;
Eg: SELECT TOP 50 PERCENT * FROM Customers;

------------------------------------------------------------------

The SQL LIKE Operator
The LIKE operator is used to search for a specified pattern in a column.
 The "%" sign is used to define wildcards (missing letters) both before and after the pattern.

SQL LIKE Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;

Eg: SELECT * FROM Customers
WHERE City LIKE 's%';--------selects all customers with a City starting with the letter "s"

Eg : SELECT * FROM Customers
WHERE City LIKE '%s';--------selects all customers with a City ending with the letter "s"

Eg: SELECT * FROM Customers
WHERE Country LIKE '%land%';-------selects all customers with a Country containing the pattern "land"

Eg: SELECT * FROM Customers
WHERE Country NOT LIKE '%land%';---selects all customers with a Country NOT containing the pattern "land"

------------------------------------------------------------------
SQL Wildcards
SQL wildcards is used to substitute one or more characters when searching for data in a database.

Note: SQL wildcards must be used with the SQL LIKE operator!

With SQL, the following wildcards can be used:

%--A substitute for zero or more characters
_--A substitute for exactly one character
[charlist]----Any single character in charlist
[^charlist]
or

[!charlist]----Any single character NOT in charlist

Eg: SELECT * FROM Customers
WHERE City LIKE 'ber%';

Eg: SELECT * FROM Customers
WHERE City LIKE '%es%';

Eg: SELECT * FROM Customers
WHERE City LIKE '_erlin';---selects customer in the city that starts
 with any character, followed by "erlin" from the "Customers" table

Eg; SELECT * FROM Customers
WHERE City LIKE 'L_n_on';-----selects customers in the city that starts with a "L", followed by any character,
followed by "n", followed by any character, followed by "on", from the "Customers" table

Eg: SELECT * FROM Customers
WHERE City LIKE '[bsp]%';--------selects customers in cities starting with "b", "s", or "p" from the "Customers" table

Eg: SELECT * FROM Customers
WHERE City LIKE '[!bsp]%';------selects companies in cities NOT starting with "b" or "s" or "p" from the "Customers
------------------------------------------------------------------

he IN Operator
The IN operator allows you to specify multiple values in a WHERE clause.

SQL IN Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)

Wednesday 8 April 2015

Testing Job in Pune : April 2015

Hi !Hope you are doing well !!

Those who are interested in contract to hire only can apply.SourceOne (www.msourceone.com) would be closing many candidates on :HP Performance Center @ Pune Location (4 - 6 yrs). 

Candidates willing to join SourceOne on permanent roll and deployed at TOP MNC,

Kindly send your updated cvs with below input if you would be interested for this opportunity and attend interview:
Present Location
Total IT exp:
Relevant experience:
Current Salary:
Expected Salary:
present company name:
Present employment (Contract/Permanent):
willing to join SourceOne in 15 to 20 days after selection (Y/N):
Kindly send your cvs asap so that we process it further.

 Email: bhawani.upadhyay@msourceone.com

URL:www.sourceone.co.in, www.msourceone.com

Testing Job in Pune : April 2015

We are having an urgent opening for Selenium Testing_Exp-3+Yrs_Pune job location for our CMM Level 5 client.

If you are interested or want to apply for above mentioned requirement, please share your details with any reference of any friends or colleagues interested for the same openings.:- Total Experience: 
Relevant Experience: 
Present Organization: 
Current CTC/ Monthly:-
Expected CTC/ Monthly :-
Notice Period: Should not be more than 15 DaysAt Present Located In: 
Contact Number:Date of Birth:
Highest Qualifications/ Year of Passing : 
Reason for change:- 
Ready to Relocate:
Current CTC:
Expected CTC:

Testing Job in Pune : April 2015

We have an urgent multiple openings for Automation with Selenium with Leading IT Organization.

Role: Automation with Selenium 

Job Location: Pune

Tot Exp: 4 to 9 Yrs

Note: We are looking a candidate who can join within 15 to 20 days not more than that.Note: who can be available for F2F either on Friday 10th April or Saturday, 11th April'15.

*Experience of test automation assessment & automation solution creation and Consulting* Experience of building Test automation Strategy and roadmap.* Experience of building test automation frameworks and reusable components.* Hands on experience with multiple automation tools like Selenium, Ruby, Cucumber* Must have hands on experience with VB scripting.* Experience in Test Management tools like QC/ALM.* Should provide technical guidance to the team.* Should lead a team and also willing to work as an individual contributor.* Good Experience in Test Management tools like QC/ALM.* Good communication skills, good client interfacing skills.

If interested, please revert back with updated resume and CTC details at kanchan.verma@pyramidconsultinginc.com

Tuesday 7 April 2015

Testing Job in Pune : April 2015

Hi! Hope you are doing well!!

One of the fastest growing company from India needs many candidates for " Performance testing"for PUNEWORK LOCATION:PUNE

Your employment with Source One would be permanent after selection and would be deputed at multi b$ MNC for a long term project. Salary and long term career opportunity with Source One would be excellent.Kindly send your updated CV with below input if you would be interested for this opportunity.

Interested for contract to hire position:

15 year regular education(Y/N):
Your Current Contact Number:
Present Company Name : 
Present Location:
Total Exp:
Relavent Exp::
Date of Birth:
Are you working at present (Y/N):

If not please specify reason for not working:Present Employment (Permanent or Contract):
If Contract Company(payroll) Name:Current Salary:
Expected minimum salary:
What is your current official Notice Period:
Ready to attend interview on Sunday(Y/N):
Willing to join Source One in 15 days please specify (Y/N):
Please specify your reason for change:Preferred work location

E-mail : anamika.gupta@msourceone.com

Testing Job in Mediaocean, Pune : April 2015

This is permenant opening with Mediaocean for Pune location.About Mediaocean-Media Ocean is US based product company.

These products are used by Advertisigng Holding Companies which is a niche domain. Worldwide there are 1000 employees and in Pune which is the off-shore dev centre 120 employees operate.One should join this company for highly competitive work culture and casual environment.Exposure to different clients based world wide, and direct interaction with the teams.Other Locations in India / Abroad-Total: 11 Global Offices Head quartered in New yorkEurope: London, Paris, DusseldorfUS: New York, Atlanta, Chicago, New Jersey, Los Angeles, Louis Ville, TorontoFor more details Pl visit website www.mediaocean.com

Skill-Selenium Testing

Requirements:*Extensive Experience on Selenium Web driver, RC using Java*Hands on experience on design/develop and maintain test automation frameworks*Good exposure to regression/smoke test automation and maintenance*Very Good command on programming and scripting*Strong problem solving abilities, innovative*Very good analytical skills *Knowledge of testing enterprise Web based application*Good Communication skills/ should be able to work independently*Good academic background*Self-Starter, highly motivated and energetic.

Qualifications:*4 Plus years' experience as a software test engineer or software QA engineer involving writing and executing tests, white box testing.If you are interested in this opening kindly send me your updated CV with following details.
Total Exp. 
Relevant Exp. 
Current CTC 
Exp.CTC- 
Notice

Email : darshan.sheth@seedinfotech.com

Testing Walkin Drive in Pune on 8,9,10 April

We at Xpanxion International Pvt Ltd. are conducting a Weekday - Walkin Drive between 8th April-10th April 2015 for Automation Testing. 

Looking for candidates with 1.5-5 years of experience in Automation Testing, Selenium Webdriver, Java. 

Required skills are: Automation Testing, Java, Selenium Webdriver, Hybrid Framework development experience and good hands on databases. 

Experience : 1.5-5 years

 Date : 8th April, 9th April, 10th April 2015 Time: 9:30 AM (Sharp) - 4:00 PM

 Venue: Xpanxion International Pvt. Ltd. 4th Floor, Server Space, A.G. &Technology Park, Off ITI Road, Near Sarja Hotel, Aundh, Pune - 411007. 

Documents to carry :- 1. Updated CV. 2. Passport Size Photograph. Your resume will be shortlisted based on our requirement before proceeding with interview. There will be programming test, technical interview.

Interested candidates can send me their updated resume at prafullac@xpanxion.co.in & sakshig@xpanxion.co.in 

Testing Walkin Drive : Pune : 18 April 2015

Hi,

Recruitment Drive is scheduled in World's first and only Real Time Value Network Provider Company, One Network Enterprises, An US MNC in Pune for QA -Automation Testing (Selenium, Java}.

Below are the required details of recruitment drive for your further needful:Interview rounds:

Written Test-Based on Java, Automation Testing (90 Minutes) 

Date: Saturday, 18th April 2015

Written Test Time: 10.00AM to 11:30AM

Address:One Network Enterprises (India) Pvt Westend Center III, Survey No. 169/1, 2nd Floor, South Wing, Sector II, Aundh, Pune - 411007, MaharashtraLandmark-CDAC Building//Near DominosContact No: 020 - 30901806 

Contact Person: Lakhwa Dewadiya/Chhaya Kulkarni

Details about Job Role: Job Title: Quality Assurance (QA) Engineer / Sr. QA Engineer

Location: Pune, India

Job Summary:QA Engineer will be a member of the Quality Assurance team for One Network's Supply Chain products. He/She will share responsibilities with the team for testing and certifying all products coming from the development. He/She will also be involved in automating applicable test cases using Selenium or any standard automation tool.Essential Functions:* Analyzing and reviewing technical requirements* Producing test plans and creating test cases* Executing test cases, logging defects* Verifying defect fixes* Producing status reports for release under test* Automating test cases using Selenium or any standard automation toolEducation: B E/B Tech in Computer Science or equivalent

Experience and Skills:* Minimum 2 -8 years' experience in testing of Web applications* Strong analytical problem solving skills* Experience with Selenium RC / Selenium web driver tool* Hands on exp. in Core Java* Knowledge of SQL* Experience in reviewing specifications and creating test plans* Experience in creating test cases from test plans and requirements* Excellent communication (verbal and written) and interpersonal skills* Functional knowledge of supply chains, logistics, order management, etc. is a plus

About One Network:One Network's Real Time Value Network™ provides community based supply chain solutions in the cloud to help customers increase profitability and efficiencies by optimizing their supply chain operations. Our software solutions enable customers to easily collaborate with all their value chain participants on a single network ─ customers, partners, carriers and suppliers.You can visit website www.onenetwork.com for more information.If the above mentioned criteria suits to your expectation and skills you are invited to appear for test and also send your updated CV to LDEWADIYA@ONENETWORK.COM for more information:

Feel free to reply in case of query-02030901806

Thursday 26 March 2015

Testing Job in Pune @ Sears Holding : March 2015

We have position for Automation QA professionals 

Job Location : Pune

Skills:Job Purpose: Need engineers who are solid in Core Java and are extremely comfortable in Unix/Linux.

If they have an automation experience (Selenium or API) If you are interested in this opportunity,

please send your updated profile with following information.

Current CTC:
Expected CTC:
Notice Period:
Can you join in 30 Days (Yes/No)
Total Exp:
Relevant Exp:

Email to ankur.vachher@searshc.com

Testing job in Pune @ L&T Infotech : 28 March 2015

Below is the requirement details for your reference -

 JOB LOCATION : Pune, 

Experience Level - 4 years to 8 years

JOB DESCRIPTION/JOB RESPONSIBILITIESAutomation Tester* In depth knowledge and hand on experience on Performance Testing using JMeter or Load Runner* Good Communication and proactive attitude * DB Knowledge will be added advantageDesirable:1. Maintain positive relationships with stakeholders2. Practice and display active reading skills3. Practice excellent conflict management skills4. Be assertive5. Make good decisions6. Experience in leading and growing juniors on the team7. Display good problem solving skills8. Be able to set priorities and execute in accordance with such priorities9. Be able to facilitate discussions and meetings10. Is driven to constantly improve their own skills and able to manage themselves11. Able to think outside the box, and see the bigger picture

Please share your profile to amar.khamitkar@lntinfotech.com

Total IT Experience Performance Testing Experience - 
Available for Technical Interview on Saturday, 28th March 15 -
Current CTC 
Expected CTC 
Notice Period

Current Location

Testing Job in Pune at Vartemis - 28 March 2015

I have Urgent job opening with a US Based Product Development Company in Wakad, Pune.

Looking for QA Engineers with Experience on Following skills,Jmeter and Performance testing.

Please reply back with your updated CV with following details,

Current CTC:
Expected CTC
Notice Period:
Availability for Face to Face Interview on Saturday, 28th March:

Email to dheeraj@vartemis.com

Testing Job in Pune at Symphony Teleca- March 2015

We have opening for Sr Software Engineer with experience in telecom domain for Pune Location. 

Please share your updated profile along with following details 
Total Experience: 
Current CTC: 
Exp CTC: 
Notice Period: 

Please find the job description below: 

* Designation / Title: Sr Software Engineer
* Range of years of experience: 3-5 years # Demonstrated Skills/Experience
Technical Skills:The ideal candidate will have 4+ years of relevant experience in testing products/solutions and hands-on experience on majority of the below listed areas:
* Should have strong telecom bss domain knowledge
* Should have exposure to Interconnect / Inter operator settlement* Telecom Billing knowledge * Oracle Knowledge* Good test case design skills* Exposure to oracle database concepts and sql tuning skills is an added advantage* Exposure to reporting tools advantageousSoft Skills:* Detail oriented good analytical and problem solving skills* Excellent communication skills, written and oral* Highly motivated, goal-oriented and well-organized - "to win" orientation* Exemplary team-player

Please email to trupti.shetty@symphonyteleca.com

Testing Job in Pune at Synechron March 2015

Immediate Performance Testers / Leads needed @ Synechron Pune

Mandatory Skills - Performance Testing concepts, Load Runner, Jmeter, Performance Monitoring

Role -Testers / Leads

Experience - 5 to 8 years

Job Location - Pune (Hinjawadi)Looking for candidate who can join within 30 days.

Key Responsibilities - * Test Plan/Test Report creations* Test Script creation / Executions* Plan and Results walk through meetings* Issue resolutions and Support/dependencies management for the performance testing activities* Performance bottleneck identification and resolution recommendations

Shortlisted candidates will be called on Saturday for interviews.Interested candidates please share your profile to - Vrushal.Garud@Synechron.com with below details - 

Total Experience ?
Current CTC ?
Expected CTC Notice period ?
Ready to work in 12-9 Shift ?

Wednesday 25 March 2015

Testing Job :Curlogic : March 2015

Greetings from Curologic Systems!!!

We are offering an opportunity to work with 'One Network Enterprises' for the profile of 'Senior QA.'

Please go through the job description below. If you are interested, please revert back with your updated profile and following information.
1. Experience in Selenium Web Driver: (No. of years)
2. Current CTC:Fix:Variable:
3. Expected CTC
4. Current Organization:
5. Notice Period:

Company Profile (www.onenetwork.com)One Network's Real Time Value Network customers increase profitability and efficiencies by optimizing their supply chain operations. Our software solutionsenable customers to easily collaborate with all their value chain parpartners, carriers and suppliers.

Profile Overview

Organization: One Network Enterprises

Profile: Senior QA

Location: Aundh, Pune

Experience: 3-8

Education: B E/B Tech in Computer Science or equivalent

Roles and ResponsibilitiesAnalyzing and reviewing technical requirementsProducing test plans and creating test casesExecuting test cases, logging defectsVerifying defect fixesProducing status reports for release under testAutomating test cases using Selenium or any standard automation tools

Experience and Skills

Minimum 3 -6 years' experience in testing of Web applicationsStrong analytical problem solving skillsExperience with Selenium RC / Selenium web driver toolHands on exp. in Core JavaKnowledge of SQLExperience in reviewing specifications and creating test plansExperience in creating test cases from test plans and requirementsExcellent communication (verbal and written) and interpersonal skillsFunctional knowledge of supply chains, logistics, order management,etc. is a plusFeel free to share the opportunity in your professional circle.In case of any queries, please Mail- skarnik@curologic.com

Testing Job : Pune : Fiserv : March 2015

We are having following open position in our organization. Please find the job description below for the open position. If you are interested, then Kindly send me your updated profile along with following details.

Total Experience = 
Current CTC =
Expected CTC=
Notice Period=
Current Location=
Current Requirement: - Test Engineer / Senior Test Engineer - Selenium Testing (This is not lead position).

Education Qualification: - B.E/B-Tech/MCA/M.Sc / MCS.Domain: - Banking & Finance.
Experience: - 3 years - 5 years. 

Skills Sets:1. Selenium Testing.2. Automation Testing.3. Webdriver 4. Java/ C++5. SQL 

Job Location: Pune 

Job Description: *Work with Testing COE*Be involved in tasks like test automation tool evaluations, test automation POC development and feasibility study and automation framework conceptualization and development*Experience in writing and executing automated test cases.*Experience in developing automation frameworks (modular, keyword-driven, data-driven)*Experience in Selenium testing tools (Selenium RC, Webdriver)*Strong Java/C# skills *Knowledge about OOP's concepts *Experience in tools like Ant, Maven, TestNG/Junit *Good experience in testing SQL queries and stored procedures*Experience in performance testing *Positive attitude and willingness to learn multiple testing and test automation tools*Good communication and analytical skills Please reply using same subject line. Please note:-1. We would appreciate if you could refer any of your friends / colleagues for this position. 

Email to pranjal.mukherjee@fiserv.com

Monday 2 February 2015

Testing Job in Pune : SilkTest Automation Testing :2-3 Years : February 2015

"Warm Greetings"

I am hiring for SilkTest Automation Testing immediate opening with my client in Pune location.

JD:


Associates should have experience working on SilkTest Automation Tools.
Overall 3 to 5 year experience in automation testing.
2 to 3 years of experience in SilkTest Automation testing.
Able to lead a team of 4 to 5 members.
Good communication skills


Qualifications: B.Sc. / B.Com / B.E. / B.Tech / MCA / M.Sc. (regular / full-time degree only)

Joining : 30 - 45 Days


1. Permanent or Contract : Permanent


Kindly revert with updated CV & the following details immediately if you are interested for the same.

Total Exp:
Relevant Exp:
Current C.T.C:
Expected C.T.C:
Notice Period:


Email to  mohsin.shaikh@ptgindia.com

Testing Job at Xpanxion : 3-7 Years : Pune

We, at Xpanxion, have an opportunity for QA professionals. The essential key skills required are listed below:

-experience in Automation testing using Selenium.
-hands on experience on automation tool Selenium/ Selenium web driver.
-Strong MS SQL Server and database designing skills.
-Good Java programming skills

Years of experience - 3 to 7 years
Work Location - Pune

If you are interested in this opportunity, kindly mail me your updated CV with details of your current and expected CTC, your notice period and automation tool worked on.

Candidates who can join us immediately would be preferred.

About Us
* Global Software Engineering Services Company founded in 1997
* Headquarter is at Atlanta, Development & QA Center at Pune & a dedicated QA center at Nebraska
*CMM level 4 and ISO 9001:2008 certified, Also has Microsoft Gold Certified Partner status
* Specialized in building end to end products for software and technology companies and build applications for large enterprises.



Email to
sakshg@xpanxion.co.in

Testing Job : Pune : 2+ Years : February 2015

We are the fastest growing HR solutions company in India, with specialized service offerings in Recruitment Solutions, Executive Search, Training, Legal services and project based RPO hiring, headquartered at Bangalore. We provide world class HR services through our company across India. The list of our satisfied customers includes leading MNCs and large Indian firms across industries.

We are currently contractors for Selenium Testing for one of our esteemed client based in Pune to join their Core Technology team and make a difference.

ROLES & RESPONSIBILITIES
*Atleast 2 Years of experience in Automation testing developing test automation.
*Java Essentials for Automation Testing.
*Should have worked using Selenium Automation Tool
*Ability to write and interpret Regular Expressions
*Practice data-driven approach for test case design and execution.
*Documenting test results and preparing reports.
*Work closely with the implementation team for test scripting, execution and scheduling.
*Developing and executing regression tests scripts.

Your response to this email with your updated resume will be highly appreciated. Also revert with the accurate information below to confirm your interest in the above mentioned opportunity.

Total Experience:
Relevant Experience:
Current CTC:
Expected CTC:
Notice Period: (immediately or 10 days)

Please let me know the best time and number to contact you so we can discuss your interest and the opportunities in more detail.

Look forward to hearing from you.


Email to  anusha@precisionstaffers.com

Monday 19 January 2015

Installation of TestNG in Eclipse

Installation of TestNG in Eclipse

Prerequisites for installing TestNG

1) Java JDK 1.5 or above
2) Eclipse
3) TestNG Library

1. Install java on your machine.

Java can be installed from http://www.oracle.com/technetwork/java/javase/downloads/index.html

From this site download the latest JDK version based on your computer requirement (64 bit or 32 bit).


 


2. Install Eclipse on your machine.
 
Eclipse can be installed from
http://www.eclipse.org/downloads/
From this site down load eclipse based on your computer requirement (64 bit or 32 bit)


 


3. Download TestNG libraries

 
 It is easy to install TestNG, as it comes as a plugin for Eclipse IDE.

Steps to download TestNG

a) Go to Help menu -> Install new software.


 

b) A new screen will show up. Enter the site as http://beust.com/eclipse/

c) The TestNG software will be listed. Click on Next and then install it.
 

 

d) Eclipse will be restarted and then you can add new TestNG class.