ETL Testing

Define and implement test data strategies for ETL Apps

Lead testing of ETL pipelines of data marts and data warehouses

Design develop and optimize tests to validate ETL workflows

Write and review complex SQL queries for data validation with respect to given business rules transformation logics

Collaborate with business analysts QA and development teams to understand data requirements and ensure coverage

Automate test data generation and provisioning processes

Primary Skills

Strong experience in ETL Testing

Advanced SQL skills for complex queries and stored procedures

Hands on experience in Python for automation and data processing

Strong understanding of data modelling relational databases and data warehousing concepts

Experience in data quality checks and troubleshooting data issue