ETL Tester Resume Samples

An ETL Tester will be responsible for validating the data sources, data extraction, applying transformation logic and loading data in the target tables. A professional ETL Tester Resume mentions the following key responsibilities – verifying the tables in the source system, conducting data threshold validation check; loading data from the staging area to the target systems; ensuring if aggregate values and calculated measures are loaded in the fact tables; testing the ETL tools; checking view created based on the target table, and checking reports based on loaded fact and dimension table.

Key qualifications that can highlight a resume include the following – proficiency in using testing tools, knowledge of various databases including Oracle and SQL; skillful in MS Office, a solid understanding of various programming languages and extensive testing ETL experience using Informatica. An advanced computer science degree is expected for this role.

ETL Tester Resume example

ETL Tester Resume

Objective : Having 7+years of experience on Manual and Automated Software Testing. The software testing experience includes ETL testing on Informatica, Data Stage tool and web based testing on PeopleSoft CRM system with functional knowledge of CRM. Good understanding of SDLC methodologies and worked elaborately on all phases of STLC.

Skills : Informatica 8.6.1,9.0.1, Data Stage 7.5,8.1,Quick Test Professional 9, Win Runner 7.0,Data Stage ETL, Oracle 10g, Quality Center, Teradata,OBIEE,HP QC, ALM,PeopleSoft CRM 8.9,HTML, DHTML, VBScript,UNIX And Windows.

Description :

    1. Experienced in software test design, test development, Testing, and Quality Assurance practices in a structured, full life-cycle development and validation environment, seeking a for ETL / SQL/ BACKEND Test Engineer position.
    2. Experienced in SDLC process and STLC processes and best practices Proficient in gathering and analyzing the Business Requirements, documenting System Requirement specification, Functional Requirement Specifications, Requirements Traceability Matrix.
    3. Experienced using query tools for Oracle, Teradata, Redbrick and MS SQL Server to validate reports and troubleshoot data quality issues.
    4. Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management) Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Teradata and Flat Files.
    5. Experienced in Automation testing using QTP.
    6. Experienced in testing and writing SQL and PL/SQL statements.
    7. Expertised in TOAD, WinSQL, Davis and BTEQ query tools.
    8. Expertised in working in Agile Environment (Scrum), Waterfall.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Master's


Jr. ETL Tester Resume

Objective : An accomplished test lead with extensive experience in project management, requirements definition, software testing, and quality assurance in a variety of industries, including insurance, financial services, telecommunications, government, utilities, Internet, and e-Business. Experienced in developing and implementing comprehensive SDLC and test methodologies department wide and company wide.

Skills : Informatica 9.0, Informix, DB2, Java, Cognos, SQL, SQL Server 2008, PERL, Teradata 12, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, QTP,WinSQL, Ultra Editor, Rumba UNIX Display, Quality Center 9.0.

Description :

    1. Lead Sears Holdings Corporation is the nation's fourth-largest broad line retailer with approximately 3,900 full-line and specialty retail stores.
    2. Enabled for quickly supplement our existing catalog with products from large retailers.
    3. Provided ease of integration with the SHC marketplace (ecommerce) while requiring the least program management overhead.
    4. Targeted and leveraged the assortment of large retailers, SHC will become more relevant in existing categories where our assortment is not very deep (i.e.electronics) and quickly expand and become relevant in categories where we currently do not participate (i.e.water sports).
    5. Involved in identifying the defects and developed defect tracking reports using hp quality centre, which involved the bug life cycle.
    6. Reached testing goals by doing data completeness, data transformation, data quality, performance and scalability performed with system testing, functional testing, regression testing.
    7. Tested and validated the report net reports by running similar SQL queries against the source system(s).
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Associates


Sr. ETL Tester Resume

Summary : Over 5+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence. Extensive ETL Testing experience. Package Software: Expertise in Informatica ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.

Skills : Unix, Teradata SQL, Quality Center, Ab-intio, Wherescape Red, DW/ETL And Database Testing.

Description :

    1. Supports distribution channels such as mobile, tablet and web, providing a modern approach to the systems that touch virtually every point of contact with the customer giving airlines autonomy, flexibility and distribution control, in line with IATA's New Distribution Capability (NDC) initiative.
    2. Tests the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
    3. Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
    4. Involves in End -end Testing for Booking, Flights, Inventory, React and Depart modules Automated the smoke test cases of AirCore Automated the regression test cases of Depart and Ticketing modules of AirCore using RFT 8.1.
    5. Performs performance testing on the entire module of AirCore (every 10 builds once) Analyzing and translating business and functional specifications into testing requirements.
    6. Performs manual testing on different modules of the application.
    7. Prepares the Test Cases, Review of Test cases, Test Scripts, Test Documentation Actively participated in Build Verifications Testing (smoke test).
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
BS

ETL Tester I Resume

Objective : 7+ years of extensive experience in Quality Assurance, manual and automation testing of ETL and Data Warehousing applications. Experienced with all aspects of software life cycle development cycles including planning, estimating effort for testing and requirements gathering Expert in writing complex SQL queries using Cursors, Functions, Joins for all databases including Oracle, SQL Server, DB2 and Teradata.

Skills : ETL, Testing.

Description :

    1. Written Test Cases for ETL to compare Source and Target database systems.
    2. Prevented occurrences of multiple runs by flagging processed dates.
    3. Personalized Cognos Connection for specified display options for testing regional options and personal information.
    4. Developed data quality test plans and manually executed ETL and BI test cases.
    5. Used various types of transformations such as Expression, Joiner, Update Strategy, Lookup, filter for developing mappings.
    6. Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
    7. Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools.
    8. Developed test cases to accomplish ETL data migration.
    9. Involved in Unit testing and integration testing of Informatica mappings.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

