SUMMARY

• 4+ years of IT experience working as ETL and BI Tester involved in Business Intelligence testing and ETL testing on various Data Warehouse Environments in multiple domains.
• Experience in full Software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Having in depth technical experience of Software Test Life Cycle, Water Fall and Agile methodologies.
• Experience in gathering functional requirements from users and designing data model for ETL development.
• Extensively worked in HP Quality Center and JIRA to perform testing and analysis.
• Experience performing Unit testing, Regression testing, Ad - hoc testing and GUI testing.
• Used ETL tools such as Informatica, Data Stage and Ab Initio for performing ETL testing on Extraction, Transformation and Loading data from source files such as flat files, oracle and SAP.
• Performed end to end ETL testing and validation using source and target data in source system and target system.
• Hands on experience in Manual testing and automation testing using HP ALM/QC, JIRA and QTP, Load runner.
• Having in depth technical experience of Software Test Life Cycle, Water Fall and Agile methodologies.
• Experience in writing and development of test cases, test scripts and test procedures.
• Identifying and tracking performance issues and defects during testing.
• Performed BI testing using reporting tools Cognos Dashboards and Business Objects.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups & proven ability to implement technology-based solutions for business problems.
• Experience in Data Profiling, Data Extraction, Data Integration, Data Testing and Data Cleansing.
• Excellent communication skills, team player, quick learner, organized, hard working.

TECHNICAL SKILLS

QA Methodologies: Agile - Scrum and Waterfall

QA Tools: HP - Quality Center/ALM

Databases: Oracle: 11g, 10gMicrosoft: MS Access, SQL Server 2005/2008/2012, Teradata

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL Plus, PL SQL Developer

ETL Tools: Informatica Power Center 9/8.x

BI/Reporting Tools: Cognos 10.8, Micro Strategy 9.2

Programming Languages: SQL, XML

Operating Systems: Windows and Unix

PROFESSIONAL EXPERIENCE

Confidential

Sr. QA Analyst

Responsibilities:

• Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data Warehouse project.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Determined the level of testing required validating new or revised system capabilities.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center/ALM
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Reviewed Business Requirements, System Specs and Training Material for accuracy. Planned, developed and executed test plans, including detailed test scripts.
• Experience in testing and writing SQL statements.
• Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.
• Tested ETL Packages, Scripts from development to QA environment.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Involved in extensive data validation using SQL queries and back-end testing

Environment: ETL Informatica Power Center, SQL, Agile, HP Quality Center/ALM, Business Objects, Teradata, QTP/UFT, Oracle, UNIX, TOAD, T-SQL, SQL Server, XML Files, XSD, XML Spy, Flat Files.

Confidential

QA Consultant

Responsibilities:

• Interacted with Business users to gather testing needs and data flow from source to target. Involved in test plan, writing test scenarios and executing test cases as per user requirement.
• Used Informatica ETL tool to perform ETL testing and validating end-to-end flow of data with Informatica.
• Developed scripts in SQL Server, Oracle as per user requirement to validate data. Validated data using different parameterized techniques and plans to perform analysis.
• Involved heavily in writing complex SQL queries based on the given requirements
• Worked on HP ALM/Quality Center to track on defects and updating status of defects on timely manner.
• Attending Daily Calls and updating test data and status of the work to management.
• Used STM- Source to target mapping document to understand ETL end to end flow of data in ETL design.
• Worked with Business users, ETL Developers team to gather testing requirements, technical specifications documents.
• Worked with offshore team for performing needed testing and analysis as per user requirement.
• Worked in Agile methodology with developers and testers for development and testing on timely manner.
• Documented test cases and test scenarios for multiple applications from repot generated by business objects (BO) reporting tool.

Environment: ETL Informatica, BI Business Object, HP ALM/Quality Center, Oracle 11g, TOAD, SQL Server 2012, SQL Developer, SQL, UNIX.

Confidential

Responsibilities:

• Participated in daily scrum meeting and update the testing status. Review Configuration Specification Documents and provided necessary suggestions.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.
• Written Test Cases for ETL to compare Source and Target database systems, Source to Target column level mapping, check Referential integrity etc and created the scripts accordingly
• Participated in validating mappings, sessions, workflows in Informatica. Involved in heavy testing of the data transformation processes developed in Informatica
• Use TOAD to execute and run SQL queries to validate data in the database. Designed and developed Test Plans and Test Scripts in HP Quality Center and executed them.
• Responsible for preparing traceability matrix to track requirements with test cases. Use TOAD to execute and run SQL queries to validate data in the database.
• Used JIRA for agile activities like issue management, task board and defect tracking
• Involve in reviewing and making necessary changes in the test script written by other team members.
• Involved in Functional testing, End to End testing and Regression Testing
• Work with off shore team in the daily basis in understanding and updating the QA related activities.

Environment: HP Quality Center, ETL Informatica, SQL Server, SQL, Oracle, JIRA, Windows