We provide IT Staff Augmentation Services!

Sr. Etl/informatica Tester Resume

2.00 Rating

Beaverton, OR

SUMMARY

  • Over 7 years of QA, Back - End, ETL and Manual Testing experience in Banking with an earned reputation for meeting demanding deadlines and delivering critical solutions.
  • Proficient in the complete Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC).
  • Thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
  • In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
  • Experienced in Preparation and Execution of Test Strategy, Test plan, Test Scenarios, Test Cases, Test Procedures, Test Scripts, Test data for SIT and UAT.
  • Used Quality Center / Rational ClearQuest / Jira for Maintaining the Test Plans, Test Cases, Test Execution, Defect management, and Bug Reporting.
  • Extensive ETL testing experience using Informatica Power Center 9.1/8.1/7.1/6.1 components (Designer, Workflow Manager and Workflow Monitor)
  • Experienced in writing and executing automated test scripts using Quick Test Professional and Load Runner.
  • Experienced in identifying and automating regression suite with Quick Test Professional.
  • Proficient in different phases of Testing: Black Box, White Box, Smoke Testing, Functional Testing, Compatibility Testing, Integration Testing, System Testing, Back-End Testing, Regression Testing and UAT.
  • Experience in creating Test Data, Analyzing Defects and interacting with development team to resolve issues
  • Experienced in creating UAT Test Strategy and execute UAT test scripts.
  • Experienced in Creating and maintaining SQL Scripts to perform back-end testing on databases like Oracle, SQL Server and Postgrese SQL.
  • Experience in working with business analysts, development groups in analyzing business specifications and in working with other testers to resolve technical and end-user issues.
  • Excellent communication skills, ability to work as part of a team and on own. Versatile team player with interpersonal, technical documentation skills and efficiently handling multiple projects simultaneously.

TECHNICAL SKILLS

Test Management: Quality Center, Clear Quest, JIRA (Greenhopper).

Testing Tools: SOAP UI, QTP

Languages: JAVA, J2EE, ASP, .net, C#

Database: SQL Server 2008/2005, Oracle 9i/10g.

ETL Tools: Informatica, Data Stage

RDBMS Tools: SQL Server Management Studio, SQL Developer, TOAD

Scripting Languages: VBScript, JavaScript

Operating system: Windows 2007, Windows XP, VISTA, UNIX, MS-DOS

Web Technologies: HTML, XML

Tools: Microsoft visual studio 2008/2010 (TFS), CVS, Mapforce.

PROFESSIONAL EXPERIENCE

Confidential, Beaverton, OR

Sr. ETL/Informatica Tester

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Interacted with senior peers or subject matter experts to learn more about the data.
  • Validating the Workflows and running them using Workflow Manager.
  • Validating the Autosys jobs and executing them using CA Workload Control Center
  • Prepared Test Plans and Test Cases for the mappings developed through the ETL Informatica tool.
  • Tested different detail, summary reports and on demand reports.
  • Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables.
  • Experience testing tables like SCD Type 1, Type 2 & Type 3 verified history load and incremental load data.
  • Developed 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.
  • Validated target tables DDL, counts, data (Business rules), negative testing and regression testing.
  • Involved in preparing Test Plan from the Business Requirements and Functional Specification, Design, Development and Implementation of RDM (Report Data Mart).
  • Used TOAD Software for Querying ORACLE.
  • Responsible for different Data mapping activities from Source systems to different target systems.
  • Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Involved extensively in doing back end testing of the data quality by writing complex SQL.
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems.
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Ensured data integrity and verified all data modifications and calculations during database migration.
  • Responsible to get Test data from Production source to QA Source
  • Exported Manual Test Cases from MS Excel template directly to QC and executed the Test Cases in Test Director with Pass/Fail/Blocked status.
  • Executed the developed Test Cases and Test Plans and also responsible for creating Test Strategy for the Data Warehouse.
  • Reported the Bugs/Defects using Quality Center 11 & JIRA defect management tool.
  • Responsible for communicating Defect Status Reports to business in project meetings
  • Worked with Production environment to resolve several data issues.
  • Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
  • Performed Functional testing, System testing, Regression testing and Back end testing.
  • Involved in Production Support related activities including resolving end user queries, investigation and resolving data related issues
  • Provide flexible & high quality support to wider Testing strategies on key regular deliverables & Adhoc reporting issues
  • Coordinated with the developers to resolve defects.
  • Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Informatica Power Center 9.1/8.5.1, Oracle 10g, TOAD, SQL, PL/SQL, Excel Files, XML, Windows NT & UNIX, Quality center 10 & JIRA.

Confidential, Buffalo, NY

Sr. ETL/Database Tester

Responsibilities:

  • Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
  • Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
  • Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
  • Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
  • Exported Requirements, test plans and test cases to QC 9.2.
  • Created Traceability Matrix to ensure that all requirements are covered in test cases.
  • Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
  • Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
  • Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
  • Interacting with developers, business analysts to communicate the defects.
  • Bug reporting and Bug tracking using HP Quality Center.
  • Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
  • Worked in Agile methodology during application development and participated in daily scrum meetings.
  • Developed user defined functions, created objects where required and used descriptive programming to automate.
  • Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
  • Developed and ExecutedSQL statementsinToadto retrieve data and to validate data.
  • Tested data migration to ensure that integrity of data was not compromised.
  • Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
  • Responsible for documentation of test results, test matrix,andparticipated in daily/weekly QA meetings.
  • Used Quality Center for logging the defects.
  • Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Informatica Power Center 8.6(Repository Manger, Designer, Server Manager), Oracle 10g, MS SQL, Unix, HP Quality Center 10.0/9.2, TOAD, MS Excel, MS Project.

