Sai Achyuth

Experience

1. Senior Data Engineer

   Cigna Healthcare

   Feb 2022 — Present · Bloomfield, CT, US

   Worked on AWS SQS to consume the data from S3 buckets. Worked with relational SQL and NoSQL databases, including Postgresql and Hadoop. Objective of this project is to build a data lake as a cloud-based solution in AWS using Apache Spark and provide visualization of the ETL orchestration using CDAP tool. Deployed applications on AWS by using Elastic Beanstalk. Integrated delivery (CI and CD) using Jenkins and puppet. Implemented Workload Management (WML) in Redshift to prioritize basic dashboard queries over more complex longer running adhoc queries. This allowed for a more reliable and faster reporting interface, giving sub-second query response for basic queries. Responsible for Designing Logical and Physical data modelling for various data sources on Confidential.designing and implementing ETL/ELT processes using Snowflake.Snowflake supports various data ingestion methods, including streaming data ingestion, which allows you to process and analyze data in near real-time. Emphasize your strong SQL skills and familiarity with SnowSQL, the command-line interface for Snowflake. Vast experience in identifying production bugs in the data using stack driver logs in GCP. Experience in building multiple Data pipelines, end to end ETL and ELT process for Data ingestion and transformation in GCP. Elastic search experience and capacity planning and cluster maintenance. Continuously looks for ways to improve and sets a very high bar in terms of quality. Implemented real time log analytics pipeline using Elastic search. Used Azure Event Grid for managing event service that enables you to easily manage events across many different Azure services and applications. Used Azure Databricks for fast, easy, and collaborative spark-based platform on Azure. Used Databricks to integrate easily with the whole Microsoft stack. Wrote spark SQL and spark scripts(pyspark) in databricks environment to validate the monthly