Test Lead

Job Summary

Role: Data / BI Tester - Expert level

The Data / BI Tester is responsible for 
- validating end‑to‑end data pipelines and analytical outputs within the Microsoft Fabric platform. 
- ensure data accuracy, completeness, consistency, and performance across data ingestion, transformation layers, and Power BI dashboards. 
- closely work with data engineers, BI developers, and platform teams to identify data quality issues early and ensure reliable, business‑ready insights.

Key Responsibilities
1. Functional Testing
2. Data Validation
3. Test Case Development
4. Security & Access Testing
5. Defect Management
6. UAT Support

 

Required Qualifications: 

• Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Science, or a related field.
• 5–8 years of hands-on experience in BI development, with a strong focus on Power BI and Microsoft Fabric.

Key Responsibilities

1. To participate in functional as well as technical discussions with the client /team to understand functional /design specifications ,highlight performance concerns, inconsistencies ,prepare automated test scripts,maintain test case suite,ensure the appropriate test environments and infrastructures are in place/kept upto date.
2. To develop and continuously improve automated tests as new system features/ enhancements are developed and accordingly create work plans| monitor and track the work schedule for on time delivery as per the defined quality standards.
3. To create reusable /scalable test automation framework, develop test strategies/plans, maintain test data and to submit status reports for minimizing exposure and risks on the project or closure of escalations.
4. To develop/guide and mentor QA engineers in the use of the testing framework , enhancing their technical capabilities and increasing productivity.

Skill Requirements

Must-Have Skills:

- Experience in validating data ingestion, transformations, and reporting layers using structured test cases, data reconciliation, and exception analysis.
- Ability to write complex SQL queries to validate row counts, aggregates, joins, filters, and transformation logic in Fabric Lakehouse/Warehouse.
- Working knowledge of Fabric components such as Lakehouse, Warehouse, Data Factory pipelines, and OneLake concepts (from a testing perspective).
- Hands‑on experience testing batch and incremental loads, handling nulls, duplicates, data type issues, and business rule validations.
- Experience validating Power BI semantic models, measures, filters, relationships, visuals, and dashboard outputs against source data and business logic.
- Expertise in source‑to‑target validation, record count checks, aggregate comparisons, and historical data validation.
- Experience logging defects with clear evidence, working closely with developers to troubleshoot issues, and supporting retesting cycles.

 

Nice to Have Skills:

- Ability to understand and validate DAX measures, calculated columns, and filter context issues in Power BI.
- Exposure to test automation frameworks, data validation scripts, or tools such as Python, PowerShell, or SQL‑based automation.
- Prior experience testing data during platform migrations (e.g., legacy DW to Fabric) or exposure to domain‑specific data (finance, supply chain, telecom, etc.).

Other Requirements

null