Aiswarya Kumar Sahoo Email & Phone Number

Kolkata, West Bengal, India

Kolkata, West Bengal, India

o Designed and implemented a scalable data pipeline using AWS Glue and PySpark to process more than 1 million records from data base or APIs daily and achieving 30% reduction in processing time. o Migrated data from Db2 to AWS S3 in required format using AWS DMS , AWS Lambda and resolved defects after providing root cause by thorough data analysis. o Build and deployed automated data pipelines using AWS Eventbridge, SQS and SNS and migrated cleaned data by through monitoring. o Developed ETL processes using Snowflake utilities such as Snow SQL and Snow Pipe to extract, transform, and load data into Snowflake from AWS S3 bucket. o Gathered information from the stakeholders on ETL data mapping documents, ETL design documents and created SQL scripts by analyzing the documents. o Designed and developed tool in Python to automate the test cases in AWS cloud, Sybase and DB2 resulting improved efficiency and reliability and reducing manual effort and defect leak by 90%. o Identified test data and created test cases based on the understanding of the requirements. Developed test strategies to provide data warehousing solutions and 0% defect leakage. o Improved data quality by analyzing data and identified defects and meaningful solutions in AWS, DB2 and Snowflake environment. o Acquainted in sprint planning, Documenting Test Plan and Test strategy.

Hyderabad, Telangana, India

Working as an ETL tester to test and analyze data using Manual or Automation method using Python. Dealing with Data landing and Validation with SQL queries. Created complex SQL scripts to get the the data from various databases like snowflake,SQL Server,My SQl Workbench and Sybase and identified performance issue of the SQL queries. Automated testing Jobs using Python script. Performed Job run, Test Case Preparation and Execution. Trained on Data integration and Pipeline creation using SSIS or Azure Data factory. Identified Defects by Comparing Files and Data between different databases. Worked on variousMigration ETL projects for testing migrated data loaded from one heterogeneous databases to other databases. Created and mentained tasks using Rally.