SUMMARY:

• Over 8+ years of experience on as a Quality Assurance tester within a Data Warehouse environment.
• Previous experience working for Confidential as an SQA5 and a Data Modeler.
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Hands on Experience Data Validations with advanced MS EXCEL.
• Expertise in querying and testing RDBMS such as Oracle, DB2, Sever, Teradata and MYSQL.
• Good experience with SQL/PL-SQL and expertise in writing complex SQL queries.
• Written complex SQL queries to validate for ETL Data Migration.
• Hands on experience in Data Analysis and Data Profiling.
• Has experience validating a large volume of Data.
• Experience in Automation.(Query surge)
• Hands on experience in Agile Environment.
• Hands on Experience in Hadoop Echo Systems (Hive and Sqoop).
• Having knowledge on PIG and HBASE.
• Hands on Experience in Teradata and Utilities.(Fastload, Mload and BTEQ)
• Hands on experience in Creating ETL Mappings (Informatica and Datastage).
• Hands on Experience in HP ALM and QUERY SURGE.
• Hands on experience in Data cleansing Json and Xml file.

TECHNICAL SUMMARY:

Operating Systems: Win XP, Windows Server 2003, 2008 R2 and UNIX

RDBMS: Oracle 9x, 10x,11g, DB2, SQL Server 2008 and 2012, Teradata

Hadoop and Big Data Technologies: HDFS, Hbase, Hadoop Ecosystems (Hive, Pig, Sqoop)

Database Quarrying Tools: Toad, SQL Assistant, SQL Developer, SSMS

ETL Tools: Informatica 7, 8 and 9x, DataStage and SSIS

Reporting Tools: Obiee and MicroStrategy

Test management Tool: HP Quality Center, HP ALM and IRAD

Programming Language: SQL, PL SQL, TSQL, HQL, and JAVA.

PROFESSIONAL EXPERIENCE:

ETL Tester

Confidential, Plymouth Meeting, PA

• Wrote Test Cases for compare Source and Confidential database systems.
• Identified data streams and reviewed data models for testing strategies.
• Conducted source to Confidential data Validation as per mapping Document and business rules.
• Identified defects and errors in data prior to data processing.
• Collaborated with back end and database testers.
• Executed Test Cases and verified actual results against expected results.
• Performed data validation between various systems and drive changes that ensure the integrity of data based on Business Rules and Transformations.
• Created Hive tables for Data Viewing.
• Performed Data validation against HDFS files (like duplicates, data truncate).
• Performed Data Cleansing against XML and JSON files with functions.
• Performed Data validation against HDFS files.
• Reviewed test cases with the business analyst and developers, was involved in defect meeting for the defect reviews and discussions

Environment: Oracle 11g, Sql Server 12, Db2, HP ALM, JIRA, PLSQL developer, TOAD, Query Surge, MS Office, Shell Scripting, Putty, Hadoop Ecosystems.

Confidential, IL

ETL Tester

• Interacted with Data Analyst, Architects, Developers and DBA's to analyze and resolve the issues that were encountered while testing the applications.
• Wrote Test Cases for compare Source and Confidential database systems.
• Performed System Testing, End to End Testing, Regression Testing and Integrations Testing.
• Created Hive tables for Data Viewing.
• Reviewed test cases with the business analyst and developers, was involved in defect meeting for the defect reviews and discussions.
• Performed Data validation against HDFS files.
• Executed test cases, documented Defects, resolved defects, prepared and maintained the defects in HP ALM.
• Used TOAD, PL/SQL Developer for Oracle and SQL server to write SQL queries for validating the data loaded into the Confidential tables.
• Created Test input requirements and prepared the test data.
• Created new connections in query surge for flat files, databases and Hadoop.
• Compared data from source files & data stores to the Confidential Data Warehouse or Big Data store.
• Wrote SQL queries to insert and retrieve test data from database in a test script while running test cases.
• Documented the test scripts and generated the reports in Quality Center.
• Created the test data for the positive and negative testing for functional, integration and regression testing.
• Performed Verification, Validation, and Transformations on the Input data before loading into Confidential database.
• Worked with various transformations in Informatica for validating the data from source to Confidential database.
• Participated in the application walk-through and meetings.
• Created defects reports, execution test cases and Summary Report, Data analysis reports.
• Attended regular project meetings weekly team and daily status scrum meeting.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment : Oracle 11g, Sql Server 12, Db2, HP ALM, JIRA, PLSQL developer, TOAD, Query Surge, MS Office, Shell Scripting, Putty, Obiee.

Confidential, Winston Salem, NC

ETL Tester

