- Review and approve CRM migration datasets before production deployment by validating completeness, consistency, and overall data quality.
- Review production data updates and validate SQL scripts before execution to ensure large-scale changes are safe and correct.
- Develop automated validation queries that detect missing records, duplicate entities, broken relationships, and other integrity issues.
- Compare source CRM exports with Dwelly data to verify successful migration and investigate discrepancies.
- Analyse unexpected migration results, identify root causes of inconsistencies, and work with engineers to resolve complex data issues.
- Identify recurring migration issues and help improve migration processes, validation tooling, and overall data quality standards.
PostgreSQLSQLGit+2 more