1. A method for utilizing an index to manage access to data in a dataset stored in one or more file locations in an Extract Transform Load tool, the method comprising: receiving, by one or more processors, a request to access a first dataset of a plurality of datasets stored at a source system during an Extract Transform Load process between the source system and an end target system during a period of high I/O requests, wherein the period of high I/O requests is based on a number of I/O requests received for a particular duration; querying, by one or more processors, a first index for one or more file locations where the first dataset is stored at the source system; responsive to determining that caching the request does not disrupt an order assigned to the request to access the first dataset of the plurality of datasets stored at the source system, caching, by one or more processors, the request to access the first dataset stored at the source system, wherein the cached access request for the first dataset is one of a plurality of cached requests to access the plurality of datasets stored in a plurality of file locations at the source system; responsive to determining a total size of the plurality of cached requests in temporary storage does not met a first threshold level, determining, by one or more processors, whether a duration for which the cached request for the first dataset of the plurality of cached requests has been cached in the temporary storage has met a second threshold level; responsive to determining that the duration for which the cached request for the first dataset of the plurality of cached requests has been cached has met the second threshold, identifying, by one or more processors, a first file location of the plurality of file locations to access in order to satisfy a portion of the plurality of cached requests for datasets that includes the cached request to access the first dataset; and accessing, by one or more processors, the first file location at the source system to satisfy the portion of the plurality of cached requests for datasets that includes the cached request to access the first dataset stored at the first file location, wherein accessing the first file location to satisfy the portion of the plurality of cached requests for the datasets stored at the first file location reduces the total size of the plurality of cached requests to access the source system during the Extract Transform Load process.