Ashirwad Pattnaik

Development and enhancement of data warehouses as per client’s requirement; Extracting soured data from queues/files/tables and loading in Vertica tables; Monitoring and correcting failures in data warehouse; Usage of various Pentaho tools to create jobs and transformation as per business requirement; Creating high level and low-level design documents, unit test plan and test scripts; Maintaining code review checklist after every code drop; Developing adhoc scripts to serve instant requests from business; Tuning of Pentaho jobs for better performance; Migration of On-Premise Pentaho to AWS GLUE. Accountabilities include maintaining in-depth knowledge of the business, processes, applications, information and data, and organizing Knowledge management sessions.

Involved in creating various business reports for the client by fetching data from various tables of the Exadata database of CAS and putting them into CSV files; Monitoring and correcting failures in data warehouse and creation of on demand scripts for data fix. Accountabilities included maintaining in-depth knowledge of the business, processes, applications, information and data, and organizing Knowledge management sessions.