Etl Tester

Role: ETL Tester

Location: Nagpur, MH

Job type: Full time

Experience Level: 4-6 years

Mandatory skills: SQL / PL-SQL, Data Warehouse & Data Validation Testing, AI/Data Model Testing, Playwright Automation, API Testing, SIT & Test Lifecyle Management

Key Responsibilities:

Strong understanding of AI/data prediction model testing and Data Warehouse concepts, including data Table, Schema, Dimensions, and Facts.

Ensure all required deliverables, including Test Strategy, Test Plan, Test Cases, and Test Sign-offs, are completed and aligned with governance requirements.

Take ownership of the quality of deliverables across the development and testing lifecycle.

Hands-on experience with Playwright, strong SQL concepts, API Testing, and related automation technologies.

Create test cases and test data, execute test scenarios, and document test results and defects.

Review Data Models, Data Mappings, and Architectural Documentation to design and execute effective SIT test plans and test cases.

Validate data by executing database queries and verifying results against expected business outcomes.

Work closely with Business team, Developers, Data Engineers, and other QA professionals to ensure timely and effective testing.

Develop SQL queries to extract, compare, and validate data across different systems and data sources.

Translate complex business rules and logic into SQL/PL-SQL queries for data validation and testing.

Identify data discrepancies, investigate root causes, and collaborate with development teams to ensure timely resolution.

Ensure adequate test coverage, traceability, and documentation throughout the testing lifecycle.