Suneetha

ETL Tester

Professional Summary:

* ***** ** *********** ********** experience in testing, has been playing a role in various phases of the Software Testing cycle such as analyzing the Business requirements by interacting with User Groups, Development team, preparation of test suit, test cases, test case execution and bug reporting.

Experience in creating Business analysis reports, Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.

Experience in using HP Quality Center and JIRA for Bug Tracking and Defect Reporting.

Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and methodologies Waterfall and Agile.

Extensive experience in ETL/Data Warehouse backend testing and BI Intelligence reports testing.

Worked with heterogeneous databases and expertise in writing Complex SQL Queries using Teradata, Toad and PL/SQL developer and in validating data into Data Warehouse/ETL applications.

Strong knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.

Experience in UNIX Shell Programming for scheduling, file manipulation etc.

Expertise in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.

Experience in testing the XML files and checked whether data is parsed and loaded to staging tables.

Experience in using ETL Informatica tool and running ETL Sessions and Workflows using WF Manager and Monitor.

Experience in creating and modifying stored procedures, views, triggers in MSSQL and Oracle. Experience in writing complex queries in SQL to extract data from databases.

Experience in writing test cases and performing unit testing, system testing, system integration testing, user acceptance testing, ETL testing and Database comparison testing for various applications.

Experience in automation testing using QTP/UFT for functional and regression testing.

Excellent communication skills in handling cross-functional teams, coordinating technical support, promoting data analysis, conducting performance tuning and supervised data collection guides.

Have experience in evaluating the product by different modes of testing, which includes functional testing, system integration testing, end to end testing, production validation testing, user acceptance testing, performance testing and document all the test results and publish the status report of each testing and providing sign off for testing of the module.

Quick learner, efficient, self-motivated and success oriented. Excellent written and communication skills and ability to work independently in a time sensitive environment

Technical Skills:

Operating Systems

Windows, UNIX

ETL/ Data warehouse testing

Informatica, Datastage

Databases

Oracle, MySQL, SQL

Defect tracking tools

Quality Center, Jira

Tools

MS Office, MS Visio, MS Project

Professional Experience:

Avaya Technologies, Houston, TX Apr 2019 to Present

ETL Tester

Analyzing the business requirements and all other project documents with Business Analysts, Development Team and created test plan.

Developing Test Plans, Test Cases to thoroughly test Data Warehouse, BI tools and Big Data related applications and entered them in HP ALM tool.

Working with source system teams to create proper test data for the ETL testing.

Creating Positive and Negative Test Cases to validate all possible test scenarios.

Extensively working on Informatica power center tools, Oracle, Teradata

Testing Informatica mappings, different Teradata load utilities including BTEQ, Multi Load, Fast Load and Fast Export.

Executing and monitoring ETL loads using Informatica workflow monitor and performed Troubleshooting of load failures.

Testing Type 2 Dimensions, Fact tables, Surrogate key process, and Start Schemas.

Testing ETL Transformation Rules and data flow between Source systems, Hadoop and Oracle/Teradata environments.

Testing Historical Data move from Teradata to Hadoop to free up the space in Teradata.

Validating the processing in both directions to make sure that there is no data loss due to data type conversions.

Working on Regression Testing for Hadoop Upgrade 5.3 to 5.4.7 by executing the workflows and scripts.

Validating the results from pre-upgrade and post-upgrade runs.

Logging and tracking Defects in ALM, Analyzed test results after test run.

Generating Test Metrics and Reports from ALM that reflects the current status of test execution and the status of defects on a Daily / Weekly basis and review with Testers, Developers and Business Analysts

Environment: ETL Informatica PowerCenter, ALM/HP Quality Center, Agile, SQL, Oracle, Teradata, UNIX, Toad for Oracle, MS Office, QTP, UNIX, Agile, SCRUM, MS Office

Sage Telecom, Dallas, TX Jan 2018 to Mar 2019

ETL Tester

Reviewed Business Requirement Document (BRD) for accuracy and Completeness.

Designed and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.

Developed SQL queries and scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings. Created Test Data and Traceability Matrix.

Tested Full load and Incremental / Delta loads to large amount of data to couple of interfaces and making sure Inserts and Updates of loading the data is done correctly.

Used Quality Center as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Creation of defects.

Implemented Agile Process - SCRUM Methodology with Face-to-face conversation with project team for frequent deliveries of product to end-user.

Involved in running the Informatica jobs thru Workflow Manager and monitoring the same in Workflow Monitor.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Environment: Agile, SCRUM, UML, Informatica, ETL, QTP, UNIX, ALM/HP Quality Center, MS Office

People10 Technologies Inc., Frisco, TX Oct 2016 to Dec 2017

ETL Tester

Analyzed the business process workflows, ETL workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.

Interacted consistently with the developers and analysts to determine the types of testing required throughout the Bug Life Cycle (BLC) and to report any data discrepancy.

Worked with ETL source system and target system (ETL mapping document) for writing test cases and test scripts.

Deriving Test Scenarios, Documenting Test Cases and Collecting Test Data for Functional Testing.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).

Tested various ETL processes developed using ETL tools like Informatica Power center and SSIS.

Verified column mapping between source and target.

Developed a Defects Tracking Log for the SharePoint Site to track defects while testing.

Contribution to Test Plan Documentation and updated Traceability Matrix Document.

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, concatenated strings, truncated values and ensuring correct data aggregations.

Performed End to End testing for the ETL Load process which included testing incoming file format, Loading Staging tables, Business rules implementation, Matching Criteria, Data Cleansing, Load to final tables and Reports generation.

Created Test Batches, Executing Test Cases and Reporting Defects.

Data Driven Testing with valid and invalid inputs, and Database Testing (Checking Data Integrity, Data Manipulations, and Data Comparison). Validating the Full loads and Delta loads.

Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.

Extensively used Informatica power center for extraction, transformation and loading process.

Extensively tested several ETL Mappings developed using Informatica and SSIS.

Tested data reports. Written several SQL queries for validating the front-end data with backend.

Tracked Defects, Selecting Test Cases for Re & Regression Testing.

Performed Sanity Testing, Re & Regression Testing on modified Software Builds.

Collected Test Metrics and Documentation and updated Test Cases and Test Data.

Executed SQL queries to perform backend database testing and verify/modify user data

Environment: Informatica Power Center, ETL, MS SQL Server, MS Access, MS Excel, Windows Batch Jobs, HP Quality Center, JIRA, SSIS.

Education:

Bachelor of Commerce

Contact this candidate