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, NCSr.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, GAETL 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, MDQA 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.