Anusha T

About Anusha T

An IT professional with about 8 years of experience who is self-driven and…

Experience

1. Sr Data Engineer

   Homesite Insurance

   Mar 2021 — Present

   Involved in building data pipelines to extract transform and load the raw data and perform analytics on the transformed data using AWS services S3, Glue, Redshift, EMR, RDS, Dynamo DB, Lambda, Athena, KMS focusing on high-availability, fault tolerance, and auto-scaling using AWS Cloud Formation.*Worked as Tableau Server Administrator and Tableau desktop developer. Responsible for Preparing the Report Design specifications based on the User\'s requirement.*Design and Develop ETL Processes using AWS Glue to migrate the data collected from external sources like S3, SQL Server, Mongo DB, and SFTP server into AWS Redshift.*Worked in creating Redshift spectrum external schema and tables for S3 data on Redshift upon running instance and query S3 data from Redshift and load data into other fact and dimension tables, rather than using COPY command if data volume is huge.*Worked in Setting up and Accessing AWS Dynamo DB Env and Creation of Tables, on Demand Backup, and access control etc.*Worked with Spark using Spark Context, Spark-SQL, Scala, PySpark, Data Frame API, Pair RDD, Spark Streaming, MLlib and User Defined Functions to apply transformations on the Data.*Worked on migrating the data from AWS Redshift data warehouse to Snowflake.*Developed data ingestion modules (both real time and batch data load) to data into various layers in S3, Redshift and Snowflake using AWS Kinesis, AWS Glue, AWS Lambda and AWS Step Functions