Senior Software Tester

Job Title: QA Analyst –

Location: Onsite in Rayadurgam, Hyderabad

Employment Type: Full-time

Experience Level: 7 - 12 Years

Job Summary:

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