Nagaraju P
Senior Software QA Engineer
Bengaluru
Summary
Experienced ETL QA Engineer with over 9.7 years of expertise in ETL Testing, Data warehouse/ DWH Testing, Cloud Data Testing, Functional/ Manual Testing, Integration Testing, Regression Testing and Power BI Reports/ QPA Reports Validations.
Overview
10
10
years of professional experience
Work History
Senior Consultant
KPMG Assurance and Consulting PVT LTD
02.2023 - Current
- Collaborate with data architects, developers, and business analysts to understand ETL requirements, Architecture, Data Model, data mappings, and transformations.
- Design and implement comprehensive ETL testing strategies to validate data transformation processes and ensure high-quality data delivery.
- Lead and mentor a team of test engineers in executing test plans, test cases, and ETL testing.
- Identify, track, and report defects in ETL workflows, ensuring timely resolution and continuous improvement.
- Validated Power BI reports and performed regression, smoke, and sanity testing.
- Facilitate regular meetings and progress updates with stakeholders to communicate testing outcomes and project status.
- Role: Senior ETL Tester (ETL Testing with Azure Platform - MS Fabric)
- Methodology: Agile Model
- Tools: MS Fabric, Azure Platform (Azure DevOps, Power BI, SQL).
- Industry: Finance
Consultant
Deloitte Consulting PVT LTD
02.2019 - 02.2023
- Involved in sprint planning & sprint grooming sessions.
- Understanding Data extracts from the different source systems and design the test cases accordingly.
- Performed ETL testing, Data Ingestion Analysis with CDP framework and validation of Data Quality & Data completeness.
- Performed Test Execution and Defect logging and tracked to closure as part of sprint testing.
- Result analysis, documenting test evidence.
- Keeping Test management tool (Zephyr) and JIRA up to date.
- Performed data base testing on Azure data studio.
- Review metrics from the team members.
- Preparing Test reports and publish them to client.
- Role: ETL Cloud Tester
- Methodology: Agile Model
- Tools: JIRA, Confluence, Zephyr, Azure Portal, ADF, Data Studio, Azure Synapse, Azure explorer.
- Industry: E-Commerce
Programmer Analyst
Cognizant Technology Solutions
05.2016 - 02.2019
- User Story Analysis.
- Involved in Test Cases Design, Test Execution, Defect logging, Defect Retesting.
- Performed Functional and Regression Testing.
- Running SQL Queries in DB2 and Oracle database to fetch complex data for test scenarios.
- Executing Regression Test scripts using Selenium Web driver.
- Exposure to Facets tool. Test data setup, Claims processing, groups enrollment, member & Policy enrollment.
- Attended Daily Status Meeting and defect triage with Onsite and Offshore Team
- Preparing Test summary, Execution status, weekly status reports.
- Been a flexible team member for working in Weekends.
- Role: QA Analyst (Functional/Manual Tester)
- Methodology: Waterfall Model
- Tools: HP ALM, MS SQL, Perfecto, Facets Application, Blue Connect.
- Industry: Health care
Education
Bachelor of Technology - Electronics and Communication Engineering
Siddharth Institute of Engineering and Technology – JNTUA
Skills
ETL Testing, Data warehouse Testing, Functional & Manual Testing
Test Management Tools: HP-ALM (QC), JIRA – Confluence, Zephyr, Azure Devops (VSTS/ ADO)
Testing Methodology: Agile-SCRUM, Waterfall, Hybrid
Cloud applications: MS Fabric, Azure Portal (ADLS), Azure Data Factory (ADF), Azure Data studio, Azure Devops, Power BI
Certification
AZ-900 | Azure Fundamentals
Declaration
I hereby declare that the mentioned information is true to the best of my knowledge. Date - Place-
Timeline
AZ-900 | Azure Fundamentals
08-2023
Senior Consultant
KPMG Assurance and Consulting PVT LTD
02.2023 - Current
Consultant
Deloitte Consulting PVT LTD
02.2019 - 02.2023
Programmer Analyst
Cognizant Technology Solutions
05.2016 - 02.2019
Bachelor of Technology - Electronics and Communication Engineering
Siddharth Institute of Engineering and Technology – JNTUA