PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI and ETL Testing.
• Extensive experience in Data Warehouse applications testing using Informatica Power Center on multiple platforms.
• Well versed wif various types Software Development methodologies - Waterfall, Agile.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in DW projects ETL testing against DW testing wif Informatica and data stage tools.
• Extensive experience in Test Data Management, creating test data suite, tracking teh results and using for regression testing.
• Setup of Data Profiling using PL/SQL, Hadoop QA using Hive, ETL QA, Business Objects Dashboards QA.
• Extensive experience of manual and automated testing of application and use of HP Quality Center, Test Director, QTP.
• Hands on AS400 Mainframes, Validated data in Sapphire as part of Integration test.
• Experience in Hadoop / Big Data Testing using Hive.
• Good Knowledge on Business intelligence, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process.
• Involved in fine tuning SQL overrides for performance Enhancements.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Participated in all aspects of SDLC.
• Proficient in SQL, PL/SQL coding and experience in Performance Tuning of SQL.
• Hands on experience in Performance Tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Having excellent noledge in Unit Testing, System testing, Integration, Regression, End to End Testing.
• Having noledge in Doing Estimation and Preparing Schedule for Different phases of Test cycle.
• Excellent noledge in preparing Test case plans.
• Excellent experience in working wif HPALM.
• Excellent noledge in Handing Critical Defects and Production Related Defects.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experienced wif ETL tools like Informatic, SSIS and Data stage.
• Experience in testing Business Report developed in Business Objects.
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Excellent team player and excellent communication skills.
• Proficient in creating Business Intelligence reports using SAP Business Objects.
• Experienced in validating BO reports data wif Relational Database.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.5/8.6.1/8.1/7.1/6/5.1.1/1.75, Data Stage 8.x

Reporting Tools: Business Object XI 3.1

StarSchema Modeling, Snowflake: Schema Modeling, Fact and dimension tables, Pivot Tables

Testing Tools: Test Director, HP Quality Center, TFS

RDBMS: SQL Server, Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2005/2008

Programming: UNIX Shell Scripting, SQL, SQL*Plus, PL/SQL

Web Technologies: JavaScript, HTML 4.0

Environment: UNIX, AWS, Hadoop, IBM AIX 4.2/4.3

Test management tool: HP ALM/Quality Center, TFS, JIRA

Big Data Tec: Cloudera Hadoop, AWS

ETL Tools: SSIS, Informatica, SSRS, Cognos, Tableau, etc .

Databases: MY SQL, SQL Server, PL/SQL

API Testing: Postman

PROFESSIONAL EXPERIENCE:

Confidential, Florida

Senior Quality Analyst Lead

Responsibilities:

• Involved in Business analysis and requirements gathering.
• ETL testing in Big Data Hadoop Eco System and AWS.
• Setup of Regression Framework on Hadoop tables using Hive Database and Scoop utilities.
• Responsible to create, Execute Test Sets in HP ALM Test Lab and TFS(Team Foundation Server).
• Coordinated all QA activities and enhancements using waterfall and Agile/Scrum Methodology.
• Coordinated deliverables wif offshore teams by assigning tasks to them.
• Assigned tasks based on priority and scope of testing, took appropriate actions to unblock teh team whenever needed, collected status, sent out consolidated status to management, maintained dashboards to reflect teh real-time status of test execution
• Interacted wif developers, Business & Management Teams, End Users and all teh stakeholders of teh project.
• Written complex SQL on Redshift DB and MS SQL server to perform data validation.
• Used S3(Simple Storage service) to load flat file into Temporary tables for data validation.
• Created UNIX scripts to validate files in Hadoop.
• Wrote SQL and PL/SQL scripts to validate teh database systems and for backend Hadoop database testing.
• Designed and Generated Business Objects Reports and validated teh reports data against base tables.
• Conducted User Acceptance Test (UAT) wif users and customers and prepared issues log based on outcome of UAT
• Reported defects using HP ALM Verified fixes and closed bugs during testing lifecycle.
• Worked on AS400 Main frame, queried data using WINSQL as part of integration test.
• Validate API calls through postman.
• Used Kibana to validate backend data on Elastic search.
• Scheduled BO reports to various users as part of load balance testing.
• Created Ad Hoc reports on various universes to validate data accuracy.
• Asked key technical questions to development team in backlog grooming session and discussed scenarios from QA perspective that may has not thought of, to prevent defects
• Tested teh ETL Informatic mappings and other ETL Processes (Data Warehouse Testing).
• Validated extracts end to end from Source to Target and provided it to Datamart users.

Environment: Informatica 9.5, SQL, Hadoop, HIVE, PL/SQL, UNIX, Shell Scripts, ALM/HP Quality Center 11.5, Oracle, SQL Plus, SQL, Win SQL, SQL Server, AS400, SAP Business Objects, Pro Diver, AWS, Hadoop, Kibana, Postman, Elastic Search.

