SUMMARY:

• 7+ years of experience as ETL Tester
• Experience in Various domains like Healthcare, Banking and Retail
• 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.
• 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
• Experienced in MicroStrategy reporting
• 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

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Languages: SQL, PL/SQL, XML

Test Management: HP ALM, JIRA

ETL Tools: Informatica 9.5 DataStage 8.7/8.1, SSIS, Informatica

Web Services: Soap UI

Big Data Ecosystem: Hadoop, HDFS, HBase, Spark, Hive

RDBMS/ Databases: Oracle 11g/10g, SQL Server 2008/2005

BI Tools: Cognos, Micro Strategy (10.9)

PROFESSIONAL EXPERIENCE:

ETL Tester

Confidential, Fremont, CA

Responsibilities

• 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 in micro strategy are as per company standards.
• Tested the Dashboards, Scorecards, Thresholds in micro strategy
• 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 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, micro strategy 10.9, Informatica 10.0

ETL Tester

Confidential, El Segundo, CA

Responsibilities:

• 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. Testing of checksum (CRC) and error handling for the flat files and relational tables loaded into the databases for all mappings.
• Escalation performance issues by understanding the bottles necks at various levels and tuning them for better performance.
• Tested the reports generated by Cognos, 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 and 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, Teradata, Quest Toad 12, HP ALM, PL SQL, UNIX

ETL Tester

Confidential, Glastonbury, CT

Responsibilities

• 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, User acceptance 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, sub reports 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 in order 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 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: Informatica, BI Cognos, Teradata V2R6, MS Access, MS Excel, MS Word, XML, Oracle 10g, SQL, TOAD 10, SQL Developer, HPALM.

Manual tester

Confidential

Responsibilities:

• 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