Urgent Requirement : Software- Testing Engineer

We are Tharka HR solutions(A Division of Tharka Infotech Pvt Ltd) one of the leading recruitment and HR services consulting company from Hyderabad. We are retained by MNC.

Following is the Requirement
Position: software- Testing Eng
Location : Hyderabad / Bangalore / Chennai / Delhi / Mumbai / Pune
Years of Experience : 2 â€" 6 years
Education Qualification: BE / B.Tech / MCA
NOTE: Please mention the Location ( your Job Preffered Place)
Skill Requirement:
Primary / Must Have Skills:
Testing - Functional, QTP Automation, Performance â€" Load Runner, ETL,
Database, Strong in SQL

Good communication skills (Spoken/written)

For careers post your resumes at -  naveen@tharka.com

CTC as per industry standard and is no bar for the right candidate.

Please send the following details if the above job opening interests you.
1. Updated profile in word format
2. Current Annual Salary + Benefits:
3. Expected Annual Salary + Benefits:
4. Notice period :
5. Two Reference names with contact numbers :
Please forward to your friends and colleagues who are looking for change!!!!
Note: If you have already received the mail for the same OR If the requirement is not matching to your profile, please accept our Apologies and ignore this mail.

Contact Person:
Naveen Kumar
Tharka HR solutions
Mobile : 09886145613

"Testing Openings" @ Software Company Chennai,Walkin our Hyderabad Office

Hi Friend, "Have a great day"
======================================================

Pls walkin Immediately to our Hyderabad office.
======================================================

Refering to your Resume we have immediate openings for
"Testing" in Software company @ Chennai.,If you are Interested
to work with this software pioneer.PLEASE WALKIN


Job Location : Chennai
Skills : "Manual Testing, QTP"
Exp:- : 2+ yrs of Exp

==============================================

Walkin Timing :

Saturday ( 15.05.10) 4.00 PM to 7 PM

Sunday ( 16.05.10) 9.00 AM to 1 PM

===============================================
Contact:
Vasu
Shree Consultancy,
Arun Aditya Residency,
No.6-3-841/a/2
4 Floor, Old Post Office Road(Big Bazaar Road)
Near Durga Temple
opp Road to: Iyangar Bakery
Ameerpet,
Hyderabad-38
Ph.No:: 9293773439

QTP Info

Dear Professionals,

Now websites enhanced with more content, visit and upgrade your skills:

I) QTP Step by Step Guide

An overview on Test Automation

QTP Basic features

Add-in Manager

Key elements of QTP

Test Pane

QTP Commands

QTP Test Process

Recording Tests

Test Object Model

Object Repository

Object Identification Configuration

Keyword Driven Methodology

QTP Test Methods

Descriptive Programming

Enhancing Tests

Inserting Checkpoints

Inserting Output values

Parameterization

Synchronization

Inserting Transaction Points

Step Generator

Adding Comments

Inserting Flow Control Statements

Debugging Tests

Running/Executing Tests

Analyzing Test Results & Reporting

Reporting Defects

Actions

Functions

Environment Variables

Regular Expressions

Virtual Object Configuration 


Batching Testing

Recovery Scenarios

File System Operations

Database connections

Automation Object Model


Dynamic Handling of Object Repositories

                                                          II)QTP Scripting

File System Scripts

Flat File Scripts

Database Scripts

Excel Scripts

GUI Scripts

Web Scripts


QTP Real-time Script Examples

Network Administration

System Administration

Power point Scripts

Word Scripts

XML Scripts


QTP Skills

                                           III)VB Script for QTP

Scripting Languages Vs Programming Languages

Comments

VB Script Variables

VB Script Data Types

VB Script Operators

Input/Output Operations

VB Script Constants

VB Script Conditional Statements

Loop through Code

VB Script Statements

VB Script Procedures

VB Script Errors

VB Script Built-In Functions

Regular Expressions

VB Script Methods

VB Script Objects

VB Script Properties

VB Script Classes

VB Script Keywords

VB Script syntax rules and guidelines

