SUMMARY:

• More than 7 plus years of experience in Database QA Analyst and Testing in ETL/DW, Backend, Database and BI reporting.
• Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.
• Experience in analyzing business specification documents, developing TEST PLANS, defining TEST CASES, developing and automating TEST SCRIPTS using automated test tools (Regression and Data Driven tests) for Functional & Regression Testing.
• Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand DW and ETL Architecture.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate - wide-ETL Solution using Informatica, Ab Initio, Data Stage and SSIS. Experience working with different BI Reports like Cognos, Business Objects and SSRS.
• Expertise in Defect Tracking, Defect management and Bug Reporting Tools like ALM /Quality Center, Ratio, Bugzilla, JIRA and version control tools like Rational Clear Case.
• Experienced in coordinating resources within Onsite-Offshore model
• Experience in Testing ETL applications, working experience with Oracle, SQL Server, MySQL, Netezza, DB2, Teradata, Hadoop, MongoDB and NoSQL.
• Strong knowledge of Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC).
• Coordinated system walk through,, User Acceptance Testing (UAT) and facilitate issue resolution
• Ability to develop SQL script for Data validation testing by running SQL script, procedures.
• Proficient in SQL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Experience in analyzing the error caused to failure of ETL load with to the log file and report them to the corresponding team to get it rectified.
• Experience in testing mappings/workflows using Informatica

TECHNICAL SKILLS:

Testing/Defect Tracking: HP ALM, Quality Center, Bugzilla, Jira

Databases: Oracle, DB2, SQL Server, MS Access, Teradata, Hadoop, MongoDB

Operating systems: Windows, UNIX & LINUX

Database Tools: TOAD, SQL Navigator, WinSQL, SQL Gate, SQL Developer

Data Warehousing: Informatica, SSIS, Ab Initio, Data Stage

Reporting: Business Objects, SSRS, Cognos ReportNet

PROFESSIONAL EXPERIENCE:

Confidential, Mt Laurel, NJ

Sr. ETL QA Tester

Responsibilities:

• Communicate & coordinate with teams to map out business requirements. Design and develop test plan and test scripts in HP ALM/Quality Center.
• 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.
• Involved in extensive Data validation, Data load by writing SQL queries on source, target databases and worked on data quality issues
• Developed complex SQL scripts/queries for data verification to compare the expected results with database and analyzed the data and the calculations in the mapping for its correctness.
• Written complex SQL statements for data reconciliation including comparing record counts between source data, data loaded to the warehouse and rejected records.
• Developed required SQL scripts for database testing and Performed Backend Testing, by executing the SQL queries. Wrote SQL Queries to extract data from the Tables.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Identify test requirements from specifications and design test coverage plan.
• Backend testing of newly developed ETL processes and reports by writing SQL queries and also using MS Excel to compare data.
• Prepared Test data at design phase for both positive and negative scenarios and tested the boundaries for database limitations.
• Wrote and ran UNIX Scripts for batch jobs. Ran UNIX shell scripts to count the records for Data warehouse source to staging tables.
• Extensively involved with backend testing by writing complex SQL queries.
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Design & execute ETL flow test cases using SQL queries for business scenarios validation. Validate BI Cognos reports & self-service reporting framework
• Test transformations that extract data from various sources (flat files, csv files, SQL tables) to staging area and validate the data in facts & dimensions.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Participate in scrum meeting and weekly sprints, review product and sprint backlog

Environment: Data warehouse ETL Informatica 9.5, BI Cognos, HP ALM/Quality Center, SQL, Oracle, SQL Server, Agile, Teradata, CI/CD, UNIX and Toad.

Confidential, Miami, FL

ETL QA Tester

Responsibilities:

• Prepared Test Plan, test Cases, Test scripts and Test data for the application as well as for the database verification based on the functional requirements and test specs.
• Executed a SQL query which retrieves data from the databases that is provided as test data for the testing purpose.
• Wrote Test cases for Data Warehousing Tables and Data Mart Staging Tables.
• Created and executed SQL queries to fetch data from an Oracle database server to validate and compare expected results with those actually obtained
• Extensively used SQL query statements to verify the data integrity and validation between the front-end values with the backend database values of the application
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Used Informatica ETL tool to perform ETL testing and validating end-to-end flow of data with Informatica.
• 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.
• Ran UNIX shell scripts to count the records for DW source to staging tables.
• Interacted with developers in fixing unknown exceptions Written Complex Sql Queries to perform backend testing
• Validate BI reports on the application data to ensure data accuracy and consistency
• Automate QA scripts to test ETL loads and applications.
• Participated in building automation test scripts based on BPT module of Quality Center.
• Conduct backend testing using SQL queries to validate data and executing user specific test cases
• Identify & setup test data, establish test procedures, create test plan and acceptance criteria
• Use HP Quality Centre for writing test cases, updating results and defect handling
• Communicate & coordinate with teams to map out business requirements and technical specs
• Create & execute SQL queries to validate data and isolate issues in UAT & QA environments

Environment: Data warehouse ETL Informatica, SQL Server 2014, SQL, Agile, UNIX, SSIS and BI Tableau

Confidential, Minneapolis, MN

Backend QA Tester

Responsibilities:

• Wrote test plan, strategy, script and cases. Extensively involved in Software Development Life Cycle (SDLC) using Agile/Scrum Methodology and involved in SCRUM meetings.
• Developed test cases for testing the mapping designs before going to the production phase.
• Checked Database to determine successful transaction of test data from the application by establishing Database connectivity through SQL commands.
• Extensively involved with backend testing by writing complex SQL queries.
• Performed manual testing for various front- end scenarios like drop down values, defaults, etc
• Created requirement traceability matrix for test and status reports
• Independently designed and developed project document templates based on SDLC methodology
• Developed SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements.
• Involved in extensive Data validation, Data load by writing SQL queries on source, target databases and worked on data quality issues
• Tested multi-dimensional cubes using models and implemented incremental updates for power cubes
• Defect logging, assignment and tracking through Microsoft test manager
• Utilized reporting tool MicroStrategy for report testing and modified existing reports as per users requirement in QA Environment

Environment: Informatica Power Center, Micro Strategy, Agile and Teradata.

Confidential, Wilmington, DE

SQL QA Tester

Responsibilities:

• Involved in writing the test plans based on Functional Requirement and Business Requirement Documents.
• Designed and documented all the issues and defects to ensure application software functionality for present and future builds.
• Tested several data migration application for security, data protection and data corruption during transfer.
• Worked with functional testing of the extract and load process. Provided the first level of support for the automation framework.
• Involved in creating the test cases from system specifications/ Business requirements. Performed database testing with SQL Queries using Toad.
• Tested ad hoc and canned reports for Business objects
• Worked with Data Conversion projects for testing data quality after migration. Written several complex SQL queries and Stored Procedures.
• Worked in close relation with Business Analysts and Development team.
• Performed Database testing using Oracle and SQL Server. Logged defects and created various defect reports in Test Director.
• Worked with data reconciliation for the entire data migration project for both target system and rejected records.
• Validated the reports to make sure all the data is populated as per requirements. Involved extensively in production support.

Environment: Informatica PowerCenter, Agile, Oracle and Teradata.