Required Skills

QA with SQL Server

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 2nd Sep 2021

JOB DETAIL

* Webcam interview.** Initial PO for 12 months; usually projects with this customer goes for 3+ years *** Initial remote due to covid then onsite.

"At issue is the level of experience with database testing, i.e., stored procedures, SQL jobs, and SSIS packages. We have a question in the interview that asks candidates to list different types of database objects that they are familiar with along with their experience executing tests on them. I would like to add to the job description indicating that this is a requirement. We are searching for a candidate for a specific team. This experience is required to be successful in this role."

Remote for now and then on-site to the extent that we support on-site work (we are 100% remote now and anticipate 1 day every other week in future). Any non local submissions must be willing to relocate. Strongly prefer local resources. 

50% - Develop test plans/scenarios/cases/scripts to ensure appropriate test coverage. Provide direction to developers to implement solutions per requirements. Execute testing based upon documented test cases/scripts and ensure applications tested meet customer defined business requirements per documented user acceptance criteria. Conduct user acceptance testing with end users to ensure implemented solution meets expectations. Document and track software defects as well as issues with performance and usability.

30% - Identify, evaluate, and document business needs and objectives, operational processes and procedures, problems and requirements. Understand the business case, and gaps in documented business process (as is vs. to be). Perform requirements elicitation/documentation/management, as well as use case documentation (standard, alternate, and error) to assist developers in creation of solutions to meet business objectives. Leverage understanding to document meaningful user acceptance criteria for user stories. Capable of facilitating communication between stakeholders from all levels of the organization while objectively identifying and resolving conflict.

20% - Identify and document processes and procedures related to Business Analysis and Quality Assurance standards, including opportunities for improvement. Prepare release documentation in advance of production deployment. Identify candidates for test automation, document test flow and data requirements/dependencies, and implement using approved tools.

  • Windows Server Experience
  • 5 years experience
  • Intermediate SQL Server/Database Testing Experience (Tables/Views, Stored Procedures)
  • Intermediate Test Strategy, Test Data Preparation/Management Experience
  • SSIS
  • ETL
  • Intermediate SDLC - Agile (Scrum, Kanban) Experience
  • Intermediate STLC - Agile Testing Experience
  • Intermediate MS Office (Word, Excel, PowerPoint, Access) Experience
  • Database Testing Experience (Indexes, Triggers, SQL Jobs)
  • Business Intelligence, ETL, and Reporting Testing Experience (Tableau, SSIS, SSRS)
  • Automation Testing Experience (UI - Selenium; Web Services - Postman, SoapUI; Load/performance - Jmeter)
  • Intermediate TFS/VSTS/Azure DevOps Experience (Agile lifecycle model, test/defect management)

Company Information