Etl Tester Qa

Chandni Sehgal

** ********** ***, **** *****, PA

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

Phone 610-***-****

SUMMARY

Four years of IT experience in analysis, testing and implementation of business intelligence solutions using Data warehouse/data mart design, ETL, OLAP, client/server application.

ETL tester with solid understanding of data models identification and source to target mapping and testing schemas.

Possesses extensive knowledge of verification processes and data sample comparisons.

Expertise in creating test scenarios in order to test applications.

Good working experience in oracle, DB2, SSMS, IBM Netezza, JIRA

Experience in functional, regression, data integration, business intelligence and User acceptance testing

Extensively used ETL methodologies for supporting data extraction transformation and loading using Informatica

Experience in writing sql statements to validate the database systems and backend database systems

Involved in on shore and off shore meetings to work closely in completing project requirements/needs

EXPERIENCE

BI QA ANALYST- V3 SOFT CLIENT-DAVITA

October 2019 –till present

Extensive experience in ETL, Datawarehouse and BI intelligence report testing

ETL experience using informatica client tools

Experience and understanding in SDLC: waterfall, agile, iterative and incremental

Validating data based on mapping document and business rules

Experience with analytical skills for understanding business requirements

Strongly participated and supported UAT and GUI testing

Knowledge of database systems- Oracle, SQL server, PL-SQL, Acoustic

Work closely with software on-shore/off-shore developers/product owners and BAs to develop and execute thorough test scenarios in all data integration and business integration projects

Validation of data transformations and perform End-to-End data checks for ETL & BI systems

Develop and execute detailed ETL related functional, integration and regression test cases

Test based on BRD and requirement documents

Communicate and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project releases

Worked on various tools like Toad for oracle, SQL server management studio and Jira.

Supported UAT by creating test data in QA environment

Executed SQL queries to retrieve data in Netezza, sql server management studio, Oracle systems

Performed multiple projects simultaneously

Worked on Data integration, Application integration, Business intelligence and Salesforce projects

Mentored newly joined analysts to bring them up to speed

Documented test results in Jira and ALM

QA TESTER- PERFORMANCE SYSTEM DEVELOPMENT

September 2018– December 2018

Performed end to end testing

Participated in scrum meetings

Attended QA meetings daily

Lead QA meetings

Performed data validation

Executed API testing with developer’s instruction

Mobile tool testing

QA TESTER- EVEREST CUSTOMER SOLUTIONS

January 2017 – January 2018

Created Test Scripts from Requirement Specification Document

Designed and executed test cases

Tested applications on different browsers like chrome, IE and Safari and on various devices like mobile and iPad

Maintained, updated and created Test cases using MS Excel

Performed functional, regression, end to end, GUI and acceptance testing

Reported critical and valuable bugs to the test manager using JIRA

Executed SQL queries to perform backend testing

Performed functional testing to certify the stability and usability of software system

Reported software failures so that bugs may be discovered and corrected and once fixed gets retested

SKILLS

Strong knowledge in ALM-Quality Center, JIRA, Microsoft suite

Experience in SQL scripting

Hands-on experience in SQL server management studio, PL-SQL, Toad, Oracle, Salesforce workbench

Highly motivated and dedicated, able to work independently

Strong background in both Agile/Waterfall Methodologies

Manual/ functional Testing, backend testing, front end testing, system integration testing, smoke testing, regression testing, cross browser testing, mobile testing

Master’s degree in English literature from India, Kurukshetra university, 1997

Contact this candidate