ETL Testing with SQL Query

ETL Testing

WorkMode :Hybrid

Work Location : Chennai / Hyderabad

Work Timing : 2 PM to 11 PM

Primary : ETL , SQL , Data warehouse

Job Summary: We are seeking an experienced ETL QA Consultant to join our team. The ideal candidate will be responsible for performing ETL testing, data warehouse testing, and backend data validation. You will analyze business requirements and functional specifications to ensure data integrity and accuracy throughout the ETL process.

Responsibilities:

• Perform ETL testing, data warehouse testing, and backend data validation.
• Analyze business requirements, functional specifications, and Source-to-Target Mapping (STTM) documents.
• Develop and execute test scenarios, test cases, and test scripts for ETL workflows.
• Write complex SQL queries to validate data completeness, accuracy, integrity, and transformation logic.
• Validate source-to-target data, including record counts, data types, null values, duplicates, and business rules.
• Collaborate with ETL developers, business analysts, and data teams to resolve data-related issues.
• Prepare test execution reports, test evidence, and sign-off documentation.
• Support SIT, UAT, pre-production, and production validation activities.