Sr ETL / BI Test Analyst Resume

SUMMARY

Around 14 + years of extensive QA experience in Telecom,Automotive and Banking domain
Experienced in managing teams and deliverables.
Experienced in identifying Test Requirements, creation and execution of Test Cases, analyzing Test Results, report and track defects in manual and automation testing.
Proficient in Functional,Integration, Regression,User Acceptance,Load/Stress,Database Backend and Performance Testing.
Experienced in DWH testing including ETL processes and Reporting
Good knowledge in Dataware housing
Well experienced in GUI testing
Experience on testing tools like Microsoft Visual Studio Team system,SilkTest,Rational Test Real Time and Rational Robot
Experience in reporting status for Bug life cycle
Experience in writing test cases and tracking bugs in Mercury Quality Center,TFS & MTM
Experience in handling QA team and managing the resources as Module Leader
Have a very sound knowledge of various SDLC,STLC processes and Agile methodology
Experienced in Backend testing, validating database integrity, verify/modify user data by executing advanced SQL queries on Oracle,Hive,Sybase and SQL servers
Experience in interacting with end business customers
Quick adaptability to new technologies and new concepts
Excellent written & verbal communications
Good analytical and problem solving skills

TECHNICAL SKILLS

Windows 95/98/NT/2000/XP, Linu ix
Core Java, C,C++
Microsoft VSTS,Silk Test,Rational Test Real Time and Rational Robot
Team Foundation Server ,Jama, Quality Center ,Test Director,Dev Track and Test Depot
Informatica 10 ,Business Objects, SSIS & Looker
Oracle, Sybase,AWS RDS and SQL Server 2008
Visual Source Safe
Autosys ,Cisco Scheduler
Putty,Toad,httpwatch,Splunk,Rapidsql and Fiddler

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL / BI Test Analyst

Responsibilities:

Creating Test Plans, writing test cases and scripts, test case execution
Writing SQL queries for source and target systems to verify the data for the ETL and BO Report validations
Flat files validations using Unix Script
Implementing(coding) ETL logic in the SQL scripts used for testing.
Upgrade testing of BO WebIntelligence and Desktop Intelligence during Service Pack/Fix Pack upgrades
Validating ETL process by the following methods - Counts, Validation Source (vs) Target, Data transformation correctness based on the Business Rules
Validation of data correctness into Datalake using Hive/Impala Queries
Validation of Change Data Capture in ETL’s
Negative testing with invalid test data
Performance/volume testing with high volumes of data
Execution of regression test scenarios.
Created test data using python
Creating Requirements traceability matrix
Participated in Behavior Driven Development (BDD) group exercises
Validating the data with Adhoc reports from BO.
Verification of Data Quality
Supporting UAT for Business Users
Webservice Testing/Automation using SOAPUi

Confidential

Staff - Software QA Engineer

Responsibilities:

Test Plan, Test Cases and Traceability matrix creation
Web based testing on Cross browser and operating systems
End to End testing including Database Results
New Features and regression Testing
External Interfaces and FIX testing
Test Environment/Harness Setup
Release management to Beta Users/Production
Prelim production support for the post release
GUI testing for the application for cross browsers/operating systems
Test Plan and Test Cases Creation and Execution
Validation of ETL processes
Validation of Data correctness in Flat Files
End to End Testing of data flow (Source to Target testing after data is transformed)
Job restarts testing - to validate data gets loaded properly after the restart
ETL logic testing- Data transformed according to the business rules
Report testing and Validations
Batch jobs Running and File watcher/Dependency Testing
Quality assurance for Database migrations
Test Environment/Harness Setup
Coordinating prod releases
Prelim production support for the post release