ETL Testing

Excellent in writing SQL Scripts to validate data in ODS and Mart.
Should be able to develop and execute test plans, test cases, test scripts. Strong in validation of Visual Analytics reports using tools like Power BI, MicroStrategy, etc. and running different types of test within the same. Identifies, manages, and resolves defects during testing cycles leveraging a test management tool like JIRA, HP ALM. Also, supports or leads UAT process, when appropriate. Should be aware of Quality and Testing related best practices and procedures and adheres to those. Good knowledge in any RDBMS like AWS Redshift Postgres Oracle SQL Server. Nice to have Python Excellent communication skills both verbal and written. Knowledge of Automation and Automation framework within ETL space. Primary Skills Must have Understanding of data model, ETL architecture. Excellent in Data Warehouse concepts. Collaborate with business analysts and stakeholders to understand the data requirements. Review functional specifications and ensure they align with the ETL process Create detailed test plans for ETL testing, including the scope, test cases, and test data. Define the test environment, required tools, and resources for ETL testing. Design and write test cases based on functional specifications and ETL mappings. Ensure coverage of all scenarios, including positive and negative test cases, edge cases, and data validation.