VB Script General Examples

VB Script Glossary

QTP Framework

Test Automation Framework

Types of Framework

Folder Structure

Record & Playback or Linear Framework

Modular Driven framework

Data Driven Framework

Keyword Driven framework

Hybrid driven Framework

Driver Script Creation

Initialization Script

                                        V) QTP Interview Questions

QTP Interview Questions -I

QTP Interview Questions -II

QTP Interview Questions -III

                                                      QTP Certification
This section provides HP QTP Certification guidelines and model Questions, It useful for QTP test professionals for preparing Certification exam.

                                             QTP Training Programs

QTP (Basics to Advanced)

VB Script for QTP

QTP Other Topics

This section provides QTP Related articles and other information like, challenges in Test Automation using QTP, Migrating Test scripts from old version to New version, QTP trends, enhancements, New release information, Browser compatibility issues etc..


Software Testing Reference
    
Sample BRS Document
Sample SRS Document
Software Test Metrics 
SQL for Testers 
SQL Queries Examples 
SQL and PL / SQL Interview Questions-I
SQL and PL / SQL Interview Questions-II
SQL and PL / SQL Interview Questions-III
Test case writing
Testing Interview questions
Software Test Documents
Configuration Management
Software Testing Guide
Unit Testing
Selenium tool
Test Management
Manual Testing Questions & Answers Part-II
Manual Testing Questions and Answers Part-I
Software Test Methods
Requirement Management Tools
Requirements Management
 Rational Robot
 An Introduction to Quality Center
 An Introduction to LoadRunner  
Performance Testing  
Usability Testing
CMM Levels Vs ISO Standards
Agile methodology
Test Design Techniques  
ISTQB Certification Model questions
Test plan
Performance Test Plan
Use Case template  
web dictionary
Static Testing
Web testing guidelines 
Database tutorial
Certification Model questions
Software Quality Standards
ISTQB Certification Guidelines
Database Testing
Quality Assurance

Agile Record issue 2

NEWSLETTER
	The first printed issue of the Agile Record is out now! If you haven’t register yet, you can still do so and we will send you the next issue. I want to thank all the authors for their articles and columns. Please register here: www.agilerecord.com/subscribe.php Please download the issue from www.agilerecord.com/agilerecord_02.pdf I would really appreciate if you could forward this information to all your colleagues and interested contacts. Best regards José Díaz Editor
	Managing the Testing Process 3-day training course by Rex Black June 09 to 11, 2010 in Bad Homburg, Germany Test managers must take a potentially infinite job—testing a computer system—and accomplish it within tight time and resource restraints. It’s a tall order, but successful test managers have found proven ways to handle the challenges. This course will give attendees the tools they need to succeed as test managers. We’ll look at quality risk analysis, test estimation, and test planning. We’ll discuss developing high-quality test systems—test cases, test data, test tools, even automated test systems— that improve over time. We’ll talk about tracking bugs and test cases. We’ll discuss ways to derive and present metrics, charts, and graphs from the test results. We’ll also cover the human side of test management. We’ll look at ways to measure and manage the skills testers need. We’ll discuss hiring testers. We’ll talk about education and certification for testers. We’ll examine some ways to motivate and reward testers— and some ways not to! We’ll cover working effectively within the project organization, which is especially challenging when you’re the bearer of bad news. We’ll also look at the context of testing. We’ll discuss system development lifecycles and how they affect testing. We’ll cover testing as an investment. We’ll finish up by discussing test labs, test environments, and hardware issues. The materials presented in the course follow Rex Black’s book, Managing the Testing Process, which is the distillation of over two decades of software, hardware, and systems experience. www.agilerecord.com/knowledge_transfer.html
	Testing & Finance 2010 The Conference for Testing & Finance Professionals June 7th - 8th, 2010 in Bad Homburg (near Frankfurt am Main, Germany) Keynotes by Nitin Bhargava – Barclays Bank, UK BJ Rollison – Microsoft Corp Gernot Nolte – Fiducia Prof. Dr. Schulte-Mattler – Fachhochschule Dortmund Rex Black – RBCS Conference 4 tracks 46 speeches product fair full catering free internet access social event www.testingfinance.com
	Agile Testing Days 2010 October 04-07, 2010 in Berlin The Agile Testing Days is the European conference for the worldwide professionals involved in the agile world. We are very proud to count on the support and the work of Lisa Crispin, Michael Bolton, Janet Gregory, Linda Rising, Jennitta Andrea, Anko Tijman, Eric Jimmink, Stuart Reid, Isabel Evans, Elisabeth Hendrickson, Pekka Klärck, Juha Rantanen, Janne Härkönen and Brett Schuchert. We chose Berlin, one of the best-connected capitals in Europe to host this event due to the affordability/service ratio for hotels and flights. Berlin also offers a lot of fabulous sights to visit in your spare time. Please have a look at the program ( download the PDF file) and enjoy the conference! www.agiletestingdays.com
	OZ Agile Days 2010 - Call for Papers - the Australian conference for the professionals involved in the agile world (November 22 - 24, 2010 in Sydney, Australia) using our template at www.ozagile.com until May 30, 2010 to papers@ozagile.com

