ETL Test Engineer

Job Description – Microsoft Fabric & Power BI Data QA / Test Engineer

Position: Microsoft Fabric & Power BI Data QA / Test Engineer

Experience: 3–8 Years

Location: Bengaluru / Hyderabad

Domain: AI & Engineering / Data & Analytics

Role Overview

We are looking for an experienced Microsoft Fabric & Power BI Data QA / Test Engineer with strong expertise in end-to-end data testing, SQL, PySpark, Microsoft Fabric, and Power BI testing. The candidate will be responsible for validating data pipelines, transformations, semantic models, DAX calculations, dashboards, and reporting accuracy across the complete analytics lifecycle.

Key Responsibilities

• Develop and execute end-to-end test strategies and test plans for data and BI solutions.
• Validate data ingestion, transformations, incremental loads, watermarking, schema changes, and source-to-target mappings.
• Test Microsoft Fabric components including OneLake, Lakehouse, Data Warehouse, Data Pipelines, Dataflows Gen2, and Notebooks.
• Perform comprehensive Power BI testing, including:
• Semantic models and table relationships
• DAX measures and calculated columns
• KPIs and time-intelligence calculations
• Slicers, filters, drill-throughs and drill-downs
• Visual interactions and dashboard performance
• Row-Level Security (RLS) and role-based access
• Reconcile Power BI metrics against Fabric Lakehouse/Warehouse and source-system data.
• Develop complex SQL queries for data validation, reconciliation, aggregation, and regression testing.
• Use PySpark/Python for automated data-quality checks and large-volume data validation.
• Validate pipeline error handling, retry mechanisms, and schema-drift scenarios.
• Identify, document, and track defects using Jira or Azure DevOps.
• Participate in Agile ceremonies including sprint planning, refinement, estimation, and retrospectives.
• Support integration of automated quality checks into Azure DevOps/CI-CD pipelines.

Mandatory Skills

• 3–8 years of experience in Data QA / Data Testing / BI Testing.
• Hands-on experience with Microsoft Fabric:
• OneLake
• Lakehouse
• Data Warehouse
• Data Pipelines
• Dataflows Gen2
• Fabric Notebooks
• Strong hands-on Power BI testing experience.
• Strong SQL skills for complex validation and reconciliation.
• Hands-on PySpark / Python experience.
• Strong understanding of DAX, semantic models, relationships, cardinality, KPIs, and RLS.
• Experience with ETL/ELT testing and dimensional data modeling.
• Knowledge of Star and Snowflake schemas.
• Experience with Jira/Azure DevOps and Git.
• Strong analytical, problem-solving, documentation, and communication skills.

Good-to-Have Skills

• Great Expectations, PyTest, or other automated data-quality/BI testing frameworks.
• Azure Data Factory, Azure Data Lake, and Synapse Analytics.
• Knowledge of automated BI testing tools.
• Certifications such as:
• DP-600 – Microsoft Fabric Analytics Engineer Associate
• PL-300 – Power BI Data Analyst
• DP-203 – Azure Data Engineer
• Experience in Relocation Management or Professional Services domain.