Technology Consultant I

With general guidance and coaching, participates in developing and executing test scenarios for unit, process, function, system integration and acceptance testing. Develops test cases, scenarios and scripts to ensure applications quality. Designs and develops usability testing scenarios, and administers portions of testing process. Defines criteria for testing, analyzes results of testing sessions and presents results. Participates in selection of testing tools and approaches. Utilizes appropriate testing tools and testing processes on projects and assists in building test environments. .

Top Five Skills/Experience (Skills/Experience levels must be within the last five to seven years)

  1. 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.)
  2. 5+ years experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing

a. 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.

  1. Analytical ability to review and understand both business requirements and data to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the “testability” of requirements, and creating a comprehensive test plan that supports the business and technological solutions being delivered
  2. Extensive knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data Capture (CDC), and relational and dimensional data modeling techniques.
  3. 2-3 years strong...