Automated ETL Testing that Eased Decision-Making
The Aim to Go Paperless
Tables Tested with Automation
Databases tested
-
7+ Years Partnership -
On-time every time in all Sprints. -
Parallel Testing of old & new features with manual & automation.
Tools we Used
Ensuring Data quality
Comprehensive test automation
-
Introduced automation testing to save countless man-hours. -
Set up a Robust Reporting framework using Lemon Cheesecake & Snowflake. -
Achieved CI/CD Integration by using Jenkins. -
Improved Data Quality by introducing Data Profiling with the help of Looker. -
Followed Agile methodology & supported every release without any delay.
What we did?
Introducing Test Automation
CI/CD Integration in an Agile Environment 
Our ReportingPattern
Data Profiling withLooker
Introducing Test
Automation
Initially tasked with manual testing, we saw an opportunity for automation to save time and costs. We developed automation scripts in the LemonCheesecake framework using Python and demoed them to our clients, who were impressed and engaged us for automation testing. As firm believers in continuous improvement, we continually enhanced our processes. Recognizing the potential of DBT, we successfully implemented it in our project, further optimizing our testing efficiency.
CI/CD Integration in an Agile Environment
Following Agile methodology, our client had a release every 2-week sprint. Over our 7-year partnership, we never missed a deadline, even when testing databases over 3 TB. We consistently met deliverables on time. Achieving CI/CD integration, we used tools like Jenkins and Apache Airflow, ensuring seamless and efficient project execution. Our commitment to punctuality and quality contributed to our successful long-term collaboration.
Our Reporting
Pattern
Tracking the history of failures was crucial, so we integrated the Lemon Cheesecake tool with Snowflake. This allowed us to report the number of test cases passed and failed daily. Additionally, we ensured that the test results were directly ingested into the database for easy tracking. This seamless integration provided a robust solution for monitoring and managing test outcomes, significantly enhancing our ability to analyze and respond to test results efficiently.
Data Profiling with
Looker
Data was flowing to their databases from different sources such as web, mobile, and so on. So with the implementation of data profiling, we were able to identify quality issues that would usually go undetected if we tested only the source and target databases. So we used Looker to create dedicated dashboards that would display the automation testing results for aspects such as level of ebook usage, number of subscriptions, activations, and so on.
Talk to our Experts
trust us
