Madhusmita Ranu

Accomplished and energetic learner with 4.6 years of experience in Functional, ETL, Automation and Performance Testing, proficient in Agile and Waterfall methodologies, with expertise in banking, finance, healthcare, and retail domains. Skilled in Requirement Analysis, end-to-end Testing, and effective communication. Experienced in various testing tools and technologies including Snowflake, Informatica PowerCenter, ESP, Selenium, JMeter, LoadRunner, Oracle with proven track record of collaborating with cross-functional teams to deliver high-quality data solutions effectively. Bringing in-depth experience in Finance, Banking, Healthcare and Retail Industry. Succeeds in high-pressure environments while meeting business needs and project expectations. Expertise in Requirement review, Test Design, Test Script Development, Execution & Reporting. Orchestrated ETL testing efforts across multiple teams, ensuring timely delivery of high-quality data with Snowflake. Comparing the number of records in the source data against the target Snowflake table to ensure no data loss during loading. Designed and executed 500+ test cases across data staging, ODS, and data marts. Collaborated with data engineers to establish QA gates & go/no-go criteria for ETL deployments. Design and maintain scalable automation frameworks and develop automation scripts for UI/API testing using Playwright and create performance test scripts using JMeter and LoadRunner. Developed and executed ETL test cases using SQL, covering data completeness, data quality, and business logic validation. Validate transformations like: Lookup, Joiner, Aggregator, Filter and Expression and ensure business rules are correctly implemented. Perform checks for: Null values, Duplicate records, Data truncation, Referential integrity and validate primary/foreign key relationships.