AISWARYA SAHOO

Designed and developed Snowflake data warehousing solutions to support business requirements. Developed ETL processes using Snowflake utilities such as SnowSQL and Snow Pipe to extract, transform, and load data into Snowflake from AWS S3 bucket. Gathered information from the stakeholders on ETL data mapping documents, ETL design documents and created SQL scripts by analyzing the documents. Designed automated script to execute the test cases using Python. Based on signed off test scenarios, identified test data and created test cases based on the understanding of the requirements. Designed and implemented data models and schemas using Snowflake's database objects such as tables, views, and indexes. Improved data quality by analyzing data and identified defects and meaningful solutions using Python automation.

Migrated data using Sqoop from on-premises to Hadoop for full load and incremental load and automated the process. Created partitions and buckets for analytical processing using hive. Optimized data on HBase. Transformed data in databricks and Eclipse IDE with Scala, PySpark and Spark SQL and created data pipeline using Azure data factory.