17 Nov
|
0101Digitall
|
Bengaluru
17 Nov
0101Digitall
Bengaluru
MSBI QA Testing Role:-
Job Description: QA Tester (Functional/DB/ETL), in simple terms. The role in one line:- This person checks that the data and reports a client sees (dashboards, pipelines, databases) are correct, complete, and working properly before they go live. What they actually do day to day
- Test reports and dashboards built in Power BI and the Microsoft BI tools (SSIS, SSRS, SSAS). They compare what’s on screen with the source data.
- Check Power BI data models, meaning that the relationships and calculations are right and the scheduled data refresh runs without failing.
- Test data pipelines, which move data from one place to another (ETL = Extract, Transform, Load). They confirm nothing is lost or changed incorrectly along the way.
- Write SQL and BigQuery queries to compare source data with the final data.
- Use Python to automate checks and prepare test data.
- Test APIs to check that systems talk to each other correctly and handle errors.
- Verify business rules, for example “does the system reject invalid input?”
- Do non-functional testing, such as speed, large data volumes, refresh time, and security.
- Write and run test cases in JIRA/AIO, and log defects and follow them until they’re fixed with developers.
- Support UAT (User Acceptance Testing) by coordinating with business users and getting their sign-off.
- Report and escalate to the QA Lead or Delivery Manager, and join sprint meetings.
Must-have skillsAreaWhat to look forLanguagesSQL (essential),
PythonCloud/DataBigQuery, GCP services (Dataflow, Dataproc, Cloud Storage, Pub/Sub)BI toolsPower BI, MSBI stack (SSIS, SSRS, SSAS)Test toolsJIRA + AIOTestingWeb UI and cross-browser testing, API testing, ETL/data testingProcessAgile/Scrum, UAT managementSoft skillsAttention to detail, analytical thinking, clear communication, stakeholder follow-upQualifications
- Bachelor’s in Computer Science, IT, or a related field
- 3-4 years of QA/testing experience
- ISTQB Foundation is nice to have, not mandatory
- Experience on data-heavy enterprise projects is a plus
Screening tips for recruiting
- Non-negotiable: SQL plus hands-on data/ETL testing. Many QA candidates only have UI testing, which isn’t enough here.
- Strong differentiators: Power BI testing, BigQuery/GCP, and Python automation.
- Good probing questions:
- “How did you do source-to-target reconciliation?”
- “How have you tested a Power BI refresh or a report against source data?”
- “Have you written Python scripts to compare datasets?”
- Watch out for: candidates with only manual UI testing, or who list the tools but can’t explain how they used them.
- Realistic expectation: it’s hard to find all of this in one profile. A candidate robust in SQL and ETL testing with some Power BI or GCP exposure is a reasonable fit for 3-4 years of experience.
Pay: ₹10,000.00 - ₹100,000.00 per month
Work Location: In person
📌 MSBI QA Tester (Bengaluru)
🏢 0101Digitall
📍 Bengaluru