We provide IT Staff Augmentation Services!

Etl Tester Resume

Dallas, TX

SUMMARY

  • Over 6+ years of experience in manual testing on web based, Client/Server and data warehousing applications.
  • Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
  • Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
  • Experience in Web based applications like online banking, transactions applications.
  • Experience in SQL and PL/SQL scripting
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
  • Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Experience in Automation using Mercury Interactive Tools such as Win Runner, QTP, Selenium, Load Runner.
  • Experience in using Bugzilla, Test Director, Jira and HP Quality Center for Bug Tracking and Defect Reporting.
  • Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
  • Experience in Reports testing in Crystal Reports XI Environment.
  • Strong working experience in Windows NT/2000/XP and UNIX environments
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

ETL Tester

Responsibilities:

  • Worked with Business Analysts to define testing requirements to satisfy the business objectives.
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Experience in SDLC and Agile methodologies such as SCRUM.
  • Analyzing requirements and creating and executing test cases
  • Validating the reporting objects in the reporter against the design specification document.
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables
  • Extensively written test scripts for back-end validations.
  • Performed Integration, End-to-End, system testing.
  • Involving in Functional Testing & Regression Testing.
  • Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
  • Extensively written test scripts for back-end validations.
  • Executing and monitoring jobs through Autosys.
  • Identify the primary key (logical / physical) and put update or insert logic.
  • Deleting the target data before processing based on logical or physical primary key.
  • Involving in writing complex SQL queries to verify data from Source to Target
  • Performed data validation testing writing SQL queries.
  • Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
  • Experienced in retest the existing test cases with the different kind of source systems for different periods of data.
  • Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Reviewed Informatica mappings and test cases before delivering to Client.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags.

Environment: Informatica, Jira, DB2, SAS 9.3, Oracle, SQL, UNIX, Autosys, Tidal.

ETL Tester

Confidential, Dallas, TX

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Analyzing requirements and creating and executing test cases
  • Involved in ETL process testing using Informatica ETL tool.
  • Test Case Execution and Adhoc testing.
  • Executing and monitoring jobs through Autosys.
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules and good understanding of BI business models.
  • Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Validating the Archive process to purge the data that meet the defined business rules.
  • Performed Integration, End-to-End, system testing
  • Involving in Functional Testing & Regression Testing
  • Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
  • Performed data validation testing writing SQL queries.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
  • Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
  • Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
  • Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
  • Developed UNIX scripts to validate the flat files and to automate the manual test cases.
  • Developing Test Matrix to give a better view of testing effort
  • Modifying and executing test scripts for web-based environment-using Quality Center.
  • Creating traceability relationship between requirements in the same module also between different modules.
  • Involving in formulating the test plan, procedures and Wrote test cases.

Environment: Informatica, Teradata R12, SQL, DB2, Oracle, Jira, Autosys, Unix.

ETL Tester

Confidential, Dallas, TX

Responsibilities:

  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • 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.
  • Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
  • Oversaw the historical loads in UAT and PROD environments.
  • Also worked on Integration of all the processes in UAT/PROD.
  • Prepared the test cases after thorough analysis of each requirement.
  • Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
  • Conducted and actively participated in reviews, walkthroughs of test cases.
  • Reviewed the ETL mappings (Informatica) to ensure the transformations are applied correctly.
  • Executed the workflows in the workflow manager, to start the ETL process.
  • Coordinated with different users in UAT process.
  • Tested the entire data reconciliation process for multiple source and target systems.
  • Involved in creating the test data for generating sample test reports before releasing to production.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Provided input into project plans for database projects providing timelines and resources required.
  • Maintained the data integrity and security using integrity constraints and Data base triggers.
  • Involved in the application tuning of database by identifying the suitable Indexes.

Environment: Informatica, HP Quality Center, Teradata, Oracle10g, SQL, PL/SQL, DB2, SQL*Plus, Autosys, UNIX.

QA Consultant

Confidential - Denver, CO

Responsibilities:

  • Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
  • Manually performed Ad-Hoc testing, end-to-end testing and system testing.
  • Performed manual testing by entering positive values, negative valuesand boundary values to the application.
  • Performed Black box, Integration, Regression, Systems, and Backend testing
  • Created, maintained and updated regression suites upon receiving new build.
  • Worked on conversion of manual tests into selenium automated test scripts.
  • Performed data validation testing writing SQL queries.
  • Compared SQL results with application results by writing SQL queries and migrated database for Back End Testing.

Environment: Selenium, Selenium IDE, Web Driver, Jira, SQL, PL/SQL, Python, Cucumber, Unix.

Hire Now