Senior Software Tester

Job description :

Job Title : QA Analyst –

Location : Onsite in Rayadurgam, Hyderabad

Employment Type : Full-time

Experience Level : 7 - 12 Years

Job Summary :

We are seeking a highly skilled Senior QA Analyst with strong expertise in Power BI Testing, Azure Data Factory (ADF), ETL / ELT pipelines, Data Validation, and Data Seeding. The ideal candidate must have deep experience in validating large-scale data workflows, end-to-end BI reporting solutions, and Azure-based data integrations. This role requires excellent analytical, troubleshooting, and automation skills to ensure high-quality data solutions.

Key Responsibilities

Power BI Testing

Validate Power BI dashboards, reports, data models, and DAX calculations.

Perform UI / functional testing, filter testing, drill-through validation, and visual consistency checks.

Verify dataset refresh schedules, gateway configurations, row-level security (RLS), and user access.

Conduct regression testing after report or dataset changes.

Azure Data Factory (ADF) / ETL Testing

Validate pipeline executions, triggers, mapping data flows, and linked services.

Perform ETL / ELT data validation between source and destination : SQL, Data Lake, Blob, Synapse, etc.

Validate data transformations, schema changes, incremental loads, SCD types, and job dependencies.

Monitor pipeline failures, debug issues, and verify logs, alerts, and retry logic.

Test API-based ingestion and distributed data processing.

Data Seeding & Test Data Management

Define and build test data strategies for structured and unstructured data sets.

Create and maintain data-seeding scripts (SQL / Python / ADF pipelines) to populate test environments.

Work with Dev / Data Engineering teams to design stable data sets for functional and regression testing.

Ensure data versioning, masking, and compliance with security standards.

Quality Engineering & Automation

Build SQL-based validation scripts and reusable automation frameworks for ETL / ADF testing.

Perform API testing for data ingestion endpoints.

Automate data comparisons and report validations wherever possible.

Implement test processes for data accuracy, completeness, lineage, and reconciliation.

Agile Collaboration

Participate in sprint planning, story grooming, and definition-of-done (DOD) creation.

Work closely with Data Engineers, Power BI Developers, Cloud Engineers, and Product Owners.

Document test cases, traceability matrices, and release notes.

Required Qualifications

Bachelor’s degree in Computer Science, Engineering, or related field.

7–12 years of QA experience with strong data and BI testing background.

Hands-on experience in :

Power BI Testing (reports, DAX, dataset validation, RLS).

Azure Data Factory (pipelines, data flows, triggers, ADF monitoring).

ETL / ELT testing with SQL, Data Lake, Blob storage, Synapse.

Data Seeding using SQL scripts, ADF pipelines, or automation tools.

Strong SQL querying for data validation, joins, aggregations, and reconciliation.

Experience in Python or PowerShell for automation (preferred).

Experience with Azure DevOps, Git, CI / CD pipelines.

Solid understanding of data warehousing concepts, star schema, fact / dimension modeling.

Strong communication, documentation, and analytical skills.

Preferred Skills

Experience with Power BI Premium, XMLA endpoints, and Tabular Editor.

Experience in PySpark / Databricks for large-volume data validation.

QA automation with Selenium, pytest, or custom data validation frameworks.

Knowledge of P&C Insurance / BFSI domain (optional but preferred).