About the role
BOLD is seeking for QA professional who will work directly with the BI Development team to validate Business Intelligence solutions. He will build test strategy and test plans and test cases for ETL and Business Intelligence components. He will also validate SQL queries related to test cases and produce test summary reports.
ABOUT THIS TEAM
BOLD Business Intelligence(BI) team is a centralized team responsible for managing all aspects of the organization's BI strategy, projects and systems. BI team enables business leaders to make data-driven decisions by providing reports and analysis. The team is responsible for developing and manage a latency-free credible enterprise data warehouse which is a data source for decision making and input to various functions of the organization like Product, Finance, Marketing, Customer Support etc.
BI team has four sub-components as Data analysis, ETL, Data Visualization and QA. It manages deliveries through Snowflake, Sisense and Microstrategy as main infrastructure solutions. Other technologies including Python, R, Airflow are also used in ETL, QA and data visualizations.
WHAT YOU’LL DO
- Work with Business Analysts, BI Developers to translate Business requirements into Test Cases
- Responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
- Designing, documenting and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
WHAT YOU’LL NEED
- Experience in Data Warehousing / BI Testing, using any ETL and Reporting Tool
- Extensive experience in writing and troubleshooting SQL Queries using any of the Databases – Snowflake/ Redshift / SQL Server / Oracle
- Exposure to Data Warehousing and Dimensional Modelling Concepts
- Experience in understanding of ETL Source to Target Mapping Document
- Experience in testing the code on any of the ETL Tools
- Experience in Validating the Dashboards / Reports on any of the Reporting tools – Sisense / Tableau / SAP Business Objects / MicroStrategy
- Hands-on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
- Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum.
- Well versed with writing detailed test cases for functional & non-functional requirements.
- Experience on different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing. · Expertise in using TFS / JIRA / Excel for writing the Test Cases and tracking the
- Exposure in scripting languages like Python to create automated Test Scripts or Automated tools like Query Surge will be an added advantage
- An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects
EXPERIENCE-
- QA Engineer, BI: 2.5 years+
- Senior QA Engineer, BI: 4.5 years+
#LI-Hybrid
About Bold
We Transform Work Lives
As an established global organization, BOLD helps people find jobs. Our story is one of growth, success, and professional fulfillment. We create digital products that have empowered millions of people in 180 countries to build stronger resumes, cover letters, and CVs. The result of our work helps people interview confidently, finding the right job in less time. Our employees are experts, learners, contributors, and creatives.
We Celebrate And Promote Diversity And Inclusion
We value our position as an Equal Opportunity Employer. We hire based on qualifications, merit, and our business needs. We don't discriminate regarding race, color, religion, gender, pregnancy, national origin or citizenship, ancestry, age, physical or mental disability, veteran status, sexual orientation, gender identity or expression, marital status, genetic information, or any other applicable characteristic protected by law.
Under San Francisco's Fair Chance Ordinance, qualified applicants with arrest and conviction records will be considered for the position.