SUMMARY

• Overall 5+ years of experience in testing Hadoop and ETL testing.
• Knowledge with all phases of software development life cycle (SDLC).
• Knowledge of Hive, Sqoop and HBASE.
• Worked on differentETL processesfor the data ingestion module.
• Extensive experience with ETL technologies, such as Informatica.
• Experienced in Performance Tuning, Developing Logical & Physical Data Models usingHIVEfor Analytics, Data lake creation using Hive and Data load management using SQOOP.
• Experience writing Hive Queries for analyzing data in Hive warehouse usingHive Query Language (HQL).
• Experience inLinux shell Scripting.
• Capable of processing large sets of structured, semi - structured data and supporting systems application architecture.
• Able to assess business rules, collaborate with stakeholders and perform source-to-target data mapping.
• A very good team player, self-motivated, dedicated in any work environment.
• 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, Ad-hoc Testing, Boundary Value Testing.
• Tested Map Reduce programs to parse the raw data, populate staging tables and store the data in HDFS
• Understanding of Data Models, Data Schema,ETLand created SQL queries to perform back-end data warehousing testing.
• Experienced in Bug Reporting and Defect tracking using tools like HPALM HP Quality Center and Test Director to log and defect management.
• Experience in report data validations and cosmetic data validations which are developed in Cognos

TECHNICAL SKILLS

Big Data Technology: HDFS, MapReduce, Hive, Sqoop

Databases: Oracle 11g/10g/9i, SQL Server

Methodologies: Waterfall, Agile/Scrum

ETLTools: InformaticaPower Center 10.2/10.1/9.6 , Data Stage

Reporting Tools: Cognos 10.0

Testing Tools: Test Director, HP ALM 12.0/11.0, Quality Center 10.x, 9.xTools SQL Navigator, Oracle SQL Developer

Operating Systems: Win 98/2000/XP/Win-7, UNIX

PROFESSIONAL EXPERIENCE

ETL/ Big Data Tester

Confidential, Columbia,SC

Responsibilities:

• Experienced in validating the source data with the target data in data warehousing application and also in reports in Client/Server and Web Based environment.
• Analyzing requirements and creating and executing test cases
• Involved in developing Test Cases, Test Plans, Test Execution, Defect Tracking, and Report Generation using Quality Center / HP ALM based on functional specifications.
• Involved in end-to-end defect management of assigned projects. Identified defects, assess root cause, and prepared detailed information for developers and business stakeholders.
• Experienced in Data Validation and Backend testing of databases to check the integrity of data.
• And also used extensively HQL Queries to analyze the HDFS data
• Used HP ALM for Test Management, Defect Management
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica using SQL Server, Oracle, Hadoop, DB2, and UNIX and also have ability to evaluate ETL/BI specifications and processes.
• Experience in UNIX, RDBMS, Hadoop, HIVE (HQL), Oracle (SQL)
• Experienced in Black Box, White Box, Integration, Regression, Functional Back End Testing.
• Involved in establishing automated Hadoop Integration testing system and implementing workflow.
• Responsible for Analysis and Defect Tracking using HP Quality Center/ALM, Test Director, JIRA.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side
• Experience with different file systems /databases like Oracle, HDFS and MS SQL Server to extract and load data using sqoop.

Environment: HDFS, Map Reduce, Hive, Oracle 10g/11g, HQL, InformaticaPower Center 10.0, PL/SQL, HP ALM 12.0, PuTTY, UNIX, Agile

ETL /BIG DATA TESTER

Confidential, Durham,NC

Responsibilities:

• Responsible for creating completetest cases,test plans,test data, andreporting statusensuring accurate coverage of requirements and business processes.
• Working with the Development team for process improvement and release planning
• Performing backend testing of the DB by writing SQL queriesto test the integrity of the application and Oracle databases.
• Extensively worked onMapping Variables, Mapping Parameters, Workflow Variables and Session Parametersto extract only the additional data added during dat period.
• Wrote queriesto compare the counts and data from source to target.
• Formulating the QA plan forblack boxtesting of the application includingFunctional,Regression,Integration,SystemsandUser AcceptanceTesting.
• Performingdatabasetesting to verify backend database.
• Wrote complex queries in oracleSQL developer to analyze the data
• Involving in communication betweenUATteam members, business leaders.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines.
• Created, maintained and updatedregression suitesupon receiving new build.
• Creatingtraceabilityrelationship between requirements in the same module and also between different modules.
• Extensively used HPALM for documenting, organizing and tracking requirements.
• Involving in preparing the test plan and Wrote test cases.
• Involved in testing reports generated by Cognos

Environment: HP ALM 12.0, Oracle10g/11g,Informatica Power Center 10.0, SQL, MS SQL SERVER,UNIX, shell scripting

ETL TESTER

Confidential, Alpharetta, Georgia

Responsibilities:

• Developed and documented data Mappings/Transformations and Informatica sessions as per the business requirement
• Initiated new techniques to the testing process and improve the performance of the test scripts
• Executed Workflows in the Test Environment in order to load the data from the source systems to the DWH
• Wrote test scripts to test the Policy Dimensions and Facts for counting the records in the source and WH tables Type 1 and Type 2 changes in the WH tables.
• Developed test cases and scripts for GUI functionality testing interface testing and regression testing.
• Used Agile testing methodology for achieving deadlines in UAT testing
• Wrote SQL test scripts for validating the data in the target database create, and execute SQL script on Oracle 9i database. involved in Database Testing
• Running SQL Query's,
• Worked closely with the Business Analysts, Systems Analysts, Developers and DBAs to solve the issues identified during the testing process in a timely manner
• Assisted in promotion of ETL Informatica Power center code and UNIX from UAT to Production.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log
• Submitted Final Test Report and required documentation for the project within the assigned time frame

Environment: Cognos 10.0, Informatica Power Center 9.5, Oracle 10g/11g, DB2, SQL Server 2006, UNIX, Windows