Quality Assurance Qa Engineer

SUPRIYA KUTE

QUALITY ASSURANCE ENGINEER

+1-669-***-**** *************@*****.*** Albany, NY linkedin.com/in/supriya-kute-93932582 Professional Summary

Detail-oriented QA Engineer with 10+ years of experience in data warehousing, ETL tesOng, and data integraOon, with a strong emphasis on Snowflake, InformaOca, and SQL. Skilled in validaOng complex data pipelines, ensuring data quality and consistency, and opOmizing performance in large-scale data migraOon projects. Skills & Expertise

• Databases Management: SQL-Server, Oracle, Hue, MongoDB, Postgres, Snowflake

• ETL Tools: InformaOca PowerCenter 9.1, Ab IniOo

• Tes2ng Tools: HP Quality Center, JIRA, SPIRA, Azure DevOps, Rally, Visual Studio

• Other Tools: MicroStrategy, WinSCP, Puay, Control-M, Postman, Kibana, BrowserStack

• Methodology: Agile, Scrum, Waterfall

Professional Summary

• Experienced in working on Informa2ca PowerCenter tool as a tester and worked on Snowflake stored procedures

• Performed record count checks and validated rejected records between source and target tables

• Handled mul2ple feed file processing and ensured accurate data loads into FDW

• ExperOse in relaOonal databases like Oracle, SQL Server, MongoDB, and Hue

• Tested InformaOca mappings based on SCD-1 and SCD-2 methodologies

• Experienced in automa2ng SQL-based ETL test cases using C# in Visual Studio, ensuring efficient and repeatable data validaOon processes

• Involved in idenOfying and fixing failed regression test cases as part of C#-based automa2on in Visual Studio, ensuring stability and reliability of the test suite Tested ETL mappings across staging, source, and data warehouse environments

• Performed field size valida2on and constraint checks

• Experienced with PHI, PII, and sensiOve data handling

• Validated data mapping and flow from ODS to staging and staging to EDW

• Validated reports and performed count checks in MSI reporOng layer

• Good understanding of data warehouse concepts including star and snowflake schemas

• Skilled in wriOng SQL queries for backend tesOng, data validaOon, and quality checks using ETL mapping sheets

• Assisted in funcOonal tesOng of new systems as per user specificaOons

• Basic understanding of CI/CD pipelines and deployment workflows

• Experienced in Agile environments, including sprint planning, refinement, and retrospecOves

• Hands-on experience with UNIX commands for tesOng and data handling

• Performed funcOonality, integraOon, system, UAT, and regression tesOng across applicaOons

• Collaborated with ETL teams, acquisi2on teams, and business analysts for data mapping valida2on

• Worked closely with test analysts and IT developers in team environments

• Short-term onsite experience at client locaOon in London, UK for project transiOon and knowledge transfer

• Domain experience includes telecommunica2ons, agriculture, reinsurance, insurance, and banking SUPRIYA KUTE

Work Experience

QA Analyst Aug 2023 - Present

TEKsystems, New York, USA (Client: CHS)

• Collaborated with CHS (agribusiness) on a complex finance technology project within the data analyOcs team

• Fixed failed regression automaOon test cases and developed new test scripts using C# in Visual Studio

• Validated newly developed tables, views, and transformaOon logic sourced from mulOple systems by wriOng and execuOng complex SQL queries with CTE’s. Also, conducted source-to-target data comparisons across modeled, processed, and consumpOon layers in Snowflake

• Performed data ingesOon tesOng across SAP, Salesforce and Snowflake environments

• Created and executed ETL test cases in Azure DevOps, including defect retesOng and automaOon test maintenance

• Performed data reconciliaOon and data quality checks to ensure transformaOon logic accuracy

• Collaborated with developers and business analysts to idenOfy data discrepancies and opOmize data flow

• Executed test cases for new data flows, API integraOon, and regression tesOng using Postman and Azure DevOps

• Tracked bugs, defects, and enhancements using Azure DevOps Test Analyst Nov 2022 – Jul 2023

Cognizant, New York, USA (Client: Comcast)

• Worked with Comcast, a telecommunicaOons client, on a complex data integraOon project

• Designed and executed ETL test cases and Snowflake stored procedures

• Generated and processed ETL ASN files using Rundeck and Pentaho

• Performed data validaOon using complex SQL queries and conducted API integraOon tesOng via Postman

• Tested new features, including onboarding of CTDI logisOcs data, through API and ETL validaOons

• Coordinated with onshore and offshore teams, conducOng daily sync-ups and collaboraOng with mulOple development teams (XM, Comcast, CTDI) to resolve issues

• Tracked defects, maintained test metrics, and prepared daily status reports using JIRA Associate Consultant Jun 2021 – Feb 2022

ITI Data, Pune, India (Client: ANZ Bank)

• Performed API tesOng using Postman

• Worked on basic graphs CreaOon and data verificaOon using Ab IniOo

• Created ETL test cases, executed SQL queries using SQL, Mongo DB and Hue and validated data

• SCD1, SCD2 mappings tesOng between source, pre-staging, staging and warehouse tables

• Executed regression and funcOonality tests and implemented test plans

• UOlized a tracking system to track reported bugs, defects and enhancements using JIRA Software Quality Assurance Analyst Jun 2019 – Jun 2021 Wolters Kluwer, Pune, India

• Worked on the CCH Central UK-based product in the tax and accounOng domain

• Analyzed business requirements to derive detailed test requirements

• Designed and executed test cases for new features and regression tesOng within Agile sprints

• Ensured adherence to QA processes, including compliance and service pack release cycles

• Performed data analysis and validaOon by wriOng complex SQL queries for quality checks

• Conducted funcOonal tesOng based on change requests and tracked defects throughout the test lifecycle SUPRIYA KUTE

• Collaborated effecOvely with business analysts and development teams to clarify requirements and resolve issues

Test Analyst Oct 2018 – May 2019

Infosys, Pune, India (Client: Deutsche Bank)

• Processed data from various sources to FDW using InformaOca and prepared SIT/UAT environments

• Validated feed files and ensured data consistency across SIT, UAT, and PROD

• Tested SCD1/SCD2 mappings across ETL layers and performed database validaOons using SQL

• Created data slices, verified MSI reports, and handled defect analysis and test reporOng Associate Consultant May 2014 – Oct 2018

Capgemini, Pune, India (Client: SCOR, HSBC, AIG)

• Performed ETL and funcOonal tesOng for reinsurance (SCOR) and insurance (AIG) projects, focusing on data migraOon, validaOon, and consistency between source and target systems

• Designed and executed test cases for databases and data warehouse system

• Analyzed business requirements to define test scenarios and created SQL-based test data

• Conducted regression and new feature tesOng, and managed defects throughout the test lifecycle Education

Diploma in Advanced Computing CDAC, Pune, India Aug 2013 Bachelor of Engineering Pune University, Pune, India May 2012 Certifications

ISTQB Certified Tester Foundation Level) Credential Id: 22771 Jul 2014

Contact this candidate