7+ years of experience as ETL Tester
Experience in Various domains like Healthcare, Banking and Retail
Well versed in Software Testing Life cycle (STLC) and in-depth knowledge of Software Development Life cycle (SDLC)
Have work Experience in Waterfall and Agile development methodologies
Expertise in creating Test Cases and Test Scripts based on Requirements
Expertise in Smoke Testing, Back end Testing, Black-Box Testing, User Acceptance Testing (UAT), Functional Testing, Positive/ Negative Testing, System Testing, Regression Testing, GUI Software Testing, Ad-hoc Testing, Boundary Value Testing.
Expertise on various testing types like System testing, Regression testing, Functional testing, Integration testing.
Experience in testing both Initial and Incremental Load
Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
Knowledge of different data models like star schema and snowflake schema
In depth technical knowledge and understanding of Data Warehousing, Data Validations, SQL, and ETL process
Experience in Data Warehousing/ ETL Testing within the environment of Oracle, and SQL Server
Extensively used ETL methodology in testing for supporting data extraction, transformations, and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
Familiar in using different Test management tools such as JIRA & HP Quality Center /ALM
Experience in validating source data coming from various database using SQL queries
Experience in Web Services Testing Using Soap UI
Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting
Hands on experience in writing SQL queries, Joins, Functions in Oracle and SQL Server databases.
Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports
Able to work independently under minimum supervision as well as in a team environment.
Strong problem solving, troubleshooting and efficient to handle multiple tasks easily
Excellent Communication, Analytical and Interpersonal skills
SQL, PL/SQL, XML
HP ALM, JIRA
Informatica 9.5, DataStage 8.7/8.1, SSIS, Informatica
Oracle 11g/10g, SQL Server 2008/2005
Wells Fargo, Fremont CA
April 2017 -Till date
Wells Fargo as various types of savings, Mortgage, current, and recurring deposit accounts for the bank's account holders. The project will facilitate the integration of multi-sourced data into a DWH and expose the data to standard and ad hoc reporting and visualization as well as analytical tools. This data will support the Marketing Science, Marketing Planning, and Industry Analytics and BA groups to derive Insights across all products.
Extensively involved in developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
Performed integration testing in traditional ETL, extraction, transformation, and loading of massive structured and unstructured data.
Written customized SQL queries for business needs.
Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL.
Raised and tracked defects in JIRA and shared defect reports to my manager and all the key stake holders.
Tested reports developed Cognos as per company standards.
Actively participated in defect calls and followed up to its closure. Involved in UAT support activities.
Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica
Worked on SQL queries with many joins and conditions for finding matching and non-matching data, to generate new columns, estimate shipping quantities and similar requirements.
Responsible for re-testing defects which was fixed by Dev team.
Involved in preparing Test Environment. Follow Peer Review Process for Test cases. Mentoring and nurturing of new team members
Environment: Oracle 11g, SQL, Unix, Windows 8, HP ALM, JIRA, Cognos, Informatica 10.0
Healthcare Partners, El Segundo, CA
Sep 2016 - March 2017
Healthcare Partners is a leading healthcare organization in USA. The project is to create the DataMart claims based on payee type for the existing members and providers based on in network and out network the sources of the data consist of feeds from applications residing on the mainframe to applications residing on SQL server and Oracle. The data is extracted from the various sources and is loaded into the staging tables from where it is consolidated, and several measures are calculated and is finally loaded into the data mart. Reports were generated for the various business needs accordingly
Involved in developing test plan, created test cases for testing DataMart based on the BRD
Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
Extensively used Informatica power center for extraction, transformation and loading process.
Tracked the defects using HP ALM tool and generated defect summary reports.
Used HPALM to track and report system defects.
Have used multiple advance SQL queries function such as join, union, alter, create, distinct and some other function to join different database in single query while executing the script
Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse according to Business Rules.
Worked with Informatica PowerCenter for the ETL Process
Involved in both initial and Incremental Load testing
Performed various testing like Regression testing- testing, system testing, performance testing
Performing extensive Back-end database validation by executing advanced SQL Queries in SQL developer for Oracle Database.
Escalation performance issues by understanding the bottles necks at various levels and tuning them for better performance.
Tested the reports generated by Tableau, validated the data against Datawarehouse/Datamart
Read and verify the session log to verify data loads summary, data verification purposes like data truncation, data overflow, rejected errors, row counts etc.
Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
Environment: Informatica Power Center 9.5, Oracle, MS SQL Server, Tableau, Teradata, Quest Toad 12, HP ALM, PL SQL, UNIX
Envision Pharma Group, Glastonbury, CT
Jan 2013 – June 2016
Envision Pharma Group a leading pharmaceutical company. Project involved in Data Warehouse development for sales division, which contains the sales data for pharmaceuticals and medical products of the company. This Data Warehouse project will enable management to better leverage information collected within current operational systems to help in their decision-making process.
Involved in Data Validation using SQL queries.
Performed negative and positive testing, to make sure validations are done properly.
Provide update to management on testing status and defect summary reports
Carried out and oversee test execution for Business scenario, back end testing and Regression testing
Involved in Data Validation with Business Team.
Used Informatica as an ETL Tool for Developing the Data Warehouse.
Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
Extensively involved in Extracting, Transformation and Loading of data to target oracle warehouse database.
Raised defects in HP ALM and follow up with the development team to avoid slippage.
Tested Cognos Reports which would facilitate decision-making. The Cognos Reports designed were complex and used formulas, parameters, selection criteria etc.
Worked with Data Warehousing developers who extensively used Informatica, to design mapping to move data from source to target database using Stages to do the functionality.
Prepared defect summary and test case summary reports
Written multiple complex SQL queries to verify the Datawarehouse
Experienced in writing complex SQL queries for extracting data from multiple tables
Review the test cases written based on the Change Request document.
Testing has been done based on Change Requests and Defect Requests.
Preparation of System Test Results after Test case execution.
Used DataStage Director to Run and Monitor the Jobs performed
Used Test Director, to manage the entire process and log in defects
Effectively coordinated with the development team.
Created critical scenarios for each change request and defect request.
Environment: IBM Infosphere DataStage 11.3/9.1/8.7, BI Cognos, Teradata V2R6, MS Access, MS Excel, MS Word, XML, Oracle 10g, SQL, TOAD 10, SQL Developer, HPALM.
Feb 2011 – Dec 2012
Hyatt Hotels Corporation is an American multinational hospitality company that manages and franchises luxury hotels, resorts, and vacation properties
Created Test Plan, Test Cases by analyzing Business Requirement Document
Documented and executed Test plans, Test cases and Test scripts based on business requirement document
Implemented agile methodology throughout the process.
Experienced in functionality testing, black box testing, system testing, integration testing, regression testing, backend testing, compatibility and user acceptance testing.
Possess good judgment skills while reporting and prioritizing software bugs in conjunction with the development and QA Managers.
Involved in executing the basic SQL Queries for Data Validation, Record Counting and Non-Duplication Testing.
Developed SQL scripts, to implement business rules. Manually performed integration and Regression testing, documented bugs and worked with development team to resolve issues.
Used JIRA to log bugs
Exported test cases into the Quality Center, ran manual test cases from test lab and logged defects from defect module.
Performed Ad-hoc, Smoke, Functional, and Regression testing by executing test cases maintained in Quality Center.
Performed Smoke testing in the UAT environment to ensure successful migration prior to notifying the customer to start performing UAT testing.
Generated Test Status Reports, Defect Reports.
Actively participated in the test plan review meetings, Walk through, Weekly meetings.
Environment: HP Quality Center 10.0, Microsoft office, UNIX, Windows OS, Mac OS, Firefox, Chrome, Safari, Internet Explorer
Master of Science in University of Minnesota Duluth
Bachelor of Science in Tribhuvan University