infra: upgrade pytest and use pytest_lazy_fixtures #7600

Job	Run time
integration-test-adls	1m 32s
integration-test-s3	1m 25s
lint-and-unit-test (3.10)	3m 15s
lint-and-unit-test (3.12)	3m 11s
integration-test	10m 51s
integration-test-gcs	1m 37s
lint-and-unit-test (3.13)	3m 8s
lint-and-unit-test (3.11)	3m 2s
integration-coverage-report	29s
	28m 30s

Provide feedback