QA Engineer

Deepika Sandugula

QA SDET -ETL Engineer

Email: ********.*****@*******.***

Mobile: +1-703-***-****

PROFESSIONAL SUMMARY:

●Accomplished QA Engineer with 7+ years of experience in software quality assurance, specializing in ETL testing, database validation, and automation using Selenium WebDriver and Python.

●Expertise in validating large-scale data platforms and web applications across industries including healthcare, retail, and financial services.

●Skilled in Functional, Regression, Integration, GUI, UAT, Smoke, Sanity, Ad-hoc, and Compatibility testing of client-server and web-based applications.

●Proficient in designing and executing end-to-end ETL test scenarios on platforms such as Oracle, MS SQL Server, AWS Athena, Databricks, Snowflake, and Teradata.

●Hands-on experience with test automation frameworks including Selenium with TestNG, Cucumber BDD, Rest Assured, and Pytest.

●Developed modular and data-driven frameworks using Maven, Jenkins, and Git for CI/CD integration.

●Strong in REST and SOAP API testing using Postman, REST Assured, and SOAP UI, validating both JSON and XML payloads.

●Solid understanding of data warehousing concepts, including star and snowflake schemas, and experience in validating ETL flows using Informatica and SSIS.

●Proficient in writing complex SQL queries for backend data validation and reporting.

●Experienced in using test management and defect tracking tools like Jira, TestRail, ALM, QTest, Zephyr, and XRAY.

●Exposure to mobile test automation using Perfecto and Appium for Android/iOS workflows.

●Hands-on experience testing applications deployed in AWS environments, including S3, Athena, Redshift, and Lambda services.

●Experience in load and performance testing using tools like JMeter or LoadRunner to validate system responsiveness under stress.

●Collaborated with cross-functional teams using BDD practices to align test scenarios with business requirements and ensure coverage traceability

●Experienced in automation reporting, version control (Git), and collaborative agile testing environments.

EDUCATION DETAILS:

Bachelor of Technology (B.Tech) in Computer Science Engineering 2013 – 2017

TKR College of Engineering, Hyderabad, India

TECHNICAL EXPERTISE:

●Programming Languages: Java, Python, SQL, PL/SQL

●Automation Tools: Selenium WebDriver, Selenium IDE, Appium, Postman, REST Assured

●Test Management Tools: TestRail, Zephyr

●Defect Tracking Tools: Jira, ALM

●Databases: Oracle, MySQL, PostgreSQL, Microsoft SQL Server, AWS Athena, AWS S3, Snowflake, Databricks, Salesforce

●Frameworks: TestNG, JUnit, Cucumber BDD, Page Object Model (POM)

●CI/CD Tools: Jenkins, Maven, Git, Bitbucket

●Operating Systems: Windows, Unix/Linux, macOS

●Testing Methodologies: Agile (Scrum), Waterfall, SDLC, STLC, DevOps Testing, Bug Life Cycle

●Testing Types: Manual Testing, UI Testing, Functional Testing, Regression Testing, Smoke Testing, Sanity Testing, End-to-End (E2E) Testing, API Testing, Accessibility Testing

ACHIEVEMENTS:

Received the 'Spot Award' five times at Deloitte for consistently delivering high-impact results and contributing to the successful launch of multiple critical client projects.

PROFESSIONAL EXPERIENCE:

Deloitte USI – Boston, MA January 2022 – Present

Senior QA Engineer

Client: Healthcare – Fresenius Medical Care

Responsibilities:

●Analyzed business requirements and created comprehensive test plans, test cases, and validation strategies for healthcare data applications.

●Designed and executed software validation protocols for medical data workflows, ensuring compliance with industry standards and regulatory guidelines.

●Performed end-to-end ETL testing for data migration from legacy systems to cloud platforms such as AWS S3, Redshift, Snowflake, and Databricks.

●Validated source-to-target data mapping, transformation logic, and load processes using SQL and automation scripts.

