Santhosh Bussa

IT professional with an MS from Stratford University (USA) and an experience of 13 + years across IT industry in Quality assurance for SDET & Client/Server applications testing. A competent (ISTQB) Certified Testing professional with 8 years of experience in Software Quality Assurance, ETL/Database/BI reports and Manual Testing that includes Requirement Reviews, Test Case Designing, Execution, Defect Identification and Tracking.

Experience in SDLC and STLC and worked with Waterfall, Agile/SCRUM, SAFe(Scaled Agile Framework), V-Model Methodologies. Strong knowledge of test methodologies & Software Development Life Cycle while efficient in writing SQL scripts, SQL queries to conduct database & ETL testing, RDBMS and Informatica testing.

Experience with AWS Cloud Watch for troubleshooting test failures. Expert in Test case management and Bug tracking tools such as Azure DevOps and Jira/Zephyr.

CVS

(2025-07)

HealthFirst (Virtusa)

(2024-12 - 2025-06)

SDET/ETL/BI/QA Test Lead - Elevancehealth

(2022-05 - 2024-11)

• Verified mappings to extract data from SQL Server, Oracle and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting
• Optimize ELT workloads against Hadoop file system implementing HIVE SQL for transformation
• Understanding the requirements of several project managers and their strategies for agile project
• Developing automation test scripts using Selenium WebDriver, Java Cucumber, Gherkins, Postman etc., for UI and API testing
• Authored test cases using Jira ensuring comprehensive coverage of requirements
• Hands-on experience in manual execution during certification processes, ensuring the reliability and functionality of software products
• Maintaining test data integrity and relevance throughout testing phases with scalable test data management practices
• Meetings with business/user groups to understand the business process, gather requirements, analyze, design, development, and implementation according to client requirement
• Worked with ICEDQ Automation ETL Tool to validate large volume of data between Hive and Snowflake system
• Created rules and scheduled jobs using ICEDQ tool which almost works like QuerySurge
• Participated in project walk-through meetings with the Project Manager, Test Team Lead, DEV team and Business System Analysts to get a clear understanding of the business, specific needs of the project and the applications being used in house
• Discussed test results with developers and project team members to isolate defects and problem resolution
• Involved in developing BDD framework from scratch
• Collaborate with other teams and team members to troubleshoot issues that threatened or stopped testing
• Involved in Smoke Testing, Regression Testing and User Acceptance Testing
• Wrote and executed SQL queries and Joins, Group By clause, having clause etc. to validate the data
• Involved in planning test execution activities, defect reporting and analyzing test metrics
• Led a 3-member offshore team in India
• Contributed to the high scale deliverables in a tight timeline
• Involved in using SQL to query QNXT tables as well as supporting the integration of claims test pro
• Maintained all testing related artifacts in Azure Devops boards and updated all the branches correctly
• Worked as Test Lead and handled both Onshore and Offshore teams in giving tasks and taking regular updates from team members

Sr. SDET QA Analyst - Wells Fargo - Charlotte, NC

(2016-08 - 2022-04)

• Verified mappings to extract data from SQL Server, Oracle and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting
• Developed Test Cases for ETL Data Validation History load and incremental load using business rule mapping document and business requirements
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Used UNIX environment variables in All the Ab Initio Graphs
• Understanding business requirements: Understanding the business requirement document is an important responsibility for Ab Initio testing
• Developing test environments: Ab Initio test environments are developed for UAT testing
• Implemented test automation using tools from HP (QTP and Test Director/Quality Centre)
• Validating the data thru various stages of data movement from staging to Data Warehouse tables
• Involved in UNIX shell scripting and configuring corn-jobs and Control-M jobs for ETL Loads
• Analysed the log file for an ETL job in SAP BODS and reported to developer
• Worked with Control-M jobs to run entire 1VMDR box or individual list of jobs
• Meetings with business/user groups to understand the business process, gather requirements, analyze, design, development, and implementation according to client requirement
• Designing and Developing Azure Data Factory (ADF) extensively for ingesting data from different source systems like relational and non-relational to meet business functional requirements
• Interacted with several Investment banks to support UAT testing for them
• Validated the dashboards in production and ensured the data was up to date by scheduling extract refreshes
• Creating pipelines, data flows and complex data transformations and manipulations using ADF and PySpark with Databricks
• Support Test scenario identification for Automated regression suite, Helped automating the build and deployment pipelines
• Working on Jira user stories assigned and participate in Scrum ceremonies like Standups, Planning etc., and Involve in design discussions as needed
• Create & Maintaining automation scripts for updated functionalities, and Execute the automation regression suit test cases using Selenium WebDriver
• Executed and monitoring jobs through Control-M
• Employing an array of technological tools to integrate with 3rd-party data systems
• Experience with data management tools (SQL, Snowflake)
• Have good exposure to Test Data management using different upstream systems
• Ingested huge volume and variety of data from disparate source systems into Azure DataLake Gen2 using Azure Data Factory V2
• Created several Databricks Spark jobs with Pyspark to perform several tables to table operations
• Performed data flow transformation using the data flow activity

Sr ETL Test Engineer - Prolific Corporation Pvt Ltd

(2013-04 - 2016-07)

Testing Type: Data Ware House (DWH)/ETL & Database Testing. Project Title: OMSD1/2/3. Project Description: Primary objective of OMSD is to sunset legacy applications and leverage out of box Sterling OMS capabilities to improve business processes, and

MS - Engineering - Stratford University (2009)

B. Tech - Computer Science - JNTUC (2007)