Stuti Gupta
Data Analyst Tester @Davies
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst Tester @Davies
London, GB
Developed and prepared Standard data dictionaries for the different source systems for reporting purposes/development of new DWH.• Developed the detailed test strategy for DWH team & reporting team.• Developed an end to end understanding of existing process, internal systems /applications.• Liaising the technical issues with operations team and collaborating between different teams for resolutions.• Gain a comprehensive understanding of claim process for Niche & Motor claims.• Raised & Logged data quality issues while testing the new DWH and daily reports.• Collaborated with cross-functional teams to identify, troubleshoot, and resolve data-related issues.
EDUCATION
RGEC Meerut
Btech, Electronics & Instrumentation
Queen Mary University of London
Master's degree, Investment and Finance
SKILLS
ABOUT STUTI GUPTA
Understanding of Software Testing Life Cycle (STLC) & SDLC.• Manual Testing, Automation testing (API, UI, Web application, databases).• ETL,Databases Automation ( tSQLT framework, DBT framework)• Functional & Non-functional Testing, UAT testing, Regression testing, System integration, Sanity & Smoke testing• ETL tools-> SSIS, ADF & Informatica• ETL/ELT process, Data Warehouse, Star and Snowflake schema• Working experience in Agile methodology, Microsoft Azure Cloud platforms, AWS data pipelines,Azure Devops (SCRUM, Kanban), Jeera• Analysing technical requirements / User stories, Test estimations. • T-SQL and databases (Azure SQL database, SQL Server 2008 R2/2012, BVD and D&B).• Experience on Azure Blob Storage and Data Lake.(Parquet, Flat Files and JSON etc.)• Debugging & testing ADF pipelines.• AWS Lambda functions,Redshift, Dynamo DB,S3 bucket,event bridge scheduler, cloud watch logs,SNS,SQS queue,SES.• Validating data sources, extraction of data, applying transformation logic & loading data in to target tables.• Providing ETL/DWH trainings to new team members• Develop and execute Regression test for critical releases within timely order.• Lead/supported the test management in developing project plans.• Actively participated in cross functional trainings (Power BI, Azure Cloud etc)• Work closely with development team to provide required information and help to deliver / deploy urgent features.• Lead/participate in defect triage discussions and raise development perception of severity.• Interrogate the databases and execute SQL to prove the test results.• Escalate risks & issues to the appropriate level to ensure resolution.• Performed testing on multiple environments for Hot fixes to support the production issues in strict timelines.• Monitoring and identify data quality issues & escalated to the relevant team member.• MS SSIS (SQL Server Integration Services); Technical Specification Analysis• Data Analysis, Data Validation, Data modelling, Data Cleansing, Data Verification.• Diagnose, track, and clearly document defects found, Experience with writing SQL queries.• Good understanding of API and web testing; Understanding of REST API types (GET, PUT, POST, DELETE)• Build effective test cases that are used for manual and automation testing.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.