●Automated data validation using reusable Python scripts to support data quality checks across multiple databases (Oracle, SQL Server).

●Conducted high-volume data testing, profiling, and aggregation validations using complex SQL queries.

●Validated REST and SOAP APIs using Postman and SoapUI to ensure integration reliability across healthcare systems (e.g., EHR platforms).

●Supported CAPA activities and maintained traceability matrices using Jira and Windchill.

●Participated in Agile ceremonies including sprint planning, daily stand-ups, retrospectives, and release readiness reviews.

●Performed UAT testing with business stakeholders and validated BI dashboards against backend data sources.

●Led defect triage, go/no-go meetings, and ensured timely updates of project artifacts and checklists for deployments.

●Collaborated with ETL developers, business analysts, and data architects to resolve mapping and transformation logic issues.

●Write and execute complex SQL queries to validate data transformations and aggregations across large datasets.

●End-to-end testing of legacy to new system migrations, data profiling, volume testing.

Environment: Selenium, Oracle, SQL Server, AWS (Athena, S3, Redshift), Snowflake, Databricks, Postman, SoapUI, JIRA, Windchill

Tripod Software Solutions Pvt Ltd – India January 2020 – December 2022

QA Automation Engineer

Clients: RL Datix, PVH – Tommy & CK, Floor & Decor

Responsibilities:

●Participated in Agile ceremonies including daily stand-ups, sprint planning, and backlog refinement sessions to align QA activities with development goals.

●Analyzed business and functional requirements, created detailed test plans, test scenarios, and manual/automated test cases to support feature validation.

●Performed functional, integration, regression, and smoke testing for web-based retail and healthcare applications.

●Designed and implemented behavior-driven (BDD) automation frameworks using Selenium WebDriver, Java, TestNG, and Cucumber (Gherkin syntax).

●Developed and maintained feature files, step definitions, and reusable methods to validate end-to-end UI workflows across multiple platforms.

●Executed automated test scripts using Java (Eclipse IDE) and validated application behavior across regression cycles.

●Collaborated with developers and peers to clarify test data, user flows, and technical issues; participated in defect triage and review meetings.

●Conducted UI-to-report end-to-end validations and submitted sprint-based coverage and defect reports.

●Utilized Postman for basic API validations and GitHub for source control and versioning of test scripts.

●Used Jira for test case tracking, issue management, and release coordination.

●Participated in pre-prod and production release testing, ensuring smooth deployment and verification of user-critical workflows.

Environment: Selenium WebDriver, Java, Eclipse, TestNG, Cucumber, Postman, JIRA, GitHub, Splunk, Teradata.

LoginSoft Pvt Ltd – India January 2019 – December 2019

QA Engineer

Responsibilities:

●Developed and executed automated test scripts in Java using Eclipse IDE and TestNG framework.

●Performed functional, regression, smoke, UAT, and acceptance testing for web-based applications using Selenium WebDriver.

●Designed test scenarios and located web elements using XPath, CSS Selectors, and handled dynamic/static objects effectively.

●Conducted backend database validation using SQL queries (CRUD operations) to ensure data integrity and extraction accuracy.

●Performed API testing using Postman for JSON responses and SOAP UI for XML-based web services.

●Participated in accessibility testing using JAWS, keyboard navigation checks, and color contrast analyzer.

●Executed regression test suites across multiple browsers and environments; triggered builds and tests via Jenkins CI pipeline.

●Utilized Bitbucket for version control and collaborated with DevOps team to validate production fixes and deployment testing.

●Participated in Agile/Scrum ceremonies including QA sync-ups, defect triage, and project status meetings.

●Provided onboarding support and environment setup documentation for new QA team members.

Environment: Java, Selenium WebDriver, Eclipse, TestNG, SQL Server, SOAP UI, Postman, Jenkins, Bitbucket, Accessibility Tools (JAWS, Color Contrast Analyzer)

Contact this candidate