Managing more than 62 billion health care records for CMS

The Centers for Medicare & Medicaid Services (CMS) Integrated Data Repository (IDR) is the largest government database in the world—a more than one petabyte system serving approximately 2,500 users. Perspecta performs comprehensive data management support for the IDR, including extract–transform–load (ETL), data quality, data modeling, data query assistance support and analytics business intelligence support and data validation activities.

The IDR, which contains more than 62 billion records is the centerpiece of CMS’ Enterprise Data Warehouse strategy to meet the requirements of Medicare modernization initiatives, supporting the agency’s critical need to have an integrated data environment that contains Medicare and Medicaid claims as well as beneficiary, provider and health plan data. It is a critical source of Medicare-related information used by the CMS Center for Program Integrity (CPI), the CMS Medicare Shared Savings Program (MSSP) and a variety of other health care-related organizations. Under this contract we are tasked by CMS to migrate the Teradata / Hadoop platform to a Snowflake / Databricks cloud data warehouse.