Sai Gorantla

Experience

1. Data Engineer

   Physicians Mutual

   Sep 2022 — Present · Omaha, NE, US

   Developed an API using python to integrate various databases and provide an output required for the sales team while suggesting new algorithms, table indexing and reducing the use of loops.For the API’s, I used FASTAPI to test it in a local environment.Optimized datastage application while adding new jobs by turning off run time propagation of columns, sorting the data before hand and using the right configrations. Updated the batch jobs and running it in docker configurations to make sure it is ready for cybermation jobs.Worked on a completely new application and rewrote the rules in python that were being used manually for getting the right information from databases and also optimized the whole process.Applied database logic similar to Azure data lakes with Gold, Silver and Bronze tables without using Azure.Developed a single batch job for two different separate applications to send letters with different logics, tested it in docker environment and then deployed it on cybermation using multiple arguments.Also worked on GIT, Jenkins, Datastage, Python, DB2, Cybermation and other resources.