Add Integration Test

[3n0ugh]

Is your feature request related to a problem? Please describe.
The current absence of integration tests within our Change Data Capture (CDC) project repository poses significant challenges in ensuring that all components interact seamlessly and function correctly together.

Describe the solution you'd like
I propose the introduction of comprehensive integration tests for our CDC project. These newly added tests should validate key functionalities and confirm the correct interactions between various system components. The testing framework should be designed for consistent and reliable execution across multiple environments, including local development settings and Continuous Integration (CI) pipelines.

Describe alternatives you've considered
Exclusively relying on unit tests, which do not sufficiently guarantee the proper integration and interaction between system components.
Conducting manual integration testing, which is inefficient and prone to errors.

Additional context
Incorporating integration tests will substantially improve the reliability and robustness of our CDC system by identifying issues that unit tests may overlook. Suggested focal points for the integration tests include:

• End-to-end data capture and propagation workflows
• Interaction between data sources and processing services
• Data consistency and integrity across different stages of the capture process