An educational nonprofit needed help with an enterprise data migration and clean-up effort.
Challenge
The client’s Enterprise Data Management Office needed support establishing a migration path, setting up their AWS environment, developing an ETL pipeline, and implementing business requirements around data quality rules and quality assurance analysis.
Challenge
The client’s Enterprise Data Management Office needed support establishing a migration path, setting up their AWS environment, developing an ETL pipeline, and implementing business requirements around data quality rules and quality assurance analysis.Solution
Infinitive conducted an assessment on the existing project status, and worked with the client to facilitate a rebaselining and establish a migration program plan. Our team managed the enterprise data migration from Oracle to AWS, and configured security settings and AWS Redshift SQL stored procedures, applying business rules to 25+ years of student data.
Outcome
Infinitive successfully delivered on the defined project goals with the following outcomes:
- Migrated over 4.6 billion enrollment records, 140 million post-secondary degrees, and 68 million secondary records
- Applied business rules to data, and enabled testing strategies and plans to ensure successful and consistent application of rules
- Delivered performance and cost savings to the client with accurate warehouse selection assessment
Outcome
Infinitive successfully delivered on the defined project goals with the following outcomes:
- Migrated over 4.6 billion enrollment records, 140 million post-secondary degrees, and 68 million secondary records
- Applied business rules to data, and enabled testing strategies and plans to ensure successful and consistent application of rules
- Delivered performance and cost savings to the client with accurate warehouse selection assessment