QA Analyst,Detroit, MI - Georgia IT Inc.
Detroit, MI
About the Job
Job Position : QA Analyst
Job Location : Detroit, MI
Job Type : Contract(12 months)
US Citizen/ GC /EAD (H4/L2/TN) preferred- No 3rdPARTIES RESUME C2C ACCEPTED
Job Description
5+ years experience writing complex SQL queries (NOTE: Resumes must specify specific SQL concepts to ensure candidate is truly experienced with writing complex SQL queries.)
5+ years experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing
o QA Testing experience must be in both manual and automated testing environments, with a strong focus in both as manual testing experience is required to create the automated test cases and SQL statements. Automated testing experience should be with IBM Rational Tools.
Extensive knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data Capture (CDC), and relational and dimensional data modeling techniques.
5+ years experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment. Candidates are expected to be able to analyze testing results to ensure accuracy when compared to requirements and to determine potential errors when expected and actual testing results to not align.
2+ years current experience with the following Rational Tools
5+ years Oracle experience
3+ Years experience with Unix
Advanced knowledge of MS Office suite tools required with a focus on advanced knowledge of Microsoft Excel for the purpose of creating test grids and using formulas to compare test results.
Ability to convert requirements documents (Business Requirements, Functional and Technical Requirements) into test strategies/plans, test scenarios and test cases, including appropriate SQL scripts to execute testing cases.
Ability to evaluate the "testability of requirements and reports to project team member's changes or additional information needed in requirements
Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.) and create a comprehensive test plan that supports the business and technological solutions being delivered
Ability to coordinate test execution across multiple teams
Defect tracking experience (i.e. ClearQuest or Client Service Center)
Experience in tuning SQL queries for performance improvements
Source : Georgia IT Inc.