We provide IT Staff Augmentation Services!

Sr Etl Tester Tester Resume

Dallas, TX

SUMMARY

  • Over 8+ years of experience Software Quality Assurance (QA) experience testing Data Warehouse, Data Analysis, Database (ETL), Web, Client - Server Systems and Applications for various Industries.
  • Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) .
  • Extensive ETL tool experience usingInformatica PowerCenter 9.6/8.6.1/8.1 / 7.1/ 6.1 . Workflow Manager, Workflow Monitor.
  • Experienced in working with Teradata ETL tools like Fast Load, Multi Load, TPT, Tpump and Fast Export. Also worked extensively on Teradata Query Submitting and processing tools like BTEQ and Teradata SQL Assistant (queryman).
  • Automated Testing with Python & Selenium.
  • Strong experience in Business and Business and Data Analysis, Data Profiling, Data Reconciliation, Data Modelling, Data Migration, Data Integration and Metadata Management Services.
  • Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
  • Strong in Software Analysis, Planning, Design, Development, Testing, Maintenance and Augmentation for various applications in data warehousing, metadata repositories, data migration, data mining and Enterprise Business Intelligence
  • Expert in ETL, Data Warehousing, Backend testing.
  • Extensive experience in writing SQL to validate the database systems and for backend database testing.
  • Extensive experience with IBM Mainframe for analyzing the data in designing the ETL Process.
  • Extensively worked on design and implementation of Database Management Systems such as Oracle 11g/10g / 9i / 8i / 7.x, DB2 UDB, MS SQL Server, and MS Access.
  • Tested various jobs and performed data loads and transformations using different stages of Data Stage and pre-built routines, functions and macros.
  • Implemented all stages of development processes including extraction, transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica PowerCenter using Informatica Designer (Source Qualifier, Warehouse Analyzer, Transformation Developer, Mapping and Mapplet Designer), Repository Manager, Workflow Manager and Workflow Monitor.
  • Experienced in working with Business Users, Business Analysts, IT leads and Developers in identifying and gathering Business requirements to further translate requirements into functional and technical design specifications.
  • Worked extensively in UNIX (AIX) and Linux environment, used Shell Scripts for automating batch transfers, table space management, automated backup, user group maintenance, security and custom report generation.
  • Comprehensive knowledge of Ralph Kimball’s data modeling concepts including Dimensional Data Modeling and Star/Snowflake Schema Modeling.
  • Extensive experience in performing Black Box, Regression, Integration, and User Acceptance testing.
  • Experienced working with Excel Pivot and VBA macros for various business scenarios.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6/8.6.1/8.1 / 7.1/ 6.1 . Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange

Data Bases: Oracle 11g/10g / 9i / 8i / 7.x, MainFrame via web3270, DB2 UDB, MS SQL Server 2008/2005/2000 / 7.0 , MS-Access, teradata v2r6

Development Languages: SQL*Plus, T-SQL, PL/SQL 2.2 / 8.x, Unix Shell Scripting, TOAD 7 / 7.6, SQL Loader, VBA

Operating Systems: UNIX (AIX), Linux, MS-DOS, Windows vista / XP / 2000 / NT / 98 / 95.

Methodologies: Ralph Kimball’s Data modeling, Star and Snowflake Schema Modeling

Testing Tools: Mercury Quality Center 11.0/ 10.0/ 9.0 / 8.0 , Test Director 7.6 / 7.0, Quick Test Professional 6.5 / 5.6, Win Runner 7.5 / 7.0

Data Modelling Tools: Erwin .

Management Tools: Peregrine Service Center 5.1, HP Project and Portfolio Management Center (ITG) 7.1

PROFESSIONAL EXPERIENCE

Confidential, DALLAS TX

SR ETL Tester TESTER

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Full Life Cycle Testing (SDLC) and development of both claim submission and remittance retrievals.
  • Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Worked on loading different types of files using Teradata utilizes like TPT, Mload, Fload and through Informatica
  • Strong knowledge in troubleshooting the issues related to Unix, Teradata and Informatica
  • Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
  • Used Python for dynamically generating property list for every application. Automated data movements using python scripts. Creating core python API which will be using among all modules.
  • Developed QA processes automation test scripts using Python/Selenium to test Web based user interfaces for different types of browsers. Validated the data from Front End to Back End tables in Oracle Database.
  • Involved in DataDriven and Hybrid approaches using Selenium to convert manual test cases into automation.
  • Created data trace map and data quality mapping documents.
  • Performed Data Profiling and Data Quality.
  • Worked with Informatica tool as ETL for loading and transforming the data to test various jobs.
  • Experience in testing reconcile (initial) and delta (daily) ETL loads.
  • As a QA Lead, participated in walkthroughs for the evaluation of the test plan with the design and development.
  • Managed QA team which consists of both onshore and offshore QA resources.
  • Verified column mapping between source and target.
  • Prepared test data for functional & Integration testing.
  • Led, mentored, and trained multiple testers helping in their professional development and promotion.
  • Remained hands on with the projects, identifying, troubleshooting, and filing all issues in a clear and concise manner.
  • Developed & maintained the Traceability matrix between requirements and test cases in ALM.
  • Designed and executed the UAT cases.
  • Working with Quality Center (ALM-11) users to implement new processes and Setup and configuration of Quality Center projects.
  • Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
  • 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.
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Creation of test scripts in SQL based on published design documents
  • Exported the results through SQL and documented the test results for test cases, suites executed.
  • Worked on Various SQL Server procedures for various Bugs, executed queries in test databases using SQL queries.
  • Executed SQL Queries for testing integrity of data in database (Backend Testing).
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Testing has been done based on Change Requests and Defect Requests.
  • Preparation of System Test Results after Test case execution.
  • Performed Functional, Regression, Data Integrity, System, Compatibility testing
  • Written several complex SQL queries for validating Business Object Reports.
  • Developed SQL Stored Procedures and Queries for Back end testing.
  • TOAD 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 duplicate records.
  • Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center

