Title : BI QA with big data
Location : SFO.CA
? Develop BI User Acceptance Testing (UAT) strategy and matrix across different analytic groups (architects, DBA's, developers, functional analysts) to address testing in analytic data sets, reports, dashboards and metrics.
? Work in Agile environment
? Work with the QA Manager to set expectations and direction from a strategic and planning perspective
? Create Test Plans, Test Scenarios, Test Cases, Test Data and Test scripts for all scenario types and Execute. (i.e. positive, negative testing, boundary)
? Verify requirement traceability from System Requirements through test cases and defects
? Ensure that testing activities will allow applications to meet business requirements and systems goals, fulfill end-user requirements, and identify and resolve systems issues
? Work with the developers to understand the technical requirement/design being built in a project
? Validate Test Preparation of environments and verify all teams are aligned with what needs to occur to build/prepare the test environments
? Coordinate, track and report regularly on execution of system testing
? Identify, Record and Report defects. Perform root cause analysis of the defects and coordinate with development team to resolve them.
? Mentor and provide guidance to testers/ developers
? Analyze and ensure test results and changes/defect are reflected in the test case and test cases are updated appropriately based on resolution
? Identify and recommend process improvements as necessary
? Identify testers to be trained and map testers to training
? Perform additional duties as assigned
? Excellent written and oral communication skills
? Excellent listening and interpersonal skills (includes but not limited to peers, managers, and the business)
? Excellent organizational skills to manage a wide array of testing information
? Strong knowledge of system testing and software quality assurance best practices and methodologies
? Coordinate with Onsite/Offshore testing or development teams.
Desired Skills and Experience
? 7+ years?experience in Software Quality Assurance
? 5+ years?experience in ETL and Data-warehouse QA
? Experience in Big data [Hadoop/HDFS/Hive], Teradata, Oracle PL-SQL and other Data bases testing
? Experience in Reporting tools like Microstrategy, Tableau, Power BI
? Experience in ETL tools like Informatica , IBM Datastage, Pentaho
? Experience in Unix scripting and knowledge of CI/CD tools like Github/Jenkins
? Thorough knowledge of Agile and QA/Test methodologies
? High Proficiency in ETL and Data-warehouse Testing
? Advanced skills in manual testing and proficiency with backend automation test strategy
? Experience in TDD for BI.
? Interpreting Data Models with little to no assistance
? Proficient in SQL building and SQL optimization independently
? Good knowledge of Data-warehouse concepts
? Test Lead experience is must
? Nice to have hands on experience in Python, Azure or AWS cloud platform
? Experienceworking with offshore team
- Bachelor's degree (BA or BS) in Computer Science, Information Systems, Engineering or related field required.