We provide IT Staff Augmentation Services!

Etl/web Tester Resume

4.00/5 (Submit Your Rating)

ChicagO

SUMMARY:

  • 5 years of extensive and diversified experience in Information Technology with emphasis on Quality Assurance, Datawarehousing Testing, GUI, Manual Testing, Web, and Client/Server based applications.
  • Involved in complete System Analysis, Design, Development, Testing (SDLC), Maintenance, Enhancement and Quality Assurance of software applications.
  • Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
  • Expert in using Defect Management Tools - HP Quality center, Test Director, Clear Quest
  • Worked on Oracle, SQL Server, IBM DB2, Teradata, Sybase and Informix Database Platforms
  • In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
  • Worked on various Operating Systems which include Windows, Linux, UNIX (Sun Solaris, IBM AIX, HP Unix)
  • Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
  • Extensive Quality Testing experience on both ETL and BI solutions for many clients.
  • Extensive ETL testing experience using Informatica Power Center components (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
  • Extensively worked on Dimensional modeling, Data cleansing & Data staging of operational sources using ETL
  • Experience in using different Transformations, Sessions, Mappings, Mapplets, Workflows and Worklets in Informatica and testing them for complex business rules
  • Expert in writing Test Plan, Test Strategy, Test Metrics, Test Summary Reports, Test Cases and Test Scripts for Manual testing based on the Business Requirement and System Requirement documents
  • Implemented various Test cases for the Functional Testing, System Testing, Unit testing, Regression Testing, Smoke Testing, Integration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
  • Involved with preparation, testing and validation of ETL test data for all the ETL mapping rules.
  • Tested several complex reports generated by BI Tools like Qlikview, Cognos including Dashboard reports, Summary Reports, Master Detailed, Drill Down and cyclic grouping in reports
  • Expert documenting the project status, bug tracking and reporting using Quality Center
  • Strong in developing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
  • Extensive experience in writing SQL and PL/SQL scripts to validate the databases and for backend database testing.
  • Experience in Dimensional Data Modeling using Star Schema and Snow Flake Schema.
  • Strong working experience with SQL (DML, DDL, DCL) and UNIX Shell scripting and Defect tracking systems
  • Followed high level of quality standards to complete the work within the project deadline
  • Very Strong Analytical, Debugging and Technical skills
  • Excellent communication and interpersonal skills, Team player and Self-Starter

TECHNICAL SKILLS:

  • Operating Systems: Unix - (Linux, HP Unix, IBM AIX), Windows XP/NT/2000
  • Databases: Oracle 9i/10g/11g, SQL Server 2016/2014/2012, MS Access, Sybase, Teradata V2R6, DB2, CSV Files
  • Testing Tools: HP ALM 12.5/Quality Center 10.0/9.2, QTP/UFT
  • Querying Tools: SQL* Plus, TOAD, Oracle SQL Developer, SQL Assistant
  • ETL Tools: Informatica 10.2/9.6.1/9.1/8.6.1 SSIS, SQL * Loader
  • Defect Tools: HP Quality Center, JIRA, Rally
  • Data Loading Utilities: Export/Import, Datapump, SQL Loader
  • Scripting/Programming: SQL, PL/SQL, Unix Shell Scripting, PHP, HTML, XML, C, C++

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

ETL/WEB Tester

Responsibilities:

  • Analyzed business requirements, system requirements, Data mapping requirement specifications interacting with Data Warehouse Team and BI Team.
  • Prepared detailed Test Plan, Test Strategy, functional Test Cases, Test Script and executed them to ensure the business requirements are satisfied
  • Performed Integration, end to end and various other testing on Validation Rules, workflows, e-mail services and approval processes.
  • Extensively used HP ALM to load test cases, execute them and log defects found in system testing
  • Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually
  • Extensively used TOAD for Querying the database and back-end Testing
  • Exported the developed test cases into the Quality Center from the excel sheet using the ‘Export to Quality Center’ options with the help of excel add-ins.
  • Defects were tracked, reviewed, analyzed, compared and the feedback is given to the developers
  • 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.
  • Extensively created test cases to make sure the data originating from source is making into target properly in the right format as per the business requirement documents.
  • 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.
  • Expert in ETL Data Validation, Testing functionality of mapping by preparing test data for all ETL mapping rules by loading data from various sources.
  • Tested complex mappings having transformations such as expression, joiner, aggregator, lookup, update strategy, filter and have written corresponding test scripts
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Used SQL tools (SQL Developer) to run SQL queries and validate the data loaded in to the target tables.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Involved in extensive Data validation using SQL queries and back-end testing
  • Tested the different sources such as Oracle, SQL server 2008, Main Frame Legacy Flat Files to load into the Teradata data warehouse.
  • Responsible for Analysis and Defect Tracking using HP Quality Center/ALM, Test Director, JIRA, IBM Clear Quest.
  • Prepared demo reports to test functionality of report generation tool by writing stored procedures, SQL Queries and creating dummy tables using SQL Server 2008 database.
  • Tested and Claims data and loaded into Facets tables
  • Worked with Facets ETL batch jobs and tested the data in Facets tables for data quality
  • Extensively worked with SSIS packages and loaded the member PHI data into Facets tables
  • Tested and validated claims data against Facets tables for claims adjudication process
  • Implemented the data validation for reports using data from different sources and writing SQL queries.
  • Performed Data Loading for Test data using export/import utility, Data Pump, SQL* Loader

Environment: Informatica PowerCenter 10.2/9.6.1, Oracle 11g, SQL Server 2016/2014, UNIX, TOAD, HP ALM 12.5, PL/SQL, T-SQL, MS Access, Facets 5.2

Confidential

ETL Tester

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Prepared test plans, test strategies on project implementation
  • Interacting with senior peers or subject matter experts to learn more about the data
  • Developed Test Cases, test Scripts for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
  • Documented the test results and project status after test case execution using Mercury Quality Center
  • Extensively used Informatica power center for testing ETL process.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping, Mapplet, Designer and Transformation.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mapping
  • Extensively involved in loading the flat files, xml feeds, data from IMS mainframes into databases such as Oracle 9i and SQL server 2005
  • Reviewed Informatica mapping results and test cases before delivering to Client.
  • 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.
  • Testing has been done based on Change Requests and Defect Requests.
  • Written several UNIX scripts for invoking data reconciliation.
  • Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables
  • Extensively executed T-SQL queries to view successful transactions of data and for validating data in Sql Server DB.
  • Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
  • Testing the ETL data movement from Oracle Data mart to Teradata Data mart on an Incremental and full load basis.
  • Involved in developing test cases to test Teradata scripts & updated the status of the testing to the QA team,
  • Used TOAD for querying the data and is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
  • Wrote SQL queries to validate source data versus data in the data warehouse including identification of primary key, duplicate records and integrity checks.
  • Design and execute the test cases on the application as per company standards
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Extensively written test scripts for back-end validations
  • Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
  • Used T-SQL for Querying the SQL Server database for data validation.
  • Involved with ETL test data creation for all the ETL mapping rules.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
  • Created Tables, Synonyms and Sequences according to the Physical Data Model
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables
  • Reported the Bugs/Defects using Quality Center 9.2 defect management tool.

Environment: Informatica Power Center 8.6.1(Power Center Designer, workflow manager, workflow monitor), Oracle 9i, SQL * Plus, SQL, PL/SQL, SQL Server 2005, SSIS, T-SQL, MS Excel Add-in, XML, Quality Center 9.0, Test Cases, Test Plan, Traceability Matrix, UNIX, Shell Scripting, Test Director, Teradata (MLOAD, FLOAD, FAST EXPORT, TPUMP, BTEQ), Cognos BI 8.0, Teradata SQL Assistant 6.0

We'd love your feedback!