Description

ETL & Power BI Tester with solid hands-on expertise in data validation, ETL testing, SQL, and Power BI report/dashboard testing. The candidate should be capable of independently investigating data discrepancies across source, transformation, and reporting layers and identifying root causes.

Perform end-to-end ETL testing, covering source-to-target data validation.

Validate data transformations and business rules against mapping and requirement documents.

Perform data reconciliation and control-total validation between source and target systems.

Validate data for completeness, accuracy, integrity, duplicates, and null values.

Write complex SQL queries involving joins, aggregations, subqueries, and data-comparison logic.

Perform backend/database validation to reconcile data displayed in Power BI reports with underlying data sources.

Perform functional testing of Power BI dashboards and reports, including data accuracy, structure, schema, aggregations, and report behavior.

Investigate data and reporting defects independently and perform root-cause analysis across ETL and reporting layers.

Raise clear defects with sufficient evidence and work with data engineering/development and visualization teams through resolution.

Perform regression and end-to-end testing following application/data changes.

Trace data lineage across pipeline stages to determine where data discrepancies originate.

Access Microsoft Fabric data workspace/data marts and execute queries for backend validation.

Participate in Agile delivery activities and provide testing status, defect status,



risks, and quality updates.

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 581366
- Project Location 1 : TELANGANA | HYDERABAD
- Project Location 2 : KRNK | BANGALORE
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : NA
- Relevant Experience : 4+
- Mandatory skills : • Strong ETL testing experience• Source-to-target data validation• Data reconciliation and control-total validation• Transformation/business-rule validation• Data completeness, accuracy, integrity and duplicate/null checks• Ability to understand mapping documents and validate ETL workflows• Strong hands-on SQL query writing• Joins, aggregations, subqueries and data comparison queries• Backend/database validation against reports
- Desired skills : Strong Power BI testing proficiency — dashboard, report, and UI-level testing.• Data analysis skills — data cleaning, transformation, and exploratory data analysis to investigate and root-cause discrepancies.• Microsoft Fabric — ability to access the data workspace and write queries against the data mart.• Data lineage analysis — ability to trace data across pipeline stages to pinpoint where issues originate.
- Domain (Industry) : life sciences
- BGC (Before onboarding / After onboarding) : PreOB
- Total Experience (Ex. 5-7 Years) : 5
- BGC Details : pre bgv
- BGC Vendor : nascom
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : 9-6
- Shift Timings : General

📌 581366-ETL & Power BI Tester (Bengaluru)
🏢 Trigent Software
📍 Bengaluru