Ranjan Relan, Strategy & Architecture Manager Riya Srivastava, Business Technology Associate Consultant
Organization: ZS Associates
ZS Associates is a management consulting and professional services firm focusing on consulting, software, and technology, headquartered in Evanston, Illinois that provides services for clients in healthcare, private equity, and technology.
It was initially observed that the QA and unit testing teams used to spend 20 hours per week performing manual execution of test cases on Snowflake. Due to manual efforts, there used to be a scope of errors in the quality of deliverables along with the need to spend more time on re-testing and quality assurance. Additionally, there was no history of maintenance while performing manual testing.
In order to overcome the aforementioned challenges, I came up with the build of a Python-based Automation Utility hosted on Dataiku and integrated with Snowflake. The Utility made the QA testing significantly faster and much less prone to errors. Moreover, it enabled the history maintenance of testing on a shared drive location through which we are now able to track data quality over time. The turnaround time for the overall process is now reduced to 15 minutes per week.
Business Area: Internal Operations
Use Case Stage: Built & Functional
The Automated Test Framework in Python, which is integrated with the client's framework and environment ecosystem, led to the automation of more than 60% of unit and QA testing. The Automation Utility was duly appreciated by the client, and the implementation methodology which was adopted during the development exactly met the client's expectations. The Utility went live with no modifications suggested by the client.
Value Brought by Dataiku:
It enhanced the overall manual effort that the team was taking while doing the unit testing, UAT, and SIT.