Confidential, Plano, TX

Sr.ETL Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Developed Test Plan and overall Test Strategy for the Application.
  • Involved in preparation of technical specifications and Source to Target mappings.
  • Developed and executed test cases based on test plan for ETL and BI reporting.
  • Tested the data load process using the Ab Initio ETL tool
  • Tested several data validation graphs developed in Ab Initio environment.
  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
  • Extensively involved in testing the reports for data accuracy and cosmetics.
  • Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
  • Extensively used SQL programming for querying the source and target tables.
  • Deleting the target data before processing based on logical or physical primary key.
  • Design and execute the test cases on the application as per the business requirements.
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Interacted and shared knowledge across the team.
  • Identifying duplicate records in the staging area before data gets processed.
  • Extensively written test scripts for back-end validations.
  • Ensured that the mappings are correct and effectively communicate testing activities and findings in oral and written formats.
  • Reported bugs and tracked defects using Quality Center 10.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Worked on issues with migration from development to testing.

Environment: Quality Center 10, Windows 2000, TOAD 7, Ab Initio, (GDE 1.14, Co>Op 2.14), Oracle 8i, SQL, PL/SQL, SQL Server 2000, Teradata, UNIX, SQL *Loader.

Confidential, Des Moines, IA

Sr. QA Analyst (DWH/Database)

Responsibilities:

  • Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
  • Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
  • Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury 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 the error checking and testing of the ETL procedures and programs Informatica session log.
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
  • Testing the ETL data movement from Oracle Data mart to Teradata Data mart on an Incremental and full load basis.
  • Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
  • Tested whether the reports developed in Business Objects and Crystal Report are as per company standards.
  • Tested Ad-hoc reports, drill down and drill through reports using SSRS.
  • Tested different detail, summary reports and on demand reports.
  • Involved in pre and post session migration planning for optimizing data load performance.
  • Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.

Environment: Informatica Power Center 7.2, MS SQL 2000, Oracle 9i, SQL, PL/SQL, SQL Navigator, Erwin 4.1, Windows XP and 2000, Crystal Reports, Mercury Quality Center.

Confidential, Kansas City, MO

ETL QA Tester

Responsibilities:

  • Extensively used Informatica power center for ETL process.
  • Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Performed testing with mappings for dimensions and facts.
  • Extensively performed testing for various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
  • Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in DB2 environment.
  • Performed testing for conceptual data model that is independent of all the physical considerations and also source of information for logical design phase.
  • Responsible to test the mappings as per the technical specifications approved by the client.
  • Worked with SAS and Mainframe environment.
  • Involved in Unit testing and integration testing of Informatica mappings.
  • Tested Error handling logic to capture the invalid data.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Creating the catalogs and analyzing the joins.
  • Extensively used Informatica for report generation.
  • Maintained various versions of the documents generated during the project using Rational Clear Case.
  • Logged bugs that would enhance the usability of the application using Rational Clear Quest.
  • Designed and implemented basic SQL queries for QA testing and report/ data validation.

Environment: Informatica Power Center 6.2 (Power Center Designer, workflow manager, workflow monitor, ETL, UNIX, Shell Scripting, Oracle 10, SQL Server 2000, Windows 2000. UNIX Shell Scripting UML, RUP

Confidential, Chicago, IL

ETL Test Engineer

Responsibilities:

  • Analyzed business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
  • Scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
  • Written Test Cases to cover overall quality assurance testing.
  • Performed manual testing on different modules of the application.
  • Performed data integrity testing by executing SQL statements and manually verifying the contents.
  • Used SQL to perform Backend Testing on databases.
  • Involved in supporting the deployment of data marts and reports.
  • Performed manual testing prior to automate testing on the application.
  • Scheduled and monitored transformation processes using Informatica Server Manager.
  • Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
  • Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
  • Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.

Environment: Informatica Power Center 6.1/6.2, Oracle 9i, PL/SQL, TOAD, SQL*Loader, XML, SQL, PL/SQL, Autosys, Test Director, HTML, Windows NT/2000

Confidential

DWH/Backend Tester

Responsibilities:

  • Participated in business requirement walk through, design walk through and analyzed Business requirements.
  • Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.
  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
  • Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • 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.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested several stored procedures.
  • Written customized SQL queries for business needs.
  • Did automation using PERL and UNIX Shell scripting.
  • Reviewed system use cases and functional specs with business and System Analysts.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Validating the data passed to downstream systems.
  • Worked with Data Extraction, Transformation and Loading (ETL).
  • Involved in testing data mapping and conversion in a server based data warehouse.
  • Involved in testing the UI applications
  • Involved in Security testing for different LDAP roles.
  • Worked with business team to test the reports developed in Cognos
  • Tested whether the reports developed in Cognos are as per company standards.
  • Used Quality Center to track and report system defects
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Informix, DB2, Java, Cognos, SQL, Teradata V2R4 (MLOAD, FLOAD, FAST EXPORT, BTEQ), XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, DB2, SQL Server 2000, Mainframe, SunOS 5.8, DTS, ERWIN, Windows XP

We'd love your feedback!