Data Integration Quality Assurance Analyst Job in San Antonio 78216, Texas Us
Responsible for planning, reviewing, testing and validation of integrations for data management systems. Works closely with BI and ETL development teams to ensure data integrity and continuous product improvement. Responsibilities include interaction with developers and end users to develop and execute test strategies for ETL testing of highly complex, high volume, data warehousing initiatives. Ability to test complex transformations and mappings. Responsible for technical architecture and optimization/performance testing using SQL backend services running on high-availability Microsoft infrastructure. Middleware includes Java/J2EE, .NET, Struts, Hibernate and Spring. The Data Quality Assurance Analyst must be able to work independently, developing and executing test cases including writing complex SQL queries in most phases of database analysis.
Develops, publishes, and implements test plans. Writes, maintains, and executes manual and automated test cases/scripts in ALM. Develops, implements, and supports quality assurance standards. Defines and tracks quality assurance metrics such as defect densities and open defect counts. Uses SQA (Software Quality Assurance) methodologies, techniques and tools. Validates test data and results by developing appropriate queries and utilities. Assumes additional responsibilities as assigned.
· Actively leads efforts that encourage equitable problem resolution and improved working relationships.
· Promotes and champions individual growth within the organization.
· Stands out as a role model for others through daily interaction and leadership example and as a resource for other team members.
· Validation, verification and enforcement of quality assurance measures and testing standards for developing applications, vendor software, new hardware or configuration changes throughout the development or project lifecycle.
· Develop and apply established metrics to determine the readiness, quality, and operability of software, hardware, or systems due for release to clients and/or within the enterprise.
· Ensure that software quality measures comply with regulatory standards, industry standards, and accepted best practices.
· Develop, write and execute test plans and scripts for identifying and tracking defects and fixes in product development, software application development, information systems, and operations systems.
· Direct and support the implementation and ongoing use of test tools and data collection tools.
· Prepares project test reports and metrics as necessary.
· Demonstrated ability to establish and maintain effective, trusting relationships with department directors, managers, administrators, vendors and others.
· Demonstrates fiscal responsibility with all Company assets.
Education:
· Bachelor’s Degree in Computer Science, Management Information Systems, or technical area, or the equivalent combination of education and experience
Experience:
· Four plus (4+) years minimum Data Quality and Integration testing experience, with proficiency in XML and SQL (including writing queries for complex joins and unions) in a SQL Server Environment
· Conceptual knowledge of data warehouse architectures, ETL architectures and BI UI architectures.
· Two plus (2+) years testing experience with Tibco ESB
· Understanding of data rollups/aggregation, capacity planning, data standardization, slowly changing dimensions and data security
· Experience developing data integration testing strategy and approaches, including means of reconciling with source data.
· Demonstrated data exploration/data profiling skills; ability to uncover data quality and data integration challenges, and develop solutions.
· Level 3: 6+ years of High Volume Web Services (High Traffic/High Transaction), Windows environment, Java/J2EE, MS SQL, Service Oriented Architecture (SOA), DataStage ETL
· All Levels: Substantial projects in Java or .NET
· Three plus (3+) years of recent experience as a QA/SQA analyst/engineer in software quality assurance testing
· Three plus (3+) years experience in designing, developing, executing and documenting results of manual and automated test cases
· Three plus (3+) years experience in planning, developing, and implementing automation frameworks.
· Load and performance test plan and test case development preferred
· Three plus (3+) years experience with the use of Quality Assurance tools for test planning, test case development, defect tracking and automation
· Restaurant or retail systems experience preferred
· JDE Enterprise-One ERP system experience preferred
· Formal training and experience with enterprise testing tools including automated execution and performance tools
· Formal training in Quality Management methodologies and techniques
· Two plus (2+) of Visual Basic (Vb) scripting preferred
· Three plus (3+) years experience in designing, developing, executing and documenting results of manual and automated test cases
· Three plus (3+) years experience in planning, developing, and implementing automation frameworks.
· Load and performance test plan and test case development preferred
· Three plus (3+) years experience with the use of Quality Assurance tools for test planning, test case development, defect tracking and automation
· Restaurant or retail systems experience preferred
· JDE Enterprise-One ERP system experience preferred
· Formal training and experience with enterprise testing tools including automated execution and performance tools
· Formal training in Quality Management methodologies and techniques
· Two plus (2+) of Visual Basic (Vb) scripting preferred
Professional Certification:
· Preference given to: Certified International Software Testing Qualifications Board (ISTQB); Certified Associate in Software Quality (CASQ); Certified Associate in Software Testing (CAST); Certified Software Business Analyst (CSBA); Certified Software Process Engineer (CSPE); Certified Quantitative Software Process Engineer (CQSPE)
Working Conditions/Travel Requirements:
· Exempt employees are expected to work the necessary time to satisfactorily fulfill job responsibilities
· Working conditions exist to satisfactorily fulfill job responsibilities
· Must be able to travel occasionally