Agile Testing Days 2010

Dear Hemanth Bolem,

 

we are very proud to present the program for the Agile Testing Days 2010!

The Agile Testing Days will take place in Berlin, on the 4^th – 7^th of October 2010.

 

It was an honor to rely on Alessandro Collino as Program Chair, who set up the conference.

 

On October 4^th we have the tutorial of

1.    Lisa Crispin, Making Test Automation Work on Agile Teams

2.    Michael Bolton, A Rapid Introduction to Rapid Software Testing

3.    Janet Gregory, A Tester’s Guide to Navigating an Iteration

4.    Linda Rising, Patterns for Improved Customer Interaction & Influence Strategies for Practitioners

5.    Jennitta Andrea, The Foundations of Agile Software Development

6.    Anko Tijman & Eric Jimmink, Testing2.0 – agile testing in practice

7.    Stuart Reid & Isabel Evans, Managing Testing in Agile Projects

8.    Elisabeth Hendrickson, Agile Transitions

9.    Pekka Klärck, Juha Rantanen & Janne Härkönen, Executable Requirements in Practice

 

40 Talks, 9 Keynotes and an Open Space are waiting for you.

 

They keynote speakers are:

 

·        Lisa Crispin ·        Linda Rising ·        Elisabeth Hendrickson ·        Michael Bolton ·        Stuart Reid ·        Janet Gregory ·        Isabel Evans ·        Jennitta Andrea ·        Tom Gilb

 

The Open Space on October 7^th is hosted by Brett Schuchert.

 

We want to thank all the tutorial speakers, keynote speakers, speakers, sponsors and people involved in this event for their hard work and support.

 

Please have a look at the program at www.agiletestingdays.com

 

The early bird ends on June 30^th, 2010. Don’t miss it!

 

I would really appreciate if you could forward this information on to all your colleagues and interested contacts.

 

Best regards

 

José Díaz

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

José M. Díaz Delgado
Managing Director

Díaz & Hilterscheid Unternehmensberatung GmbH
Kurfürstendamm 179
10707 Berlin

Telefon: +49 (0)30 74 76 28 – 0
Telefax: +49 (0)30 74 76 28 - 99

Internet:
www.diazhilterscheid.de

Email:
jose.diaz@diazhilterscheid.de

© Díaz & Hilterscheid Unternehmensberatung GmbH

José M. Díaz Delgado - Geschäftsführer, Julia Hilterscheid - Geschäftsführerin, Marc Ahlbach - Geschäftsführer

Ust-IdNr. DE195661616, Amtsgericht Berlin Charlottenburg HRB 67896

Internet: www.diazhilterscheid.de

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

 

If you don't want to receive information from Díaz & Hilterscheid please send an email with the subject "unsubscribe". We apologise for the trouble caused. This message was sent to hemanthbolem@gmail.com.

SQL Queries

SQL Queries

