Tejasri Rao

About Tejasri Rao

Around 8+ years of experience in Analysis, Architecture, Design, Development, Testing…

Experience

1. Senior Etl Developer

   Credit Acceptance

   Jun 2023 — Present · Southfield, MI, US

   In my Current project, I was responsible for designing, deploying, and managing scalable and secure AWS cloud infrastructure. This included provisioning and configuring EC2 instances, setting up networking components, and managing various services like Amazon S3, RDS, Lambda, and DynamoDB. One of my key tasks was using AWS Lambda to handle data validation, filtering, sorting, and other transformations whenever data changed in a DynamoDB table, and then loading the transformed data to another data store.To ensure data quality, I implemented thorough checks using AWS Glue Data Brew and Cloud data quality tools for detailed validation. I also programmed ETL functions to move data between Oracle and Amazon Redshift, performing complex transformations such as normalization, deduplication, and aggregation to prepare data for analytical use. I integrated dbt with our existing ETL pipelines, which streamlined the data transformation processes and significantly improved efficiency.Ensured data accuracy and quality using Talend Data Quality tools before loading data into the warehouse.My proficiency in optimizing SQL-based ETL processes came in handy, as I improved data integration and transformation efficiency while maintaining meticulous version control and comprehensive documentation for all ETL processes and data models. AWS Glue was instrumental in extracting data from diverse sources, which I then stored in S3 as raw data. I designed and maintained complex SSIS packages to ensure robust and scalable data warehousing solutions. My work involved building data warehouse structures, creating facts, dimensions, and aggregate tables using dimensional modeling, and employing Star and Snowflake schemas. I also wrote robust code in languages supported by Databricks, such as Python, Scala, and SQL, and used Hive to analyze partitioned data and compute various metrics for reporting.