Improve speed and coverage of unit tests

[ronanstokes-db]

Expected Behavior

Unit tests should run faster - current takes 10 - 12 minutes

Proposed enhancements

• Make use of all cores when running unit tests
• Convert critical tests to use Pytest rather than unit test
• use default parallelism as default number of partitions

[ronanstokes-db]

Fixed by new PR