PLSQL TO Snowflakes Data Migration Tool
Sales companies have a lot of transactions with a huge amount of data size running (e.g 10 Petabytes) on on-premise databases like Oracle. Sometimes it takes 2-3 days before a report for transactions can be generated. Cases like power outages and disaster recovery processes take a long while to complete which makes customers constantly lose confidence in the company.
Issues with on-premise databases:
Create a tool that helps migrate on-premise database to a cloud data warehouse like snowflake .
To design a web application that shows the entire flow of migrating on-premise databases to a cloud data warehouse.
Primarily the users are going to be Database engineers and I had to sit down with the developer to understand pain points, the best approach to the interface design based on front end dev skills, and generally figure out the right flow and process to take for engineers to easily migrate their database.
We had discussions around the database credentials, database objects needed for migration (tables, procedures, functions & views), error handling and notification, filtering objects, the duration for migration, and useful information to display to engineers when migration was successful.
After gathering requirements, I collaborated with the developer to create a user flow to properly understand the process.
After multiple iteration on the design, we got to a point that worked! The design the ability to
I got to design the interface using a 12-grid system so the front end dev can easily implement using basic front end libraries like bootstrap.
The idea behind the wave interaction on the landing page was to emulate the way waves transfer energy.
Wave' is a common term for a number of different ways in which energy is transferred: In electromagnetic waves, energy is transferred through vibrations of electric and magnetic fields.
It was an exciting project getting to understand better on how databases are managed and basically improving my knowledge of database structure.
The project is currently in development and will be out few months from now.