After an initial conversation we discovered they were simply using Salesforce as a database and Informatica was like a John Deere lawn mower for their small yard. The solution was to replace their entire stack with K3, a Microsoft SQL Server database, and Tableau for reporting.
K3 is now used by business users to incorporate new files and handle changes to existing client files. K3 delivers an easy to maintain datamart and Tableau has empowered them to slice and dice information as needed. As ongoing analysis reveals revisions that should be made upstream, business users make those in K3 directly.