SUMMARY:

• Extensive experience in Information Technology field with emphasis on Hadoop Tester/Bigdata Tester/NoSQL Tester/Database Tester/ETL Tester/Quality Assurance and Testing.
• Hands on experience Testing using Apache Hadoop ecosystems including Hadoop, HIVE, PIG, SQOOP, FLUME, OOZIE and Spark.
• Solid Testing Experience in ETL and BI applications.
• Experience in Software Development Life Cycle (SDLC) using Waterfall Model, Rational Unified Process (RUP) with a good understanding of Agile Methodology.
• Experience in Data validation and analysis involving verifying the Data Cleansing, Data Conversions, Data Transformation, Data Quality, Data Relationships, between Source Systems Analysis and Reporting.
• Extensive experience in IT industry in testing client server and web based applications
• Familiar with Data flow diagrams, Work flow diagrams and Process flow diagrams for the purpose of creating test.
• Worked with the development team to ensure testing issues were resolved.
• Performed backend data testing using SQL scripts to check the data consistency, data integrity in the application and database as data was fetched from different database tables.
• Designed and implemented fully automated Hadoop Integration testing system.
• Extensive experience in performing data mart and data validation testing for data migration
• Extensive experience working with Data warehouse ETL tools like Data Stage, Informatica, AbInitio, SSIS, and AutoSys tools.
• Perform bug tracking and Reporting using Quality Center and ALM.
• Experience in working with Analysts, Managers and Developers during the software development life cycle (SDLC).
• Clear understanding of DW concepts and DW data modelling like star schema, and snowflake schema.
• Experience in Unit Testing, Integration testing, System Testing (Functionality and Regression), Performance testing and User Acceptance Testing.
• Valuable experience in coordinating with off shore resources.
• Involved in the development of Test Plans, Test Cases and maintaining the Traceability and Test Matrix.
• Detail oriented with strong multitasking and interpersonal skills and ability to resolve problems.
• Motivated, self - starter, with exceptional team building and leadership skills.

TECHNICAL SKILLS:

Languages: SQL, Unix scripts, PL/SQL, Java, .Net, UNIX, Windows, Bigdata Ecosystem/ Hadoop/NoSQL, Big data ecosystem, Pig, Hive, Sqoop, HBase, Cassandra, HDFS, Map/Reduce, Oozie, Falcon, Pig, Storm, Kafka, Zookeeper, Yarn, Lucent, Ganglia, spark, Ambari, Cloudera, Hortonworks, Hue

Testing Tools: HP ALM/Quality Center, JIRA, MTM, SOAP UI, XML, API

Databases/RDBMS: Hadoop, Oracle, SQL Server, Teradata, DB2, MySQL, MongoDB, Marklogic, Vertica, MS SQL Server, DB2, MS Access

Other Tools: MS Project, MS Office, HP QC and ALM

DW Tools: Informatica 8.6, Datastage, SSIS, AB Initio, Business Objects XI 3.2, Cognos, Microstrategy, Cognos, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Hadoop Tester/Bigdata Tester/NoSQL Tester/Database Tester/ETL Tester

Responsibilities:

• Responsible for development, review, analysis, and coordination of the test plans, test scripts, and testing of internally developed software system.
• Developed and implemented template driven test framework for Hadoop components like pig, hive, and map reduce hdfs etc.
• Developed Bigdata ETL test cases for various lines of businesses based on mapping document.
• Ensure alignment of testing strategy with the project’s quality goals and resource limits and escalates issues to the QA Lead and alerts the project team on potential impact to test schedule.
• Designed the Data Driven tests in Quick Test Professional (QTP/UFT) script to validate with different sets of test data.
• Work with requirements analyst to get a good understanding of functionality
• Tested Complex Data warehouse Data warehouse ETL Informatica Mappings and Sessions based on business user requirements and business rules to load data from source NoSQL, Hadoop, flat files and RDBMS.
• Identification and documentation of test cases for multi-component systems
• Responsible for development of test plan and test cases and executing of test cases and documentation of software defects in Quality Center/ALM
• I was also involved in debugging issues on Core Hadoop, faced by other Hadoop services teams like - Oozie, Pig, Hcat, Hadoop Integartion
• Experience in System Integration testing, Database API testing, Functional testing (Black box testing) Security, Recovery, Negative, Regression testing, Load testing
• Performed extensive back end validations using SQL queries in TOAD to verify that the data has been processed correctly based on the business requirements
• Involved in understanding the service request and making the relevant changes to the Business Objects universe and reports functionality.
• Provide timely and accurate status defect information and appropriate metrics to facilitate QA reporting. Reports individual status: dashboard information, open issues, risk analysis.
• Tested all the ETL mappings developed on Informatica from source level to staging and from staging to target.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
• Experience in preparing test data for testing application
• Experience in creating simulated data and invoking UNIX process for data fill jobs.
• Development of regression testing framework and detailed documentation of test results
• Provided training to the team members for working with interfaces

Environment: Hadoop, HBase, Hive Pig, Sqoop, Zookeeper, Spark, HFDS, Kafka, Java, HUE, Map Reduce, Flume, Java, ETL Informatica, BI Business Objects, Oracle 11g, HP Quality Center, MS Office Suite, HP ALM, SQL, PL/SQL, UNIX, SOAP UI and XML.

