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-SV1
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.
Skills Required
- Experience in Data Warehousing / BI Testing using ETL and reporting tools
- Extensive experience writing and troubleshooting SQL queries (Snowflake, Redshift, SQL Server, Oracle)
- Exposure to Data Warehousing and Dimensional Modelling concepts
- Experience understanding ETL Source to Target Mapping documents
- Experience testing code on ETL tools
- Experience validating dashboards/reports on Sisense, Tableau, SAP BusinessObjects, MicroStrategy
- Hands-on understanding of SDLC and STLC
- Experience with QA methodologies (Waterfall, V-Model, Agile, Scrum)
- Ability to write detailed test cases for functional and non-functional requirements
- Experience with testing types: Black Box, Smoke, Functional, System Integration, End-to-End, Regression, UAT; involvement in Load/Performance/Stress testing
- Experience using TFS or JIRA and Excel for test case writing and tracking
- Exposure to scripting languages like Python or automated testing tools like QuerySurge
- Effective communication and strong analytical abilities
- Experience: QA Engineer 2.5+ years; Senior QA Engineer 4.5+ years
What We Do
LiveCareer, www.livecareer.com, is the leading online career destination for successful job seekers. We’ve helped more than 10,000,000 registered users build job-winning resumes and find careers they absolutely love. Our Resume Builder has been described as “the most impressive resume builder on the market today”. Featuring hundreds of industry-specific templates, and thousands of expert-written text examples, Resume Builder makes it easy to create a polished, professional, strategically-targeted resume in minutes. In addition to America’s #1 Resume Builder, LiveCareer offers an impressive suite of job-finding tools, including resume reviews, resume writing, customized cover letters, job boards, career tests, interview tips, and more. LiveCareer has been recognized as one of the top 100 employment websites by Weddle, and was recently named the 2013 Best Employment Interactive Application by the Web Marketing Association. Ready to take the next step at work? Download your FREE eBook now! http://www.livecareer.com/ebooks/get-what-you-want-raises-promotions Whether you want to make more money, win a promotion, or move into a leadership role, our FREE eBook is filled with tips, advice, and inspiration that can help make this your most successful year yet! Share this free guide with friends and family using #NewYearBetterCareer