Environment: Informatica PowerCenter 9.6/8.6.1/8.1 / 7.1/ 6.1 , Teradata 13,Teradata SQL Assistant, Python, ORACLE PL/SQL, MS SQL SERVER 2016,UNIX, Agile, HP ALM 11.0, MDM, DB2,Shell Scripting, XML Files, IBM, AUTOSYS, ORACLE 11G, TOAD 10, Word, Excel, Outlook.

Confidential, DURHAM NC

Lead/ETL Tester -HIPAA

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Carried out data profiling for multiple loan feeds.
  • Co-ordinated with onshore & offshore team .
  • Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
  • Led the development and execution of test plans and scripts for project-based, new software rollout. Testing to include unit testing, application testing, integration testing, feature functionality testing, validation testing and regression testing
  • Involved in the complete Software Development Life Cycle (SDLC).
  • Wrote, prepared and executed Manual Test Cases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC).
  • Experience in Migrating and upgrading from any version of Test Director to Quality Center/ALM
  • Customized and Developed ALM dashboard reports by running SQL Queries
  • Performed ETL testing based on ETL mapping document for data movement from source to target.
  • Tested ad hoc and canned reports for Business objects.
  • Tested SOA application interface and communication paths.
  • Tested Business Objects reports and Web Intelligence reports.
  • Extraction, Transaction and Loading was done using different Components and different expressions using Data Stage to create test data.
  • Managed user accounts and security using Business Objects Supervisor
  • Tested the universes and reports in Business Objects 6.0
  • Strong testing Quality Assurance experience within agile environment.
  • Good understanding of agile software development lifecycle (iterative and incremental).
  • Performed tests on various features of agile development process.
  • Automated detailed test cases by using Quick Test Pro.
  • Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
  • Used Quality Center for bug reporting.
  • Tracked and reported the bugs with Quality center.
  • Defect Reporting & Defect Tracking using Quality Center.
  • Tested complex objects to the universe to enhance the report functionality.
  • Tested ad hoc and canned reports for Business objects.
  • Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
  • Written extensive UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
  • Performed extensive data validations against Data Warehouse
  • Loaded flat file Data into Teradata tables using Unix Shell scripts.
  • Conditional testing of constraints based on the business rules
  • Designed and executed the test cases on the application as per company standards and tracked the defects using HP Quality Center.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
  • Developed and Executed SQL statements in Toad to retrieve data and to validate data.
  • Implemented Database Checkpoints for Back-end Testing.
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
  • Worked on SQL Tools like TOAD and SQL Server Management Studio to run the SQL Queries to perform manual test in regular basis and validate the data.
  • Involved extensively in doing back end testing of the data quality by writing complex SQL.
  • Designed and prepared scripts to monitor uptime/downtime of different system components
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing the ETL data movement from Oracle Data mart to Teradata on an Incremental and full load basis.

Environment: Informatica PowerCenter 9.6/8.6.1/8.1 / 7.1/ 6.1 , Python, Business Objects Enterprise XI R2 / XI R3.Agile, Oracle 10g/9i, QTP, DB2 UDB, WinSQL, UNIX (AIX), Linux, PuTTY, WinSCP3, Mercury Quality Center 10.0, Word, Excel, Outlook, Autosys, Teradata, TOAD, XML

Confidential, Phoenix, AZ

Data Analyst/ETL Tester

