SUMMARY

• 7+ years of experience as ETL and Bigdata TESTER wif experience in Insurance, Banking, Healthcare domain.
• Well versed in Software Testing Life cycle (STLC) and in - depth knowledge of Software Development Life cycle (SDLC), Waterfall, V-model and Agile development methodologies
• Experience in creating Test Cases and Test Scripts based on Requirements.
• Experience in Back end Testing like Black-Box Testing, Smoke Testing, Functional Testing, Positive/ Negative Testing, System Testing, Regression Testing, GUI Software Testing, User Acceptance Testing (UAT),
• Experienced in data validation inHDFS and Hive.
• Experience in creating Trace-ability Matrix to ensure comprehensive test coverage of requirements.
• Strong experience in Data Analysis, Data Validation, Data Verification, Data Loading.
• Tested theETLprocess for both before data validation and after data validation process.
• Experience writing Hive Queries for analysing data in Hive warehouse usingHive Query Language (HQL)
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, SQL, andHadoop
• Used Sqoop commands and hdfs scripts to move data from individual data sources toHadoopsystem.
• Familiar in using different Test management tools such as JIRA, Qtest & HP Quality Centre /ALM
• Experience in using Agile methodology and attended the daily SCRUM meetings during each SPRINT session.
• Experience in validating source data coming from various database using SQL queries.
• Strong ETL experience involving Informatica Power Centre Workflow Manager, Workflow Monitor and Repository Manager including design, developing, testing, and deploying ETL process.
• Experience in End-to-End testing of an application/process.
• Hands on experience in writing SQL queries, Joins, Functions in Oracle and SQL Server databases.
• Knowledge inwebservicestestingusing Tool SOAP UI
• 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, LINUX, UNIX

Big data Components: HDFS, Hive, Sqoop, HBase

Languages: SQL, PL/SQL

Test Management: One Jira, JIRA 7.5, Qtest, HP ALM 11.0

Tools: Jenkin, Beyond Compare, Control-M, Informatica 10.0

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

BI Tools: Tableau, Cognos

PROFESSIONAL EXPERIENCE

Quality Engineer

Confidential, Kennesaw, GA

Responsibilities

• Created Test Plan, Test Cases by analysing Business Requirement Documents.
• Documented and executed Test plans, Test cases and Test scripts based on business requirement document.
• Implemented agile/ waterfall methodology throughout the process.
• Involved in executing the basic SQL Queries for Data Validation, Record Counting and Non-Duplication Testing.
• Manually performed integration and Regression testing, documented bugs and worked wif development team to resolve issues.
• Used One JIRA to log bugs and requirement traceability.
• Performed Functional and Regression testing by executing test cases maintained in Quality Centre.
• Performed data comparison between the source and target using utility like beyond compare for files, text, and directories.
• Validate the data integrity and quality checks in the target system.
• Manually operated application like Control-m to monitor, manage and schedule workflow.
• Perform regression test for every release using tools like Jenkin to compare source and target data.
• Performed Smoke testing in the different environment and ensure successful migration to start performing UAT testing.
• Generated Test Status Reports, Defect Reports and perform retesting after bug fix.
• Actively participated in the test plan review meetings, walk through, daily stand up, weekly meetings and lessons learnt after each sprint release.
• Experience on Confluence and SharePoint software for collaboration, document management and storage.

Environment: One Jira, Hue, HIVE, HDFS, MS Office, Agile - Scrum, MS SQL2008, SQL.

HADOOP/ETL Tester

Confidential, Irving, TX

Responsibilities:

• Participated in business requirement walk through, design walk through and analysed Business requirements.
• Created test Cases, Test Design and responsible for implementation of Test cases as Manual test scripts.
• Written several SQL queries for validating data.
• Experience in testing Incremental process in HIVE.
• Tested Sqoop performed jobs from SQL Server.
• Ran queries and tested data in Oracle.
• Performed data validation from source in HIVE and HDFS.
• Used Microsoft Excel and Access to test small amount of data imported from different database management systems like SQL Server, DB2 and Oracle.
• Performed Regression testing of the data.
• Executed HIVE and HDFS commands in Putty to validate data.
• Performed Schema validation, record validation and distinct count in HIVE, HDFS and Oracle.
• Worked wif Test Analysts to ensure that defects are tracked and documented, and results communicated to developers and stakeholders.
• Performed One on One data mapping and testing.
• Tested the ETL process for both before data validation and after data validation process.
• Performed End to End testing in SIT.
• Performed different functional testing like smoke testing, system testing, integration testing, regression testing and retesting.

Environment: Informatica 10.0, Ms Office, Oracle 11g/12g, SQL Server, HIVE, HDFS, Putty, Agile, Jira.

ETL TESTER

Confidential

Responsibilities

• Attended meetings wif the Business Team and Build Teams to gather the information about the project and the design methodology and the testing requirements.
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting wif the management team and walkthroughs.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various project documentation in HP ALM.
• Wrote the Insert, Update, Delete and Error Processing test cases in all the stages.
• Wrote PL/SQL stored procedures for certain data validations.
• Involved in testing MicroStrategy reports including conditional formatting testing and threshold testing.
• Experienced in working wif databases like Oracle and SQL Server.
• Created Test Cases and scenarios for Unit, Regression, Integration as well as Back -end and System testing.
• Was involved in executing the Regression testing on new Builds.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Expert in writing SQL/PLSQL Scripts in querying Oracle.
• Extensively worked wif Metrics, Filters, Transformations, Custom Groups, and Consolidations using MicroStrategy tools.
• Tested the ETL Informatica jobs and other ETL Processes (Data Warehouse Testing)
• Generated testing reports and metrics, trend graphs according to the test plan.
• Created and executed SQL queries in ORACLE and MS SQL server

Environment: Informatica 10.0, MS SQL Server 2008, Oracle 11g, SQL, PL/SQL, SOAP UI, MS Excel, XML, HP ALM 11.0.