Confidential, Minneapolis, MN

Hadoop Data warehouse ETL QA Analyst

Responsibilities:

• Preparation of Requirements Traceability Matrix based on the business and the testing requirements.
• Prepare test case analysis and assisted in creation of the system test plan and end-to-end data migration system test plan.
• Analyzed the Data warehouse Hadoop Bigdata ETL design documents to understand the logic.
• Created test cases and test procedures for various stages of the Bigadata ETL process including source to extract, source to staging and staging to target using Hadoop
• Used Informatica Power Center Workflow Monitor to trigger master/stand-alone workflows.
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Used UNIX to validate error files and flat files.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Created end to end test procedures for full cycle validation of system functionalities.
• Performed extensive Multiple System Integration Testing and Functional Testing.
• Qualitative verification of data from source to target using a sampling approach based on stratification of data.
• Created manual testing scripts for black box testing of target application.
• Executed dry runs and test script execution.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Generated test scripts for functional and regression tests using QTP.
• Extensively involved in Defect tracking/observations, reviewing and analyzing and reporting test result using Quality Center.
• Analysis of change requests and identification of the impacted test cases and procedures.
• Involved in testing the Cognos reports by writing complex SQL queries
• Participated in Weekly / Monthly QA metrics reviews, provide QA status reports to management
• Performed regression analysis and regression testing for all the test case scenarios based on the data mapping rules.

Environment: Hadoop, HBase, Hive Pig, Sqoop, Zookeeper, Spark, HFDS, Kafka, Java, HUE, Map Reduce, Flume, ETL Informatica 8.6, BI Cognos, Hadoop, TOAD, QTP, SQL, PL/SQL, SOAP UI, Quality Center 10, Oracle and MS SQL Server.

Confidential Board, VA

ETL QA Tester

Responsibilities:

• Analyzed the functional requirements by interacting with system architect, developers and business users by conducting walkthroughs and meetings.
• Developed and executed Test cases to implement Scrum for frequent intermediate deliveries with working functionality.
• Prepared test data to validate ETL rules wherever necessary.
• Adopted Agile/scrum methodology for - Risk Mitigation, Monitoring and Management (risk analysis) at every stage of the project Cycle with transparency in planning and module development
• Generated test scripts for functional and regression tests using QTP.
• Preparation of Test Plan, Manual & Automated Test Cases, Test Execution, Test Scripts, Test Results Reporting, Bug Tracking and Closure
• Extensively used ETL and Informatica to load data from flat files MS Access and MS SQL Server.
• Created and executed test cases and test scripts for front-end web screens, interface validation and End to End and Integration Testing.
• Experience in Cross Browser testing, Firewall, Security testing.
• Extensively Build and Developed Libraries of User Defined Functions, Object Repositories, Reusable Actions, Error Handling Techniques and Recovery Scenarios in QTP
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data.
• Experienced in RDBMS and using database query tools for Oracle, SQL and UNIX such as TOAD.
• Involved in testing Micro strategy reports including conditional formatting testing and threshold testing.
• Involved in developing Shell Scripts, running Batch jobs in UNIX for validating the Request forms for Registration process.
• Experience in performing data analysis using SQL queries, PL/SQL Stored Procedures/Triggers/Views and fine-tuning of the database indexes.
• Creating XML test data to validate and mock up feeds from external vendors using XML file editors
• Created test data for testing .Net applications.
• Tracking test case execution progress, test results analysis, and maintaining RTM.
• Reported defects using Rational Clear Quest and participated in Defect Review meetings

Environment: ETL Informatica, Micro strateg, SQL, PL/SQL, XML, .NET, HTML, QTP, ORACLE 10 g, SQL SERVER 2005, RDBMS, Web Logic, Web Services, SOA, IIS, VB Script, Quality Center, MS PROJECT, QTP, Clear Case, Crystal Reports, Toad AND LINUX.

Confidential Board, VA

ETL QA Tester

Responsibilities:

• Used Back-end database SQL Queries to perform data testing Validated database operations by executing SQL statements.
• Developed and executed Test cases to implement Scrum for frequent intermediate deliveries with working functionality.
• Used Data Manipulation language (DML) to update the data in the database and verify with front end that application handles the changes correctly.
• Prepared test data to validate ETL rules wherever necessary.
• Generated test scripts for functional and regression tests using QTP.
• Preparation of Test Plan, Manual & Automated Test Cases, Test Execution, Test Scripts, Test Results Reporting, Bug Tracking and Closure
• Extensively used ETL and Informatica to load data from flat files MS Access and MS SQL Server.
• Created and executed test cases and test scripts for front-end web screens, interface validation and End to End and Integration Testing.
• Experience in Cross Browser testing, Firewall, Security testing.
• Extensively Build and Developed Libraries of User Defined Functions, Object Repositories, Reusable Actions, Error Handling Techniques and Recovery Scenarios in QTP
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data.
• Created test data for testing .Net applications.
• Tracking test case execution progress, test results analysis, and maintaining RTM.
• Reported defects using Rational Clear Quest and participated in Defect Review meetings

Environment: SQL, PL/SQL, HP Quality Center, XML, ETL Informatica, .NET, HTML.