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.

Experience in writing complex SQL queries and validation of Enterprise Data Warehouse Applications.

Good knowledge in any RDBMS like AWS Redshift Postgres Oracle SQL Server.

Nice to have PythonExcellent communication skills both verbal and written.

Knowledge of Automation and Automation framework within ETL space.

Primary Skills Must haveUnderstanding of data model, ETL architecture.

Excellent in Data Warehouse concepts.

Excellent in writing complex SQL queries with performance tuned to be run in a tool.

Knowledge of Automation and Automation framework within ETL space.

Secondary Skills Good to have