Snowflake, Databricks,iceDQ
Niraj Kumar Sharma
Senior QA Engineer
Pune
Summary
Senior QA Engineer analyst with 7+ Years of experience in Insurance domain, CPG domain along with SQL Service, SnowFlake, ETL Data Warehousing, Business Intelligence, PowerBI testing etc. and Experience of logging defect into JIRA, Analytical Skills, Teamwork skills, qTSET, ADB SQL, Azure data storage, MDD framework and powershell(test case configuration) automation.
Overview
2
2
Languages
7
7
years of professional experience
Work History
Senior QA Engineer
Arch Insurance
Pune
06.2024 - Current
- Policy claims and premiums analysis
- Preparation of test cases from Business Requirement
- Execution of test cases
- Sending the regular status to the higher authorities
- Participation in Scrum Meetings
- Defect logging using the defect management tool such as JIRA
- ETL testing
- SQL query preparation and execution
- Environment: Snowflake, Microsoft Azure Storage, JIRA, SSMS, MS Excel, Powershell, MDD
QA Engineer
Unilever
Pune
02.2022 - 05.2024
- Consumer Product & Goods Analysis
- Preparation of test cases from Business Requirement
- Execution of test cases
- Sending the regular status to the higher authorities
- Participation in Scrum Meeting
- Defect logging using the defect management tool such as JIRA
- Mapping sheet preparation
- RTM mapping with test cases
- Power BI testing
- ETL testing
- Environment: Azure SQL, Power BI, Citrix, SSIS
Database Tester
CMC Networks- Johannesburg-South Africa
02.2021 - 12.2021
- Activation and Provisioning System Synchronization
- Preparation of test cases from Business Requirement
- Execution of test cases
- Sending the regular status to the higher authorities
- Participation in Scrum Meeting
- Defect logging using the defect management tool such as HPALM
- Mapping sheet preparation
- Environment: SQL Server, ETL SSIS Package
Database Validation, ETL Source Target Data Validation, Metadata Validation
Spark Telecom, New Zealand
08.2020 - 01.2021
- Simplification of rating-charging solution to help service providers simplify billing related infrastructure while delivering the services.
- FRS document analyzing
- Test case design to validate customer requirement
- Mapping sheet preparation
- Checking database integrity
- Sending the regular status to the higher authorities
- Test case execution
- Logging the defect using defect management tool
- Environment: ETL, SQL, Oracle Data Integrator
Data tester, SSIS Package validation, Source target data validation
Spark Telecom, New Zealand
02.2020 - 07.2020
- Integration of Rating, Discounts, Bill Production and Real-time Processing into one solution.
- Analyze business requirements
- Updated test plans, created test cases and test scenario for assigned functional area
- Validation of null fields
- Source Target data validation
- Verify data is mapped correctly from source to target
- Verify there is no duplicity of data in the target system
- Verify transformations are applied correctly
- Test case execution
- Environment: SQL, EDI, Data Warehousing, Job Run
Big data validation, Database tester, Power BI report data validation
Spark Telecom
07.2019 - 01.2020
- Validation of Billable and Nonbillable data to ensure only Billable data is being load for payment system.
- Properly analyze Business logic
- Job Run
- File processing
- Stub Implementation
- Identification of bugs and report to senior authority
- Test Case execution
- Environment: SQL, File Processing, Unix, Power BI
Database validation, Data Warehousing, Big data analytics
Spark Telecom, New Zealand
12.2018 - 07.2019
- Spark telecom wholesale billing processes high volume of any kind of services like, Voice, Data, Messaging, Content and others.
- Source- Target data validation
- Analyze mapping sheet
- SQL query to check output to ensure it meets the business logic
- Bug logging using HPALM
- Test case execution
- Environment: SQL, Oracle Data Integrator, Big Data
Education
Bachelor of Engineering Technology - Electrical & Electronics Engineering
Visvesvaraya Technological University
Bengaluru, India 04.2001 -
Skills
Operating Systems: Microsoft Windows 10/11
Programming Languages: SQL, PL/SQL, Python
Databases: Azure SQL, SQL Server, Snowflake
Software
Timeline
Senior QA Engineer
Arch Insurance
06.2024 - Current
QA Engineer
Unilever
02.2022 - 05.2024
Database Tester
CMC Networks- Johannesburg-South Africa
02.2021 - 12.2021
Database Validation, ETL Source Target Data Validation, Metadata Validation
Spark Telecom, New Zealand
08.2020 - 01.2021
Data tester, SSIS Package validation, Source target data validation
Spark Telecom, New Zealand
02.2020 - 07.2020
Big data validation, Database tester, Power BI report data validation
Spark Telecom
07.2019 - 01.2020
Database validation, Data Warehousing, Big data analytics
Spark Telecom, New Zealand
12.2018 - 07.2019
Bachelor of Engineering Technology - Electrical & Electronics Engineering
Visvesvaraya Technological University
04.2001 -