Previous Job
QA - SQL & Pega - Irving, TX
Ref No.: 17-03131
Location: Irving, Texas
Job Title                     : QA - SQL & Pega
Location                     : Irving, TX
Position Type             : 
Rate                            : W2 or 1099
US Citizen, Green Card, GC EAD and TN (Not for H1b or OPT EAD).
No 3'rd party C2C.

Skills Required:
  • 7+ years of real time experience in writing complex SQL queries, understanding the view,constraints,stored proceduresand debugging the queries/stored procedure.
  • Experience with Pega.
  • Strong SQL Skills, Joins, minus queries, understanding of datawarehouse testing.
  • 7+ years of experience in ETL,Informatica, Oracle, PL/SQL.
  • Understanding of data-modeling concepts(Entity Relationship,Multi-dimensional).
  • Understanding of data-warehousing/ETL concepts.
  • Should have expertise on ETL Tools like Informatica,SSIS etc.
  • Knowledge of comparing source data against target data via (SQL Server) in source and target for both full and incremental loads.
  • Development and integration which includes setting up configuration management, developing components, peer review, creating unit test plans and performing unit testing.
  • Writing unit tests (software testing method)
  • This person would be responsible for creating test scripts for a backend application. Expectations are that the qualified candidate will have a development background and education, familiar with SQL/Oracle, who is open to doing automation development.They need a senior level candidate that has a background and experience testing backend applications. This resource will need to understand and have experience within ETL/SQL.
  • Willingness to learn with attention to details.
  • Experience in leading teams in delivering end-to-end solutions.
  • Demonstrated experience in testing Java, .net and C++ applications and PEGA Smart Dispute development/testing experience.
  • Develop automation scripts in Selenium, Soap UI, REST API, REST API for Web Service testing.
  • Experience testing on web-based software applications in large enterprises, and familiarity with Selenium.
  • Automation experience (ability to implement automation framework)
  • 5+ years' experience creating and executing test plans, and test cases/scripts from scratch.
  • Worked in an Agile environment and/or on a SCRUM preferred.
  • 7 years Demonstrated experience in Quality Assurance testing, writing and executing test plans; using testing tools (QTP, Selenium) plus experience in testing with Agile/Iterative development.
  • Demonstrated experience with bug tracking tools such as JIRA, Bugzilla.
  • Must be adequately proficient in Automation implementation, scripting, script reviews, importing automation skill to team members (QTP, Selenium, Java)
  • Develop test automation scripts in Selenium UFT along with maintaining and enhancing the automated test framework supporting a continuous integration environment with automated smoke and regression testing.
  • Continuous Integration Testing with Jenkins, TestNG, and well versed with SQL queries; proficient in SQL, Oracle, SQL Server.
  • Strong English communication skills, written and verbal.
  • Ability to handle multiple tasks/subprojects simultaneously, organizational skills plus work with remote team; takes initiative in handling issues that arise during testing.
  • Experience using XML.
  • Ensure high test and code coverage with custom coding, maintainability of scripts, reliability of equipment tools, and overall robustness of testing efforts.