• Performed data validation between various systems and drove changes that ensured the integrity of data based on Business Rules and Transformations.
• Wrote Test Cases for compare Source and Confidential database systems.
• Involved in preparing test plan, test cases/Test Scripts and executing the test scripts.
• Performed System Testing, functional testing, Integrations Testing, Regression Testing.
• Developed traceability matrix, mapping test cases to the Requirements.
• Performed Data validation against HDFS files (like dups, data truncate).
• Performed Data Cleansing against XML and JSON files with functions.
• Performed Data Validation for different Source systems such as Flat files, Excel, database.
• Developed advanced SQL queries to extract, manipulate, and/or calculate Information to fulfill data and reporting requirements including identifying the tables and Columns.
• Participated in daily and weekly meetings for status updates and worked closely with QA manager, developers and offshore team.
• Performed Data Analysis and Data Profiling.
• Logged defects in the defect-tracking tool ALM.
• Executed Test Cases and verified Actual Results against expected results.
• Created Defects and tracked the defects using Quality Center.
• Extensively worked with Excel advanced commands for preparing and comparing the data.
• Participated in Daily status and defect tracking meetings and responsible for maintaining bug log.

Environment: HPALM 11.0, Toad, SQL developer, Xml, Big Data, Hadoop Ecosystems. Oracle 11g, SQL Server 2008R2, Teradata 14.0, SQL Assistant, UNIX, MS Office, Putty, Notepad ++

Confidential, Reston, VA

ETL Tester

• Created Hive tables for Data Viewing.
• Used Sqoop for Data Moving from RDBMS to HDFS.
• Validated data from RDBMS to HDFS by sampling.
• Performed Data Cleansing against XML and JSON files with hive functions.
• Involved in preparing test plan, test cases/Test Scripts and executed the test scripts.
• Wrote Test Cases for compare Source and Confidential database systems.
• Developed SQL queries to check the database automatically and checked the data integrity.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Tested ETL jobs that were scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Used TOAD for Oracle to write SQL queries for validating.
• Performed data validation between various systems and drive changes that ensure the integrity of data Based on Business Rules and Transformations.
• Loaded XML file into Oracle Database and validated Mortgage data.
• Tested and reviewed ETL mapping and transformation specifications based on the business requirements.
• Validated MDM data movement with Business rules.
• Conducted Smoke testing, Integration testing and Data validation testing.
• Performed Verification, Validation, and Transformations on the Input data (Text files) before loading into Confidential database.
• Responsible for validation of Confidential data in Data Warehouse and Data Marts.
• Validated data in between source and Confidential after running Mappings by the developer team.
• Collected the statistics after creating the tables in Teradata.
• Used SQL tools to run SQL queries and validate the data loaded in to the Confidential tables.
• Created Test input requirements and prepared the test data.
• Responsible for sending a Data Warehouse Quality report to the QA manger on weekly basis.

Environment: SQL developer, Xml, Oracle 11g, TOAD, SQL Assistant, UNIX, MS Office, Shell Scripting, Xml, Putty.

Confidential, Minneapolis, MN 

DW/BI Tester

• Wrote Test Cases for compare Source and Confidential database systems.
• Executed Test Cases and verified actual results against expected results.
• Performed data validation between various systems and drive changes that ensure the integrity of data based on Business Rules and Transformations.
• Developed Requirement Traceability Matrix (RTM) in Quality Center.
• Extensively Tested Dashboard charts and filter criteria.
• Verified the accuracy of the column to column for subject areas.
• Extensive experience in testing data warehouse (EDW) and Data Marts for Sales Mart.
• Created Mockup Data.
• Performed Data Analysis and Data Profiling.
• Tested Data movement and Data validation and analyzing the data from various sources to Data Warehouse Tables.

Environment: SQL Server 2005/2008 R2, Oracle9i/10g, Teradata 12.0, Quality Center, Ms Office, Erwin, Windows XP, UNIX, Putty, OBIEE 11g, Informatica 8 X.

Confidential, Plano, TX

Sr Data Warehouse Tester

• Analyzed business requirements, system requirements, and Data Mapping requirement specifications interacting with client, developers and QA team.
• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center 9.0.
• Hands on experience in Writing and Executing MLOAD and FAST LOAD Scripts for TERATADA
• Validated Source data with Confidential Data in Teradata.
• Used MS EXCEL and MS ACCESS for Data CLEANSING.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Hands Experience in developing of Requirement Traceability Matrix (RTM) in Quality Center.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Teradata data warehouse.
• Tested Data movement and Data validation from various source’s to Data Warehouse.
• Extensively test the reports for data accuracy and universe related errors
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Teradata data warehouse.
• Validate Business Object Reports.
• Tested Data Movement Data warehouse to Data Mart with Reference Business Rules.
• Extensively used Excel advanced functions.
• Performed the database testing by writing the SQL queries to validate the data.

Environment: SQL Server 2005,Oracle9i, Teradata 12.0, Quality Center, SAS 9.1, Ms Office, HTML, Erwin, Windows XP, Unix, Putty, Business Objects.