Ramakrishna Yarapu

ETL QA

Elevance Health

Beaumont

06.2023 - Current

Currently, I am working on testing in the Health Care Project using Selenium Automation, AWS, and ETL Informatica.
Ensured that the ETL process is running as expected by troubleshooting any issues encountered during the testing cycle.
Possess complete domain and development life cycle knowledge of data warehousing.
Investigated existing production issues related to the ETL process by analyzing log files generated by various components involved in the process.
Conducted unit, integration, system, regression, and performance testing for ETL applications.
Knowledge of the Q-test tool for executing test cases.
Documented, triaged, and managed defects in software, and worked with developers to facilitate timely resolutions.
Performed end-to-end validations using SQL queries across different databases, like Oracle and Teradata.
Hands-on experience in Terraform data modules.
Developed test plans and scripts to validate ETL jobs.
Expertise in AWS services, AWS Lambda, Step Functions, EC2, EMR, and AWS CloudWatch.
Knowledge of Bitbucket, GitHub, and data transformations.
Automated infrastructure deployment using AWS CloudFormation and Terraform to enhance operational efficiency.
Implemented automation frameworks using Selenium WebDriver for smoke and regression testing.
Efficient in building scalable end-to-end data ingestion and processing solutions.
Developed the PySpark code for AWS Glue jobs and EMR.
Knowledge of the Falcon framework on job metadata, step metadata.
Extensive experience in analyzing client requirements, deriving test scenarios, designing test cases, executing tests, preparing test data, logging defects, and tracking.
Addressing all important issues and defining best practices for project support and documentation.
Well-versed in Agile and Scrum methodologies.
Knowledge in test management using JIRA.
Performed data analysis and validation on source and target data sets for the accuracy of transformation rules in ETL processes.