We provide IT Staff Augmentation Services!

Sr. Etl Test Engineer Resume

Washington, DC

SUMMARY:

  • Over 7+ years of extensive experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, Manual testing of Web, and Client/Server based commercial applications.
  • Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
  • Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
  • Extensive experience in testing ETL data from multiple sources into Data warehouse using Informatica.
  • Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
  • Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Data stage tools.
  • Extensive ETL testing experience using Informatica Power Center 9 / 8.1 components (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Expert in using Test Management Tools - HP Quality center 10
  • Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
  • Experience in writing complex SQL and PL/SQL statements.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
  • Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
  • Ability to understand and adapt to new technologies and environments faster, good at analysis and troubleshooting and excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9/8.x, Data Stage, Ab Initio (GDE 1.15, Co>Op 2.14

Bug Reporting: Quality Center 10.0 / 9.0/8.2, ALM, Rational Clear Quest, TFS 2010

Programming/Scripting Languages: SQL, PL/SQL, XSLT, JCL, HTML, XML

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX-UNIX, LINUX

Databases: Oracle 11g/ 10g/9i, MS SQL Server 2008 / 2012, Sybase12.0/11.0, MS Access 2005, Teradata 13 / V2R6/V2R5

Reporting Tools: Business Objects, Micro Strategy 9, Cognos 8.0

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr. ETL Test Engineer

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.
  • Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
  • 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
  • Extensively used Informatica for extraction, transformation and loading process
  • 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 PM.
  • Exported Requirements, test plans and test cases to TFS 2010.
  • 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.
  • Assisted in kicking off ETL jobs using UNIX and analyzed the data in dimension and fact tables
  • 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 Executed SQL statements in Toad to 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, and participated 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 9.1/8.5.1, Oracle 11g, TFS 2010, UNIX, Teradata 13, MS SQL Server, HP Quality Center 10.0/ ALM, TOAD, MS Excel, MS Project, Business Objects.

Confidential, Durham, NC

Sr.ETL Tester

Responsibilities:

  • Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
  • Participated in analysis of Business and functional requirements.
  • Interacted with Business users to determine User requirements and goals.
  • Created reports that included a general overview, open bugs, new bugs and enhancement requests.
  • Entered new bugs and maintained the current status of those bugs.
  • Responsible for communicating Defect Status Reports to business in project meetings.
  • Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
  • 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.
  • Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
  • Used Data Stage to test mappings, transformations and source and target tables
  • Developed Test Strategy, Test plans, and Test scenarios using MS Word and MS Excel.
  • Developed Test Cases and Test Scripts for System and UAT Testing.
  • Performed Positive and Negative Testing for many scenarios and applications.
  • Performed basic testing of security features using manual testing.
  • Responsible for creating Test Strategy for the Data Warehouse.
  • Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
  • Identifying defects and logged/tracked them using bug tracking tool Rational Clear Quest.
  • Tested the Oracle SQL testing programs and tested the Oracle Applications and Portals like Executive Dashboard, Credit Mortgage lookup built on Oracle.
  • Used RAPID SQL Software for querying DB2.
  • Conducted review sessions on test case and regression test scripts in Quality Center and defect in Clear Quest.
  • Used Data Stage director to run the data stage jobs and verify according to data mapping requirements.
  • Coordinated in testing Data stage ETL using complex stored procedures.
  • Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
  • Tested several UNIX Korn Shell scripts for ETL data loading
  • Verified the property and loan order information like data in the pricing models against source and target databases by using SQL Queries.
  • Extensively used SQL queries to check storage and accuracy of data in database tables.
  • Used SQL for Querying the Oracle database.
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
  • Tested whether the reports developed in Cognos are as per company standards.
  • Tested different detail, summary reports and on demand reports using Report Studio.
  • Worked with business team to test the reports developed in Cognos.

Environment: Oracle 11g, Data Stage, SQL Server, Cognos 8.0 Series, XML, Test Cases, Unix, Test Matrix,, TOAD, HP Quality Center 9.2

Confidential, Atlanta, GA

ETL Data Warehouse Tester

Responsibilities:

  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet designer and Transformation.
  • 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.
  • Tested the ETL process for both before data validation and after data validation process.
  • Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
  • Performed Data Analysis during the requirements gathering phase by reviewing the source data model and running SQL queries
  • Testing has been done based on Change Requests and Defect Requests.
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Involved in integration testing of Informatica mappings.
  • Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
  • Responsible for different Data mapping activities from Source systems to Teradata.
  • Queried Teradata Database and validated the data using SQL Assistant
  • Used Quality Center to track and report system defects.
  • Performed Data validity testing for reports and feeds based on client's requirement.
  • Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
  • Responsible for communicating Defect Status Reports to business in project meetings.
  • Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
  • Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
  • Involved in meetings and walkthroughs.
  • Responsible for weekly status.

Environment: Informatica Power Center 8 (Power Center Designer, workflow manager, workflow monitor, UNIX, Oracle8, Teradata V2R4, SQL Server 2005, Windows 2000, Cognos8.4.1,Quality center 9.2

Confidential, Rockville, MD

QA Analyst

Responsibilities:

  • Created Test Plan and Test Scripts and analyzed the user/business requirements. Functional specs, Use Case documents and created the Test Plans, Test cases for System testing.
  • Executed of generated Test Cases Manually in Test Director.
  • Created the Regression Test cases and automated them for the purpose of regression Testing.
  • Developed and maintained automated test scripts to support regression testing and participated actively in system testing and regression testing.
  • Developed and maintained the regression test bed.
  • Complete responsible for manual testing of the Web Site.
  • Attended project meetings, release meetings, and QA status meetings.
  • Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using Requisite Pro RUP.
  • Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
  • Conduct workflow, process diagram and gap analyses to derive chuck for existing systems enhancements
  • Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Environment: Oracle8, DB2, Teradata, MS Excel, MS Word, MS PowerPoint, SQL, MS Project, 7.0, Quality Center, Windows NT, J2EE, Oracle 8i, EJB 2.0.

Hire Now