Understand of RevPro database(oracle) architecture and RevPro master and transactional data
Experience in working data migration projects especially moving from on-prem to cloud
Experience in automating data migration validations.
Preferably with SQL or Alteryx or any experience in open-source tools(python) is ok ( This is very important for the project and the automations enable us to repeat the testing in multiple test cycles and execute faster).
Experience in validating data migration data accuracy and completeness.
Experience in developing Alteryx flows using Alteryx designer.
Understand all underlying tables used for the health checks, Alteryx flows and custom BI reports for disclosures.
Able to update/modify existing Alteryx flows as per business/system requirements .
Understand impacts of lack of data access to RevPro DB due to cloud migration and think out of box to support existing processes dependent on the RevPro data.
RevPro environments and understand which environments will be used for migration.
Attend workshops to understand and align on data migration details.
Requirements gathering for BI reporting ( Data for health check queries, trouble shooting, alteryx flows, limited fields and custom BI reports).
Understand mock data cycles and what data is needed for each cycle for testing.
Ensure data mappings between source and Target versions are same.
Data validations and build approach to validate data for completeness.