PROFESSIONAL SUMMARY:

• Over 5+ years of experience as an ETL Tester and Software Quality Analyst with experience in Healthcare, Banking and Retail domain.
• Proficient in performing ETL, BI and backend manual testing.
• Experience with Initial and Incremental load testing within ETL Testing.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Experience in preparation of Test Cases and to ensure detailed test process wrote Test Scripts.
• Experience in preparation of test data to test the functionality of Informatica Sources Mappings andTargets.
• Hands on experience working in V - Model and Agile Methodology.
• Extensive Experience in creating Test Cases, Test scripts, Test Strategies and Test Plans based on FSD's, BRD's & Use Cases.
• Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using Informatica (IDQ, DVO), Ab Initio, Data Stage and SSIS.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
• Strong Business and Functional exposure on various business applications including Financial and Healthcare.
• Experienced working with Customer Information Data Mart for business reporting thru MDM and Reference Data.
• Strong Data Querying/SQL and UNIX Shell Scripting skills. Possess excellent skills in Manual Testing and automated testing.
• Writing and Executing Test cases and defect tracking using Quality Center.
• Extensively involved in smoke testing, user acceptance testing, functional testing, integration testing, database testing and regression testing.
• Experience in processing and validating data in flat files as well as in DB tables.
• Highly experienced with different RDBMS and No SQL DB such as Oracle, MS SQL Server, Teradata and MySQL.
• Adept in writing SQL scripts required for testing various ETL and backend processes.
• Compatible to work in agile environment.
• Excellent concept of ETL, Data warehousing and BI applications integration.
• Flexible, resourceful, and self-motivated and can work as a team and independently.

TECHNICAL SKILLS:

Reporting Tools: Selenium, QTP, Quality Center, TestDirectorInformatica

Datastage: Business Object, Cognos, Ab Initio

Defect/Test Management Tools: Quality Center, Jira, ALM

Languages: Java, SQL

Databases: Oracle, IBM DB2, MS SQL Server, MS Access

WebServer/AppServer: Tomcat, IIS, Weblogic, WebSphere

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

ETL QA Tester

Responsibilities:

• Used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
• Tested all the ETL process developed to load the data into the data marts.
• Tested the various reports like Dashboards, Summary and Drill through reports developed in business objects.
• Created Test Scenarios and Test Cases based on system use-cases and business use-cases.
• Identified various Business and Data Test Scenarios based on Source to Target Mapping and assisted in the preparation of extensive set of validation test case to verify the data.
• Responsible for running ETL loads by running UNIX shell scripts for refreshing databases and data marts.
• Design and maintain the infrastructure for the ETL process, metadata maintenance, and data validation.
• Performed migration testing by running SQL queries to check if the data is migrated without any discrepancies from legacy systems to the new systems.
• Involved in acceptance reviews and analyzed specification documents to make sure they are clear and testable.
• Responsible for black box testing of the application and verified functionality of the application based on requirements.
• Tested a number of complex ETL Ab Initio graphs, for initial/ history and daily/weekly/monthly incremental data loads.
• Performed various Black-box testing such as Unit Testing, Positive testing, Negative testing, Back-End testing, Integration testing, Front-End testing on GUI applications, Load testing and Stress testing.
• Prepared Traceability Matrix by synchronizing the requirements in RequisitePro with the Test Cases in Quality Center.
• Defects were logged in ClearQuest, followed upon the defects with the Development team to make sure that the defect has been fixed and available in the upcoming build.
• Performed GUI Testing, Functional Testing, Regression Testing, System Testing and Database Testing
• Responsible for database testing using SQL queries using TOAD.
• Conducted walkthroughs with Business team and development for Test Case reviews.
• Used Rational ClearCase for version control of Project issue list.
• Used SQL queries to analyze and validate data in data warehouse against Source Systems using TOAD.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Tracked and documented details of bugs; followed up with development team to verify bug fixes and updated bug status.

Environment: Informatica, SQL Server, Teradata, Business Objects, Ab Initio, TOAD, Quality Center/ALM, Oracle, Agile, UNIX.

Confidential, Seattle, WA

ETL Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts .
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI's, Grouped List, Cascade and Web Reports.
• Tested and validated the BO reports by running similar SQL queries against the source system (s).
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications.
• Designed and executed the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Wrote Test Cases for ETL to compare Source and Target database systems.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Identified duplicate records in the staging area before data gets processed.
• Written test scripts for back-end validations.

Environment: Informatica, Business Objects, KPI, HP QualityCenter/ALM, Teradata, TOAD, Oracle, PL/SQL.

Confidential, Plano, TX

ETL Tester

Responsibilities:

• Ensured data integrity and verified all data modifications and calculations during database migration using Informatica.
• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the Business to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Identify the primary key (logical / physical) and put update or insert logic to test the referential integrity.
• Deleting the target data before processing based on logical or physical primary key.
• Design and execute the test cases on the application as per company standards.
• Preventing occurrences of multiple runs by flagging processed dates.
• Analyzed test results, generate test reports, file bugs and follow up on resolution with development & support team.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica.
• Interaction with business and development to understand the business functionality.
• Written Test Cases for ETL to compare Source and Target database systems.
• Identifying duplicate records in the staging area before data gets processed.
• Written test scripts for back-end validations.
• Created ETL test data for all ETL mapping rules to test the functionality of Informatica mappings.
• Written SQL scripts to test the mappings and tested Cognos Reports.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in metrics gathering, analysis and reporting to concerned team.

Environment: Informatica, SQL Server, Cognos, Quality Center/ALM, TOAD, Oracle, Agile, PL/SQL, Windows, UNIX.

Confidential, Atlanta, GA

QA Tester

Responsibilities:

• Involved in analyzing user requirements for application enhancements and preparing testing specifications.
• Developed test scenarios and test procedures based on the test requirements.
• Participated in preparation of Test Plans.
• Executed functional and system tests manually.
• Executed Test Scripts and analyzed the results based on the specifications.
• Developed Test Strategy Document in excel and involved in the preparation of Test Plan.
• Extensively involved in Regression testing.
• Performed Integration and User Acceptance Tests throughout the SDLC of the application.
• Involved in writing test cases, test strategy, and test execution.
• Conducted smoke, functional, UI, regression, UAT testing, and ad-hock testing.
• Generated Defect Reports and the summary and progress graphs for the application.
• Communicated with Functional Analyst on any issue clarifications.
• Actively participated in Bug Track meetings.
• End to end testing on validating the claims functionality including data validation from source to destination tables.
• Submitted Coverage Status Report of tests performed on weekly basis.
• Involved in project meetings and interacted with other team members to resolve the problems.

Environment: Manual Testing, SQL, Agile, UNIX, MS SQL Server 2000, MS Excel, Windows XP.