ETL and Reporting QA Resume

SUMMARY

9+ years of experience in Data Analysis, Quality Assurance, Testing process, Testing methodologies and strong experience on STLC and overall testing approaches.
Experience in ETL (Ab Initio,Informatica) Testing, Database (Oracle & Teradata) Development and Testing.
DataBase validation Source, Stage, destination using complex sql queries
Extensive experience in Functional, Integration, Regression, User Acceptance, System and Batch Testing.
Worked on developing Test Plan,Test Strategy,Test Case,Test Result .
Worked on Oracle Package, Function, Procedure, Triggers as a developer and tester.
Extracting defect status reports and managing defect status using the Quality center / ALM, Bugzilla, Jira, Clear Quest and also conducting defect status calls.
Excellent working experience in RDBMS technologies like Oracle, Teradata, DB2 and MYSQL.
Experience working in Agile methodology.

TECHNICAL SKILLS

Testing Tools: ALM, QC, Selenium, SoapUI

Databases: Oracle, DB2, MySQL, MS Excel, Teradata

Tools: / Products: Ushacomm Billing System Unicorn, Crystal report, Nikira (Fraud Management), Teradata and Ab Initio, Eclipse

Reporting Tools: Business Objects XIR2

Other tools: Maven, Eclipse, GitHub,Perforce,Jira

Operating Systems: Windows 95/98/2000/XP, Linux and UNIX.

Programming languages: SQL, PL/SQL, Java

PROFESSIONAL EXPERIENCE

Confidential

ETL and Reporting QA

Responsibilities:

Environment: Oracle, Informatica, TES, BO

Confidential

Data Analyst

Responsibilities:

Performed all database related work in the team.
EBCDIC, ASCII copybook, DML conversion,Data Mapping.
Data Analysis, data loading, test data preparation, data validation using complex sql queries.
ETL testing, support ETL developer, troubleshooting.
Release deployment and handle all release related activity.

Environment: Oracle,Data Mapping,Ab - Initio,Unix,SVN

Confidential, Mountain View, CA

QA Engineer

Responsibilities:

Performed testing of software web applications(Norton eBiz) including Functional and Regression testing.
Api Testing.
Involved in Selenium Script creation and execution.
Web testing for different template in different env.
Release deployment using Jenkins.
Database validation using Oracle sql Developer.

Environment: Selenium Webdriver, Python, Java, UNIX, Eclipse, Perforce, Agile,Postman,Perforce,Oracle