Create the following Tables: 

LOCATION
Location_ID	Regional_Group
122	NEW YORK
123	DALLAS
124	CHICAGO
167	BOSTON

 

DEPARTMENT
Department_ID	Name	Location_ID
10	ACCOUNTING	122
20	RESEARCH	124
30	SALES	123
40	OPERATIONS	167

 
 

JOB
Job_ID	Function
667	CLERK
668	STAFF
669	ANALYST
670	SALESPERSON
671	MANAGER
672	PRESIDENT

 
 
 

EMPLOYEE
EMPLOYEE_ID	LAST_NAME	FIRST_NAME	MIDDLE_NAME	JOB_ID	MANAGER_ID	HIREDATE	SALARY	COMM	DEPARTMENT_ID
7369	SMITH	JOHN	Q	667	7902	17-DEC-84	800	NULL	20
7499	ALLEN	KEVIN	J	670	7698	20-FEB-85	1600	300	30
7505	DOYLE	JEAN	K	671	7839	04-APR-85	2850	NULL	30
7506	DENNIS	LYNN	S	671	7839	15-MAY-85	2750	NULL	30
7507	BAKER	LESLIE	D	671	7839	10-JUN-85	2200	NULL	40
7521	WARK	CYNTHIA	D	670	7698	22-FEB-85	1250	500	30

 
 

Queries based on the above tables: 

Simple Queries: 

1. List all the employee details
2. List all the department details
3. List all job details
4. List all the locations
5. List out first name,last name,salary, commission for all employees
6. List out employee_id,last name,department id for all  employees and rename employee id as "ID  of the employee", last name as "Name of the employee", department id as  "department  ID"
7. List out the employees anuual salary with their names only. 

Where Conditions: 

8. List the details about "SMITH"
9. List out the employees who are working in department 20
10. List out the employees who are earning salary between 3000 and 4500
11. List out the employees who are working in department 10 or 20
12. Find out the employees who are not working in department 10 or 30
13. List out the employees whose name starts with "S"
14. List out the employees whose name start with "S" and end with "H"
15. List out the employees whose name length is 4 and start with "S"
16. List out the employees who are working in department 10 and draw the salaries more than 3500
17. list out the employees who are not receiving commission. 

Order By Clause: 

18. List out the employee id, last name in ascending order based on the employee id.
19. List out the employee id, name in descending order based on salary column
20. list out the employee details according to their last_name in ascending order and salaries in descending order
21. list out the employee details according to their last_name in ascending order and then on department_id in descending order. 

Group By & Having Clause: 

22. How many employees who are working in different departments wise in the organization
23. List out the department wise maximum salary, minimum salary, average salary of the employees
24. List out the job wise maximum salary, minimum salary, average salaries of the employees.
25. List out the no.of employees joined in every month in ascending order.
26. List out the no.of employees for each month and year, in the ascending order based on the year, month.
27. List out the department id having atleast four employees.
28. How many employees in January month.
29. How many employees who are joined in January or September month.
30. How many employees who are joined in 1985.
31. How many employees joined each month in 1985.
32. How many employees who are joined in March 1985.
33. Which is the department id, having greater than or equal to 3 employees joined in April 1985. 

Sub-Queries 

34. Display the employee who got the maximum salary.
35. Display the employees who are working in Sales department
36. Display the employees who are working as "Clerk".
37. Display the employees who are working in "New York"
38. Find out no.of employees working in "Sales" department.
39. Update the employees salaries, who are working as Clerk on the basis of 10%.
40. Delete the employees who are working in accounting department.
41. Display the second highest salary drawing employee details.
42. Display the Nth highest salary drawing employee details 
    

Sub-Query operators: (ALL,ANY,SOME,EXISTS) 

43. List out the employees who earn more than every employee in department 30.
44. List out the employees who earn more than the lowest salary in department 30.
45. Find out whose department has not employees.
46. Find out which department does not have any employees. 

Co-Related Sub Queries: 

   47.Find out the employees who earn greater than the average salary for their department.

Joins