Responsibilities:

  • Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
  • Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
  • Developed inline view queries and complex SQL queries and improved the query performance for the same.
  • UNIX and Oracle are used in this project to write Shell Scripts and SQL queries.
  • Involved in Identifying of the unused test cases in the Test Plan in Quality Center and prepared a consolidated doc to delete the test cases.
  • Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
  • Involved in automation of test cases using QTP.
  • Did functional testing using QTP
  • Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
  • Executed campaign based on customer requirements
  • Followed company code standardization rule
  • Developed several VBA macros.
  • Extensively used Data Stage for extraction, transformation and loading process.
  • Identify issues, information, and behaviors during the adoption of a proprietary information management system.
  • Accelerate the rate of adoption of the system, improve the quality of the data being input and generated, and promote accountability amongst the staff and users.
  • Develop code necessary to introduce additional reports, reverse engineer data models to the business meaning, and instruct users on the account management and implementation process advantages derived from the system.
  • Identify and document deficiencies in the proprietary information management system during initial implementation.

Environment: IBM Data Stage 8.0, Excel, Quick Test Pro, Oracle 9i, DB2 UDB, SQL Server 2000, SQL, PL/SQL, PuTTY, WinSCP3, TOAD, SQL Developer, UNIX (AIX), Shell Scripts, Mercury Quality Center 9.0, Microsoft Office 2003, Word, Excel, Outlook, Windows XP/2000, TERADATA V2R6, MLOAD, FLOAD, TERADATA SQL ASSISTANT, BTEQ

Confidential, Manhattan, New York

ETL/SQL Tester

Responsibilities:

  • Worked with Data Profiling for various needs of business.
  • Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
  • Used various checkpoints in the Informatica designer to check the data being transformed
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Extensively used Informatica power center for ETL process.
  • Developed automated scripts for functional testing and Data driven testing of the application using QTP.
  • Extensively worked on QT Pro to design and develop various manual and Goal oriented Scenarios for Application.
  • Worked on calling shell scripts from post-session and pre-session events. Extensively involved in implementing performance tuning techniques for the queries.
  • Involved in the Maintenance and Production Support
  • Used Quality Center as a Defect tracking tool to report the defects encountered while testing. Base lined the Test Plan, Test Criteria & Project Schedule by walkthroughs and review meetings.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • As QA Tester, performing responsibilities with both the functionality and back end testing.
  • Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
  • Optimized QTP scripts for Regression testing of the application with various data sources and data types.
  • Executed regression tests at each new build in QTP.
  • Development of mappings as per the technical specifications approved by the client.
  • Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Reviewed specifications for feasibility of customer list pull criteria and commit date
  • Executed Campaign based on customer request and reviewed execution log to keep track of the number of records going into and coming out of every job step
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
  • Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
  • Tested Database Triggers, Stored Procedure, Functions and Packages.
  • Optimized queries using rule based & cost based approach.
  • Executed campaign based on customer requirements
  • Followed company code standardization rule
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Tuned database and SQL statements and schemas for optimal performance.
  • Expertise in SQL queries for the cross verification of data.
  • Designed documentation for the developed graphs.

Environment: Informatica PowerCenter 7.1, Quality Center 8.0, TOAD 7.6, Oracle 9i, DB2 UDB, QTP, SQL, PL/SQL, UNIX (AIX), Shell Scripts, Word, Excel, Outlook, Windows 2000 / NT.

Confidential, Atlanta GA

QA Tester

Responsibilities:

  • Responsible for building the management process, making sure controls are being followed, assisting in the requirements design, and coordinating the efforts of performers in the Enterprise Information Management Department.
  • Involved unit and integration test for the Informatica and database level.
  • Created technical specifications, mapping documents and managed test cases.
  • Participated in development of an estimation tracking tool for level of effort projections.
  • Gathered information, compiled findings and prepared management reports for staffing levels.
  • Developed database applications for managing IT staffing requirements and monitoring the status of outstanding requisitions.
  • Written several complex SQL queries to validate the data conditions as per the mapping document.
  • Performed Functional Testing and Back-end Testing using the database comparable results Manually
  • Load new or modified data into back-end Oracle database.
  • Implemented Database Checkpoints for Back-end Testing
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
  • Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL Plus
  • Provided data analysis, identified trends, summarized results and generated reports for Card Solutions Delivery reorganization effort.
  • Extracted data from different sources like, Oracle, Flat files, Xml & loaded into Operational Data Source and tested the same.
  • Extensively used SQL and PL/SQL Procedures and Worked in both UNIX and Windows environment.
  • Worked on loading of data from several flat files to XML Targets.
  • Created UNIX shell scripts for Informatica ETL tool to automate sessions.
  • Developed graphic representation of various metrics used in the forecasting, budgeting and procurement processes for the Merchandising Department.
  • Utilized Access database to collect data from multiple database sources using ODBC methods.
  • Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
  • Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
  • Responsible for Unit Testing of the Mappings created according to the business requirements.

Environment: Oracle 7.3, SQL, PL/SQL, SQLPlus, MDL, Gerb Tool, Microstation95, Mainframe, Small world, Windows 2000/NT/98/95, Word, Excel, Outlook, Microsoft office 97, Informatica 6.1, UNIX, Shell Scripting, XML.

Hire Now