Confidential, Phoenix, AZ

ETL Big Data Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Conducted teh Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application.
• ETL testing in Big Data Hadoop Eco System.
• Setup of Regression Framework on Hadoop tables using Hive Database and Scoop utilities.
• Created a POC for Big Data / Hadoop solution to build an integrated data warehouse containing data from multiple Oracle 11g databases.
• Validated H ive Scripts by pulling teh data from teh Hadoop and validating it wif teh data in teh files and reports.
• Tested teh reports developed in BO against teh database.
• Wrote SQL and PL/SQL scripts to validate teh database systems and for backend Hadoop database testing.
• Coordinated all QA activities and enhancements using Agile Methodology.
• Responsible to create, Execute Test Sets in HP ALM Test Lab.
• Testing and migration of Informatica workflows and mappings from one Repository to another Repository.
• Maintained teh results of test data and performed regression testing based on teh result set.
• Involved in Business analysis and requirements gathering.
• Wrote Test Cases for ETL to compare Source and Target database systems.
• Tested source data for data completeness, data correctness and data integrity.
• Involved in creating both positive and negative test data to cover all business scenarios.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyze and estimate teh timelines and schedules for a specific UAT activity. Convey all teh required information to teh business in an organized manner.
• Responsible to create defects using HP ALM.
• Participate in teh creation of Test Scenarios & Test Cases wif teh UAT Team and teh Business Analysts.
• Created UAT test cases and Executed them, helped teh end users understand and use teh application
• Participated in Integration, System, Smoke and User Acceptance Testing.
• Created test data to satisfy teh requirement needs and to identify teh functionality of teh transformations.
• Reported defects using HP ALM Verified fixes and closed bugs during regression testing.
• Error log creations and log file cleanup process.
• Reviewed Informatica mappings and test cases before delivering to Client.

Environment: Informatica 9.5, SQL, Hadoop, HIVE, PL/SQL, UNIX, Shell Scripts, ALM/HP Quality Center 11.5, Oracle, SQL Plus, SQL

Confidential, Richmond, VA

Quality Analyst

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Worked wif business team to test teh reports developed in Cognos
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked on Hive queries to process Hadoop data in HDFS environment.
• Solid understanding of teh Hadoop file distributing system
• Develop and maintain operational best practices for smooth operation of HBase/Hadoop clusters.
• Worked on Hive queries to process Hadoop data in HDFS environment.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Involved in teh error checking and testing of teh ETL procedures and programs Informatica session log.
• Testing teh ETL data movement from Oracle Data mart to Netezza Data mart on an Incremental and full load basis.
• Tested teh batch scripts to automate teh cube building.
• Performed Database validation, Testing and conformance in a Data warehousing environment on EHR health records.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Responsible in testing Initial and daily loads of ETL jobs.
• Interacted wif design team to decide on teh various dimensions and facts to test teh application.
• Analyzed Test Results and generated Defect Reporting and tracking via Quality Center/ALM 11. Consolidated and presented regular updates to project team management.
• Involved in Data Validation using SQL queries.
• Involved in testing teh Cognos reports by writing complex SQL queries
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to teh target database including SQL Server and used teh data for Reporting purposes.
• Executed automated test scripts using QTP for Regression testing.
• Created test cases and Scripts to test teh Performance of teh application using Load Runner.
• Reviewing teh test activities through daily Agile Software development stand-up meetings.

Environment: HP Quality Center/ALM, Informatica 9/8.1, Cognos 8 Series, Teradata SQL Assistant, Teradata V2R6, QTP, Agile, Rational RequisitePro, Netezza, Autosys, Rally, TOAD, Putty, Hadoop, Hive/Impala, Oracle 11g/10g, QL Server 2012, SSIS, SSRS, SOAPUI, TIBCO, PL/SQL, Linux

Confidential

QA Tester

Responsibilities:

• Worked closely wif Business user in Understanding designing and documenting teh Functional testing plan and then Writing, executing, documenting teh results and Logging defects.
• Test API calls using Postman.
• Developed Test Cases to cover overall quality assurance testing.
• Executed teh Test cases for BO Reports.
• Maintained Test Logs and Reports in Quality Center.
• Involved in understanding of business processes to learn business requirements.
• Validated teh data extracted from different systems into Source.
• Conducted System testing for each phase of teh application.
• Involved in preparing Test Scripts and Test cases based on teh functional specifications.
• Executed backend testing of teh application by writing SQL queries.
• Executed Test Procedures and documented Test Results.
• Executed jobs through sequencer for better performance and easy maintenance.
• Involved in performance tuning of teh jobs.

Environment: Postman, Quality Center,SQL, Oracle 8.0,SQL Server 2000, PL/SQL, Visual studio code, Windows 95, Test Director, XML, XSD, XSLT, Java and UNIX