Simple join 

   48.List our employees with their department names

   49.Display employees with their designations (jobs)

   50.Display the employees with their department name and regional groups.

   51.How many employees who are working in different departments and display with department name.

   52.How many employees who are working in sales department.

   53.Which is the department having greater than or equal to 5 employees and display the department names in ascending order.

   54.How many jobs in the organization with designations.

   55.How many employees working in "New York". 

Non – Equi Join: 

   56.Display employee details with salary grades.

   57.List out the no. of employees on grade wise.

  58.Display the employ salary grades and no. of employees between 2000 to 5000 range of salary. 

Self Join: 

   59.Display the employee details with their manager names.

   60.Display the employee details who earn more than their managers salaries.

   61.Show the no. of employees working under every manager. 

Outer Join: 

   61.Display employee details with all departments.

   62.Display all employees in sales or operation departments.  

Set Operators: 

   63.List out the distinct jobs in Sales and Accounting Departments.

   64.List out the ALL jobs in Sales and Accounting Departments.

  65.List out the common jobs in Research and Accounting Departments in ascending order. 

Answers 

1. SQL > Select * from employee;
2. SQL > Select * from department;
3. SQL > Select * from job;
4. SQL > Select * from loc;
5. SQL > Select first_name, last_name, salary, commission from employee;
6. SQL > Select employee_id "id of the employee", last_name "name", department id as "department id" from employee;
7. SQL > Select last_name, salary*12 "annual salary" from employee
8. SQL > Select * from employee where last_name='SMITH';
9. SQL > Select * from employee where department_id=20
10. SQL > Select * from employee where salary between 3000 and 4500
11. SQL > Select * from employee where department_id in (20,30)
12. SQL > Select last_name, salary, commission, department_id from employee where department_id not in (10,30)
13. SQL > Select * from employee where last_name like 'S%'
14. SQL > Select * from employee where last_name like 'S%H'
15. SQL > Select * from employee where last_name like 'S___'
16. SQL > Select * from employee where department_id=10 and salary>3500
17. SQL > Select * from employee where commission is Null
18. SQL > Select employee_id, last_name from employee order by employee_id
19. SQL > Select employee_id, last_name, salary from employee order by salary desc
20. SQL > Select employee_id, last_name, salary from employee order by last_name, salary desc
21. SQL > Select employee_id, last_name, salary from employee order by last_name, department_id desc
22. SQL > Select department_id, count(*), from employee group by department_id
23. SQL > Select department_id, count(*), max(salary), min(salary), avg(salary) from employee group by department_id
24. SQL > Select job_id, count(*), max(salary), min(salary), avg(salary) from employee group by job_id
25. SQL > Select to_char(hire_date,'month')month, count(*) from employee group by to_char(hire_date,'month') order by month
26. SQL > Select to_char(hire_date,'yyyy') Year, to_char(hire_date,'mon') Month, count(*) "No. of employees" from employee group by to_char(hire_date,'yyyy'), to_char(hire_date,'mon')
27. SQL > Select department_id, count(*) from employee group by department_id having count(*)>=4
28. SQL > Select to_char(hire_date,'mon') month, count(*) from employee group by to_char(hire_date,'mon') having to_char(hire_date,'mon')='jan'
29. SQL > Select to_char(hire_date,'mon') month, count(*) from employee group by to_char(hire_date,'mon') having to_char(hire_date,'mon') in ('jan','sep')
30. SQL > Select to_char(hire_date,'yyyy') Year, count(*) from employee group by to_char(hire_date,'yyyy') having to_char(hire_date,'yyyy')=1985
31. SQL > Select to_char(hire_date,'yyyy')Year, to_char(hire_date,'mon') Month, count(*) "No. of employees" from employee where to_char(hire_date,'yyyy')=1985 group by to_char(hire_date,'yyyy'),to_char(hire_date,'mon')
32. SQL > Select to_char(hire_date,'yyyy')Year, to_char(hire_date,'mon') Month, count(*) "No. of employees" from employee where to_char(hire_date,'yyyy')=1985 and to_char(hire_date,'mon')='mar' group by to_char(hire_date,'yyyy'),to_char(hire_date,'mon')
33. SQL > Select department_id, count(*) "No. of employees" from employee where to_char(hire_date,'yyyy')=1985 and to_char(hire_date,'mon')='apr' group by to_char(hire_date,'yyyy'), to_char(hire_date,'mon'), department_id having count(*)>=3
34. SQL > Select * from employee where salary=(select max(salary) from employee)
35. SQL > Select * from employee where department_id IN (select department_id from department where name='SALES')
36. SQL > Select * from employee where job_id in (select job_id from job where function='CLERK'
37. SQL > Select * from employee where department_id=(select department_id from department where location_id=(select location_id from location where regional_group='New York'))
38. SQL > Select * from employee where department_id=(select department_id from department where name='SALES' group by department_id)
39. SQL > Update employee set salary=salary*10/100 wehre job_id=(select job_id from job where function='CLERK')
40. SQL > delete from employee where department_id=(select department_id from department where name='ACCOUNTING')
41. SQL > Select * from employee where salary=(select max(salary) from employee where salary <(select max(salary) from employee))
42. SQL > Select distinct e.salary from employee where & no-1=(select count(distinct salary) from employee where sal>e.salary)
43. SQL > Select * from employee where salary > all (Select salary from employee where department_id=30)
44. SQL > Select * from employee where salary > any (Select salary from employee where department_id=30)
45. SQL > Select employee_id, last_name, department_id from employee e where not exists (select department_id from department d where d.department_id=e.department_id)
46. SQL > Select name from department d where not exists (select last_name from employee e where d.department_id=e.department_id)
47. SQL > Select employee_id, last_name, salary, department_id from employee e where salary > (select avg(salary) from employee where department_id=e.department_id)
48. SQL > Select employee_id, last_name, name from employee e, department d where e.department_id=d.department_id
49. SQL > Select employee_id, last_name, function from employee e, job j where e.job_id=j.job_id
50. SQL > Select employee_id, last_name, name, regional_group from employee e, department d, location l where e.department_id=d.department_id and d.location_id=l.location_id
51. SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name
52. SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name having name='SALES'
53. SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name having count (*)>=5 order by name
54. SQL > Select function, count(*) from employee e, job j where j.job_id=e.job_id group by function
55. SQL > Select regional_group, count(*) from employee e, department d, location l where e.department_id=d.department_id and d.location_id=l.location_id and regional_group='NEW YORK' group by regional_group
56. SQL > Select employee_id, last_name, grade_id from employee e, salary_grade s where salary between lower_bound and upper_bound order by last_name
57. SQL > Select grade_id, count(*) from employee e, salary_grade s where salary between lower_bound and upper_bound group by grade_id order by grade_id desc
58. SQL > Select grade_id, count(*) from employee e, salary_grade s where salary between lower_bound and upper_bound and lower_bound>=2000 and lower_bound<=5000 group by grade_id order by grade_id desc
59. SQL > Select e.last_name emp_name, m.last_name, mgr_name from employee e, employee m where e.manager_id=m.employee_id
60. SQL > Select e.last_name emp_name, e.salary emp_salary, m.last_name, mgr_name, m.salary mgr_salary from employee e, employee m where e.manager_id=m.employee_id and m.salary<e.salary
61. SQL > Select m.manager_id, count(*) from employee e, employee m where e.employee_id=m.manager_id group by m.manager_id
62. SQL > Select last_name, d.department_id, d.name from employee e, department d where e.department_id(+)=d.department_id
63. SQL > Select last_name, d.department_id, d.name from employee e, department d where e.department_id(+)=d.department_id and d.department_idin (select department_id from department where name IN ('SALES','OPERATIONS'))
64. SQL > Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name='SALES')) union Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name='ACCOUNTING'))
65. SQL > Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name='SALES')) union all Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name='ACCOUNTING'))
66. SQL > Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name='RESEARCH')) intersect Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name='ACCOUNTING')) order by function