Senior QA Engineer-BI

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- 

• Senior QA Engineer, BI: 4.5 years+

#LI-SV1