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.
- 712 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).
