SUMMARY

• Over 6 years of professional experience in Database, Hadoop and Software Manual Testing (Functional) of web - based applications.
• 2 years of working knowledge in Cloudera Hadoop and its stack like HDFS, MapReduce, Pig, Hive and Sqoop.
• Good Knowledge of HBase,Kafka
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• In depth knowledge of Testing methodologies, concepts, phases, and types of testing, developing Test Plans, Test Scenarios, Test Cases, Test Reports and documenting test results accordingly after analyzing Business Requirements Documents (BRD), Functional Requirement Specifications (FRS)
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in importing and exporting data from relational database into Hadoop cluster using Sqoop.
• Experience in creating custom Hive, Pig and map reduce programs for analyzing data.
• Good knowledge in SDLC and software testing phases.
• Experience in handling project release deliverables
• Expert in Test Case preparation, Functional testing - Manual, Defect Management, Regression and Sanity testing, Test Plan Building, Test report generation, Test case review and maintenance

TECHNICAL SKILLS

Big Data Technology: HDFS, MapReduce, Hive, Pig,HBase, Sqoop,Kafka

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

Methodologies: Waterfall, Agile/Scrum

ETL Tools: Informatica Power Center 10.2/10.1/9.6 , Data Stage

Reporting Tools: Tableau, Cognos 10.0

Testing Tools: Test Director, HP ALM 12.0/11.0, Quality Center 10.x, 9.x

Tools: TOAD, SQL Navigator, Oracle SQL Developer

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

ETL/Hadoop Tester

Confidential

Responsibilities:

• Identify the test scope for a release, committing the stories for a particular release
• Understanding Customer Demand Story design and documenting Acceptance criteria and Test Plan
• Involve in designing and reviewing the test cases, test scenarios etc. to confirm acceptance criteria of the business to meet 100%
• Perform Sanity check and verifying the systems prior to start any testing
• Identifying defects and following it up with the Component teams.
• Written complex SQL queries.
• Used SQOOP to move data from individual data sources to Hadoop system.
• Validated the Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Coordinated various project specific access requests related to Hadoop components like HDFS directories, Hive tables
• Performed various Hadoop controls like date checks, record checks, balance checks, threshold limits for records and balances etc.
• Tested Map Reduce programs to parse the raw data, populate staging tables and store the data in HDFS
• Reported bugs and tracked defects using ALM/Quality Center
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD
• Experienced in data analysis using SQL, PL/SQL and many other queries-based on applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated the reports to make sure all the data is populated as per requirements.

Environment: MicroStrategy, SQL, PL/SQL, Agile, Soap UI, ALM/HP Quality Center 11, Oracle UNIX, TOAD, T-SQL, SQL Server, XML Files, Flat Files

ETL TESTER/Data Analyst

Confidential

Responsibilities:

• Assisted in developing test plans based on test strategy. Created and executed test cases based on test strategy and ETL mapping document
• Written complex SQL queries for querying data against different data bases for data verification process
• Performed UAT testing
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications
• Written test cases to in HP ALM. Defects identified in testing environment where communicated to the developers using defect tracking tool HP ALM
• Used Informatica as ETL tool to transfer the data from source to staging and staging to target
• Written several SQL queries for validating Cognos Reports
• Worked with business team to test the reports developed in Cognos
• Extensively used Informatica power center for extraction, transformation and loading process
• Creating test cases for ETL mappings and design documents for production support
• Extensively worked with flat files and excel sheet data sources.
• Effectively communicate testing activities and findings in oral and written formats
• Reported bugs and tracked defects using ALM
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: UNIX Shell Scripting, Oracle 10g, Informatica 10.0, HPALM 11.0, SQL Loader, Cognos 8.4, SQL Server, Windows, TOAD, PL/SQL, SOAP

ETL TESTER

Confidential

Responsibilities:

• Interacted with Business Analysts, Developers and support team to define the testing requirement documents along with the QA Manager and mentored the QA Team accordingly.
• Drafted the Test Plan document and presented to IT and Business group for Sign Off.
• Escalation for unresolved bugs to the concerned developers and module leaders.
• Used Unix Commands to access and trouble shoot Errors by accessing the Error Log files.
• Participated in Design Phase, together with members of the Product team, developers, and DBAs.
• Performed Smoke, System testing, system Integration Testing, User acceptance, Database & Regression testing.
• Prepared Test cases, procedures, Bug Tracking, Logging and reporting bugs using Quality center
• Expert with Test documentation, such as Test Cases, Bug Reports, Use Cases etc.
• Designed various test Cases with different test conditions.
• Prepared and executed scenarios for the Regression testing on new builds.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
• Develop test cases and executed in HP QC
• Involved in creating test plan to test the ETL system thoroughly.
• Extensively interacted with developers to analyze & resolve issues that were encountered while testing application.
• Executed Test Cases using positive and negative data in HP ALM Test Lab and reported results and defects using HPQCs Defects tool.

Environment: Data Stage 8, Oracle 11g, SQL, PL/SQL, MS Office Suite, HP QC 10, Unix, Windows, Cognos,TOAD,SQL developer