Case Study: AstraZeneca migrates 800 Informatica workflows to dbt Cloud 5 months faster with Datafold

AstraZeneca migrates 800 workflows 5 months faster with Datafold

AstraZeneca, one of the world's largest pharmaceutical companies, faced the challenge of migrating its regional data warehouse from the soon-to-be-unsupported Informatica PowerCenter to a new modern data stack. The project involved converting nearly 800 complex workflows under a strict deadline to avoid service disruption for its sales team. Datafold was brought in to help automate this migration.

Using its AI-powered Data Migration Agent, Datafold translated the Informatica workflows into dbt code and used Data Diff to validate data parity at every step. This solution enabled Datafold to complete the migration in less than seven months, five months faster and four times cheaper than another vendor's estimate, with zero service disruption to the business.

AstraZeneca