A new Job, ID: 312659 <http://www.ejobsville.com/display-job/312659> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://www.ejobsville.com/>
Title: : Quality Assurance/Tester,polk county,Iowa (390903) posted on 2014-12-12 13:37:35 Job Description:*Title/Role : * *Quality Assurance/Tester (390903)* * Location : Polk County, IOWA* * Duration : 6 months* *Interview : In Person Only* *Description:* *Short description:* The Quality Assurance/Tester (QAT) is responsible for the design, pilot, and implementation of the software quality assurance review processes. *Complete description:* Will be testing ETL-SSIS packages against a back end SQL Server Database Will be coordinating efforts with the DBA team - assisting the DBA's with testing *Responsibilities:* ** *Review functional and design specifications to ensure full understanding of individual deliverables. * Backend database testing in Microsoft SQL environment, duties including: * Designing and manipulating test data to fit test cases * Validating SSIS packages, stored procedures, jobs and triggers. * Perform ETL testing. * Identify test requirements from specifications, map test case requirements and design test coverage plan. * Develop, document and maintain functional test cases and other test artifacts like the test data, data validation, harness scripts and automated scripts. * Execute and evaluate manual or automated test cases and report test results. * Hold and facilitate test plan/case reviews with cross-functional team members. * Ensure that validated deliverables meet functional and design specifications and requirements. * Isolate, replicate, and report defects and verify defect fixes. - Test Case creation from Business Requirements - identify all possible scenarios - Create data when needed to fit particular testing situations (may be loaded using Excel or SQL statements, Visual Studio). Data may be supplied by Business Liasion or already available as well. - Data Validation after a process has ran - possibly executing scripts or scheduled task to generate the action - File loading to a table - has the table been updated as defined from the raw data in file - Pulling data from a file to pass elsewhere - is the file format (XML, delimited, etc) correct as described), did the target receive the file correctly - Defect logging will facilitate workflow and track progress The candidate doesn't need to know SSIS syntax necessarily, but typical data tools/methods would be used to accomplish the testing. Our immediate need is for SSIS package testing, but future projects could include other ETL tools but would require the same or similar testing methods as described above. *CLIENT LOOKING BELOW SKILLS:* Expert in SQL Queries - ability to write SQL to query data across multiple versions of SQL Server Read and interpret SSIS packages Experience in testing ETL processes Experience in testing of data warehouse environments with large amounts of data Experience writing test documentation such as test plans, scripts and test results reports Ability to analyze/interpret test results and provide recommendations to improve testing Experience with manual testing Issue Management - seeing them through bug fix and re-testing *Click here to view full job description and apply <http://www.ejobsville.com/display-job/312659> (Registration not mandatory to apply for this job)* ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-source-erp-crm+unsubscr...@googlegroups.com. To post to this group, send email to open-source-erp-crm@googlegroups.com. Visit this group at http://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
