How to clean and preprocess historical XAUUSD Tick data for backtesting?

When developing quantitative trading strategies, many developers focus on strategy logic, indicators, or parameter optimization. However, the reliability of bac