Nihar Ranjan Nayak Email and Phone Number

Professional Summary:• Having over 9 years of experience in Analysis, Design, Development, Testing and Implementation of business application for Health care and Retail Market. • Ability to develop ETL pipelines in and out of data warehouse using Snow SQL.• Experience on Migrating to Snowflake data warehouse from Oracle DB.• Experience on Snowflake Stored Procedures, Snow pipes, Tasks.• Experience on Different Snowflake Stages.• Experience on End-to-End Data Loading/Unloading using Snowflake.• Hands on experience in creation of Packages, Procedures, Functions, Cursors and creation of tables, Indexes, Sequences, Views and Constraints.• Experience in Collections like PL/SQL Tables, Nested tables, PL/SQL Bulk Collect and Ref Cursors, USER DEFINED DATATYPES(UDT).• Experienced in using Tables, Views, Synonyms, sequences, Joins and Sub Queries.• Build and deployments in Production& Test environment which includes Coding/Testing/Program Release (Bug fixing & enhancements) and to ensure that all Problems / Request / Code changes.• Used External Tables to load data from flat files into table and applying business logic • Experience in Oracle Rest Data Service (ORDS).• Experience in JSON data Processing using SQL.• Experience in using CA Automation tool for scheduling • Automated Code deployment in SIT, UAT.• Working in Agile Sprint Methodology