ETL Tester II Resume

Headline : Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications. Solid Back End Testing experience by writing and executing SQL Queries. Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software.

Skills : Testing, SQL Server, Coding, Testing.

Description :

    1. Involved in understanding the Logical and Physical Data model using Erwin Tool.
    2. Prepared the guides for UAT & Production readiness for entire ETL testing efforts.
    3. Prepared Execution procedure document format to prepare the Test cases based on a mapping document.
    4. Lead team of 6 people offshore and 2 onsite.
    5. Implemented logical and physical data modeling with STAR schema using Erwin in Data Marts Ensured that the mappings are correct and Conducted data validation testing.
    6. Validated XML Documents before sending the Message Bus.
    7. Used DS Director to running, monitor and view the logs the Data Stage Jobs Worked with business analysts and developers in setting up test data.
    8. Written several complex SQL queries for validating Cognos Reports.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

ETL Tester III Resume

Summary : A Seasoned ETL Tester consultant with 6+ years of experience in Investment Banking and Financial Services, Clearing and trading domains. Experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server, and Informatics Power Center, Power art (Repository Manager, Server manager, and Mapping Designer, Mapplet Designer, Transformation Developer and Warehouse designer).

Skills : MS Office, SQL, Testing.

Description :

    1. Created a Test Plan for System Testing.
    2. Worked on EDI (Electronic data interchange) transactions: 270, 271, 834, 820, 835, and 837 to identify key data set elements for designated record set.
    3. Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands-on system testing.
    4. Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
    5. Tested and Analyzed ICD 9 and 10 codes.
    6. Identify & record defects with the required information for the issue to be reproduced by the development team.
    7. Scheduled jobs using Tidal Tool Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
    8. Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
    9. Tested the claims processing with EDI transactions (270, 834, 835, 837) in HIPAA and HL7 Environment.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Asst. ETL Tester Resume

Objective : 7+ years of IT experience as an ETL Tester in Banking and Healthcare Domain. Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments. Expertise in Software Quality Assurance Testing specialized in ETL, Business Intelligence and Data Testing and Solid Back End Testing experience by writing and executing SQL Queries.

Skills : Management, SQL Server, Testing

Description :

    1. Worked on projects of moderate to high complexity that requires in-depth knowledge across multiple technical areas and business segments.
    2. Performed detailed software Business requirements and technical design reviews to assure comprehensiveness and consistency.
    3. Analyzed Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
    4. Provided high-level and detailed QA testing resource estimates to the QA Manager and Project Managers in a timely manner.
    5. Translated Business requirements and technical design into comprehensive test plans and test cases assuring maximum requirements coverage.
    6. Developed SQL queries for back-end testing/database testing and participated in end-to-end testing.
    7. Validated the source system data with the staging data using SQL and SQL scripts.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

ETL Tester Resume

Headline : Experienced Quality Assurance Analyst (ETL) with 7+ years of experience in the Information Technology industry, involving analysis, both Manual and Automated testing of Client Server, ETL, OLAP and Web applications. Worked on various Domains like E-Commerce, Supply Chain and Possess specific experience in the Banking, and Finance.

Skills : MS Office, Management.

Description :

    1. Created to promote and support the common business interests of the Commercial and Residential Mortgage markets.
    2. Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
    3. Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
    4. Created Test Cases and developed Tractability Matrix and Test Coverage reports.
    5. Managed and conducted System testing, Integration testing, and Functional testing.
    6. Worked on SQL scripts to load data in the tables.
    7. Extensively worked with DS (Designer, Director, and Manager).
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Lead ETL Tester Resume

Summary : 5 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Client-Server and Legacy Mainframe applications and Data Warehousing. Worked with IT Operations to ensure test environment readiness. Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.

Skills : MS Office, Management, SQL Server.

Description :

    1. Prepared Test Plan from the Business Requirements and Functional Specification.
    2. Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing, and Report testing.
    3. Tested to verify that all data were synchronized after the data is troubleshot and also used SQL to verify/validate my test cases.
    4. Experienced with onsite-offshore Co-ordination.
    5. Tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
    6. Created resource forecast, ramp-up plans, & resource utilization plans.
    7. Worked will include a loading of historical data onto the Teradata platform, as well as reference data and metadata.
    8. Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
    9. Tested Business Objects reports and Web Intelligence reports.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

ETL Tester Resume

Summary : 8+ years of ETL/QA/DWH testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling. Very good knowledge of data ware house systems and ETL systems.

Skills : Test Director, Quality Center.

Description :

    1. Participated the sessions for requirements review and Analyzed business requirements, data mapping requirement specifications along with the team.
    2. Involved in Data-centric testing using various approaches such as checksum approach to discover errors, identifying records with MD5 Created Test Strategy and Business Assurance strategy Documents.
    3. Written positive and negative test cases for Micro Strategy reports based on report specifications.
    4. Validated several Drilldown and Pivot reports published in Micro Strategy Scoreboard.
    5. Worked on Functional and GUI testing of the web application making sure the application looks and functions as per requirements.
    6. Created Test Plans which included test deliverables, features to be tested/not tested, Pass and Fail criteria of a test and so on.
    7. Created Unix Shell Scripts for Data-Centric applications Created Test Cases according to the Business requirements and ensured that all the positive and negative scenarios of testing are covered.
    8. Involved in Creating The Business Assurance Strategy Document and Test Strategy Document.
    9. Conducted review sessions for the Test cases with the BSA's and Developers.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Consultant
Education
Education
Master's