Quality Assurance Analyst chez Florida Government Agency
Florida Government Agency · Tallahassee, États-Unis d'Amérique · Onsite
- Professional
- Bureau à Tallahassee
Client: Fl Government Agency
Position: Quality Assurance Analyst
Term: Nov 2025 - June 2026 with at a minimum 1-year renewal
Pay: $60 - $62/Hr
Location: 100% ON SITE - Tallahassee, Florida 32399
Work Authorization: US or GC only and only W2 no C2c or 1099
Education: A bachelor's degree from an accredited college or university in Computer Science, Information Systems, Technical Writing, Business Administration, or related field or five (5) years of equivalent work experience is required.
Preferred Certifications:
- Industry certifications related to software testing, such as International Software Testing Qualifications Board (ISTQB), Certified Software Tester (CSTE), Certified Associate in Software Testing (CAST), and Certified Software Quality Analyst (CSQA).
Experience:
- A minimum of five (5) years of experience in systems development, testing, and/or business experience.
- Strong SQL skills (
- Strong understanding of Data Warehouse concepts, testing methodologies and different types of testing (business process, functional, integration, regression, performance, security, etc.);
- Ability to define test plans, test cases, test execution, defect management, and reporting in an enterprise application development environment;
- Basic Unix/Linux skills for job monitoring and log analysis;
- Hands-on experience with ETL tools, BI/Reporting tools, and test management tools;
- Experience with databases such as Oracle and SQL Server;
Responsibilities:
- Analyze business requirements, ETL mapping documents, and data models;
- Write and execute Structured Query Language (SQL) queries to validate data;
- Test ETL jobs: extraction, transformation, and loading into target tables;
- Validate fact and dimension tables (keys, measures, attributes);
- Perform data reconciliation between source and target systems;
- Check data quality (nulls, duplicates, invalid values, referential integrity);
- Verify aggregations, derived columns, and business logic;
- Test BI reports/dashboards against data warehouse tables;
- Work with developers, analysts, and DBAs to resolve defects;
- Automate regression and sanity testing where possible;
- Collaborate with the QA Lead/Manager to develop test strategies and test plans for Data Warehouse (DWH)/ETL Projects;
- Review ETL mappings, data models, and business rules with architects and analysts;
- Perform source-to-target mapping validation and data transformation testing;
- Conduct data reconciliation between multiple layers: source systems, staging, Operational Data Store (ODS), and data warehouse;
- Validate fact/dimension integrity, business rule implementation, and Key Performance Indicator (KPIs) in reports;
- Perform performance and scalability testing of ETL jobs and SQL queries;
- Implement automation frameworks for regression testing and data validation;
- Collaborate with developers, Database Administrators (DBAs), and business users to resolve data-related issues;
- Mentor team members and ensure adherence to QA best practices; and
