Vacancy caducado!
- The Quality Assurance Analyst is a position on the Quality Assurance (QA) Team within Operational Excellence department of Gas Technology Services.
- Operational Excellence focuses on continuous improvement of operational performance and risk mitigation for Gas application architecture, data, and quality.
- The QA Team provides service offerings under a Center of Excellence operating model.
- Service offerings leverage repeatable, centralized processes to support business unit objectives via project delivery methodologies.
- This position can report into either the Atlanta, GA or Naperville, IL corporate offices.
- Occasional travel for collaborative meetings may be required.
- The ideal candidate will be highly analytical, have strong technical skills, be detail and process oriented, and thrive on problem solving in a fast-paced environment.
- At a high level, the position focuses on System Integration Test Planning & Text Execution which requires both functional knowledge and technical skills to plan and prepare for testing, execute the tests, and validate test results; and Baseline /Regression testing techniques which requires strong functional, technical, and analytical skills.
- Author detailed test plans including definition of scenarios to be tested and test preparations needed including SQL’s to validate data existence and to validate eventual test results.
- In addition to scenario and data planning, Test Planning includes determination of testing approach (including test planning for test automation), testing timelines, resources/estimates, the technical aspects of environment preparations, identification of batch execution scope & schedules, and identification of data management (backups/restore points).
- Test Planning may require authoring test scripts (step by step test execution instructions, including the definition of expected test results)
- Completion of Test Preparations may include identification of specific data to be used for testing, creation or edit of batch input files and/or update of test data to ensure breadth of data scenarios.
- May be requested to review and provide input on Test Plans written by others
- May be consulted on testing approach / testing techniques
- May be consulted on SQL’s / data analysis
- May be consulted on job scheduling and job scheduling setup
- Environment preparations, including data repairs and staging batch input files
- Data Management including back-ups as certain point per the Test Plan & restores to repeat testing
- Test Execution utilizing multiple testing techniques and tools
- Verification of functional test plans and execution of tests with collaboration across teams and functional workgroups
- Batch execution including defect creation for issues encountered and initial troubleshooting of any abends
- Capture of testing metrics / SQL’s / functional results – both Baseline & Regression
- Utilization of various tools (advanced Excel functions, Beyond Compare) to compare Baseline / Regression metrics and/or flat files
- Conduct discrepancy analysis to assess Baseline/Regression differences
- Test Results deliverable preparation and presentation
- Periodic build of an Intelligent Testbed requires strong functional knowledge and SQL skills to enhance an existing suite of SQL’s which identify the widest breadth of data scenarios within the leanest volume of data.
- Data management practices utilizing multiple tools and techniques
- Environment Management recommendations (planning environment setup to ensure DEV/TST environments represent production) including support for configuration management processes
- Environment support, including working with other technical staff (like DBA’s) to resolve issues
- Identification and implementation of process improvements across all testing practices
- Bachelor’s Degree is required, a degree in Computer Science/Engineering or related is preferred
- 10+ years of IT applications related experience of which at least 7 years focused in SQA/Testing
- Proven hands-on experience testing applications/platforms as well as utilization of test management tools
- Proven experience with testing large scale, configurable, vendor applications
- Proven experience authoring Test Plans for multiple types of testing stages
- Proven experience testing using a variety of testing techniques including testing in both agile and waterfall methodologies, including but not limited to feature testing, system integration testing, and regression testing
- Experience with Data Analysis to research Baseline / Regression discrepancies
- Experience with developing, documenting, implementing, and improving processes
- Experience testing in a highly integrated, complex application landscape
- Experience with trouble-shooting to research and resolve batch execution problems
- Exposure to Environment Management concepts including both planning and scheduling;
- ideally with hands-on experience coordinating all layers of components within environments
- Understanding backup/restore concepts including maintaining documentation on which backups contain what content so that input on which backup to restore can be provided
- Experience with defect prevention practices such as consulting with development team members as code is designed and built (i.e. incorporating code scanning techniques within the quality assurance process)
- Project Management experience a plus
- Experience with Test Data Management including planning testbed content, ensuring testbed coverage, and scheduling/coordinating periodic testbed refresh processes
- SQL Fluent: Strong SQL skills with the ability to understand and author complex table joins
- Demonstrated analytical / critical thinking and technical trouble-shooting skills
- Technical skills to mock-up data (flat file prep and/or SQL data updates)
- Experience with file/comparison tool(s)
- Excel power user: especially with using advanced Excel functions for data lookups and comparisons, and fluent in the use of pivot tables.
- Effective communication (verbal/written), Customer Service focused
- Ability to build productive relationships with a focus on cooperation and teamwork
- Experience with Unix/Linux and Windows environments
- Process oriented, detail oriented, and quality focused
- Functional knowledge of Oracle’s Customer Care & Billing (CC&B) application
- Technical knowledge of Oracle’s Customer Care & Billing (CC&B) schema, data, & configuration management
- Experience with Optim – for both for data management and data comparisons
- Experience with Beyond Compare
- Experience with job scheduling software, Control-M preferred, AutoSys a plus
- Excel experience utilizing VBA/Macros is a plus.
- Knowledge of relational database components (packages, stored procedures, triggers, views, etc)
- Knowledge of Configuration and code version control tools and deployment processes is a plus
- Exposure to test automation toolsets – ideally experience with the Tricentis test automation platform is a plus
Vacancy caducado!