Key skills: ETL Testing
Experience: 6 to 9 years
Location: Bhubaneswar
Job Summary: We are seeking a detail-oriented and experienced Testing Engineer to join our team. The ETL Testing Engineer will be responsible for designing, executing, and automating test cases to ensure the quality and integrity of data extracted, transformed, and loaded into data warehouses and other data repositories. This role involves working closely with developers, data engineers, and analysts to validate data transformations, business rules, and performance across the ETL process.
Key Responsibilities
ETL Testing:
- Design, develop, and execute test cases for ETL processes to verify data extraction, transformation, and loading.
- Validate data at different stages (source, transformation, and destination) to ensure the accuracy and completeness of data.
- Identify and report data discrepancies, errors, and anomalies during the ETL process, ensuring that they are addressed promptly.
- Verify data quality rules, business logic, and mappings used in the ETL processes.
Data Validation
- Perform data validation and reconciliation between source and target systems to ensure data integrity.
- Create SQL queries to validate data transformations and conduct data profiling to identify data quality issues.
- Validate ETL performance, including the efficiency of data loads and transformations, and ensure that SLAs are met.