SUMMARY:

• 8 years in Big Data Hadoop Testing, Data warehouse ETL Testing, BI testing and Report Testing. Extensive work experience of Telecom, Financial Domain and Healthcare domain.
• Experienced in testing Big Data Technologies - Hadoop ecosystem/HDFS/ Map-Reduce Framework, Flume, Hbase, Sqoop, Pig, Oozie, Kafka and HIVE data warehousing tool.
• Experience in design and execution of test cases and scenarios. Participated in Defect management and Bug Reporting.
• Proficient in database testing using SQL queries.
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake Schema, Dimension and Fact Tables.
• Proficient in Functionality Testing, Regression Testing and Smoke testing. Proficient in ETL, Cubes and Reports Testing for BI applications.
• Strong in Hadoop, Bigdata, NoSQL, SQL Server, Teradata and Oracle. Experience in using SSIS, Abinitio and Informatica tools for validating ETL workflows.
• Experience in using SSRS, SSAS and Cognos tools for Reports and Analytics validation. Experience in validating SCD type 1 and SCD type 2 tables.
• Experience in validating Static and Incremental loads. Experience in Big data testing in Hadoop environment using Hive query language.
• Well versed with User Level Unix commands. Exposure to all stages of Software Development Life Cycle.
• Experience in defect management tools like JIRA and Quality Centre/ALM.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.
• Quick learner and excellent team player having ability to meet tight deadlines and work under pressure.
• Flexible and versatile to adapt to any new environment and work on any project. Created VB script for unzipping, copy/move set of files.

WORK EXPERIENCE:

Sr. Hadoop Tester/Bigdata Tester/Data warehouse Tester/ETL Tester

Confidential, Freemont, CA

Responsibilities:

• Actively involved in Requirement Analysis and business user walk through. Involved in identifying Key Business scenarios for the E2E delivery.
• Prepared and executed test cases data validation using Hive SQL queries. Developed strategies to validate incremental data loads.
• Prepared and executed test cases for Business scenarios Validation.
• Written Hive queries for data analysis to meet the business requirements. Validated Hive Managed and External table types.
• Creating Hive tables for testing purpose and working on them using Hive QL. Validated data imported to Hadoop or HDFS environment from RDBMS.
• Validated Partitioning and Bucketing process using Hive queries. Validated Cognos reports.
• Experience in validating SCD type 1 and SCD type 2 tables. Experience in validating Static and Incremental loads.
• Raised and tracked defects in JIRA/QC and shared defect reports to my manager and all the key stake holders.
• Validated importing of data from various data sources, performed transformations using Hive loaded data into HDFS and Extracted the data from Teradata into HDFS using Sqoop.
• Actively participated in defect calls and followed up to its closure. Involved in UAT support activities.
• Preparing Key learning documents for every release. 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

Tools: Hadoop, HBase, Hive Pig, Sqoop, Zookeeper, Spark, HFDS, Kafka, Java, HUE, Map Reduce, Flume, Quality Center/ALM, DWH ETL, BI Reprots, Java, Javascript, Teradata, Oracle, UAT and Unix

Hadoop Tester/Data warehouse Tester/ETL Tester

Confidential, San Diego, CA

Responsibilities:

• Actively involved in Requirement Analysis and business user walk through. Involved in identifying Key Business scenarios for the E2E delivery.
• Prepared and executed test cases for ETL validation of multiple layers using SQL queries. Prepared and executed test cases for Business scenarios Validation.
• Involved in analyzing the Abinitio workflows and executing them manually to ensure the workflows are meeting the quality expectations.
• Experience in validating SCD type 1 and SCD type 2 tables. Experience in validating Static and Incremental loads.
• Written Hive queries for data analysis to meet the business requirements. Validated Hive Managed and External table types.
• Creating Hive tables for testing purpose and working on them using Hive QL. Validated importing of data from various data sources, performed transformations using Hive loaded data into HDFS and Extracted the data from Teradata into HDFS using Sqoop.
• Raised and tracked defects in JIRA/QC and shared defect reports to my manager and all the key stake holders.
• Actively participated in defect calls and followed up to its closure. Involved in UAT support activities.
• Preparing Key learning documents for every release. 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

Tools: Hadoop, HBase, Hive Pig, Sqoop, Zookeeper, Spark, HFDS, Kafka, Java, HUE, Map Reduce, Flume, Quality Center/ALM, DWH ETL, BI Reprots, Java, Javascript, Teradata, Oracle, UAT and Unix

Sr. Data warehouse ETL Tester/Backend Tester

Confidential, Phoenix, AZ

Responsibilities:

• Actively involved in Requirement Analysis and business user walk through. Involved in identifying Key Business scenarios for the E2E delivery
• Prepared and executed test cases for Data Model Testing, ETL validation of multiple layers using SQL queries
• Prepared and executed test cases for Business scenarios Validation.
• Involved in analyzing the SQL Server Packages in (SSIS, SSAS and SSRS) and executing them manually to ensure the packages are meeting the quality expectations.
• Experience in validating SCD type 1 and SCD type 2 tables. Experience in validating Static and Incremental loads.
• Analyzed SSRS Reports, KPI and Dash board output data against the source data.
• Raised and tracked defects in JIRA/QC and shared defect reports to my manager and all the key stake holders.
• Actively participated in defect calls and followed up to its closure. Involved in UAT support activities.
• Preparing Key learning documents for every release. 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

Tools: Data warehouse ETL Informatica, BI Business Objects, Quality Center, Teradata, Oracle, TOAD, SQL Server, MTM and UAT

ETL Tester/Backend Tester

Confidential, Edison, NJ

Responsibilities:

• Developed a wide-range of SQL queries to assure data validation and avoid duplication in tables of the database.
• Tuned Data warehouse ETL Datastage jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance divisions and across geographies.
• Performed data analysis and data profiling using SQL and Data warehouse ETL on various sources systems including Oracle and Teradata.
• Wrote Test Cases for Data warehouse ETL to compare Source and Target database systems.
• Supervising the QA team in accomplishing their tasks as per the deadlines
• Deleting the target data before processing based on logical or physical primary key
• Involved in requirements gathering, source data analysis and identified business rule for data migration and for developing data warehouse/data mart
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various source systems including SQL Server and Teradata
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Created and maintained test reports, identified bugs and reported findings using Quality Center
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Wrote test scripts for back-end validations and ensured that the mappings are correct
• Extensively used Informatica power center for extraction, transformation and loading process

Tools: Data warehouse ETL Datastage, DB2, BI Business Objects, Quality Center, Teradata, Oracle, TOAD, SQL Server, MTM and UAT