ETL QA Tester Resume Samples

The role of an ETL QA Tester is too crucial for companies that employ the ETL process and development. The job description entails testing ETL software and its components with an effort to identify, solve and provide solutions for potential issues. A well-drafted ETL QA Tester Resume mentions the following core duties and tasks – developing and executing various manual testing scenarios, documenting the process for performing functional testing on the application, testing source and target database for conformance with specifications; and executing plans for data profiling and BI report testing.

Those seeking this job role must highlight the resume such as skills as experience in quality assurance in information technology; extensive knowledge in ETL/data warehouse backend testing; and BI intelligence report testing; and demonstrate a solid understanding of software development lifecycle. Employers look for resumes that display a degree in computer science or related fields.

ETL QA Tester Resume example

ETL QA Tester Resume

Objective : Over 7+ years of ETL QA Tester Professional Experience in Software Quality Assurance and Testing in different environments and platforms. Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client-Servers. Experience in Data Warehouse applications testing using Informatica Power Center and Data stage on multiple platforms.

Skills : Netezza, Teradata, SQL Server, Unix, Oracle, SSIS, SSRS, C#, ETL Tester.

Description :

    1. Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
    2. Created test data for testing specific ETL flow.
    3. Tested Maven scripts for various tasks to automate the build process and for the deployment.
    4. Expertised in Junit and TestNG testing Framework testing with Selenium.
    5. Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
    6. Interacted with the Offshore Team members about the project status utilizing conference calls.
    7. Designed the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
    8. Extracted certain column of data from a number to files using PERL.
    9. Developed Automation Scripts using JAVA in Eclipse.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors


Jr. ETL QA Tester Resume

Objective : 7+ years of ETL QA Tester experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI and ETL Testing. Experienced in coordinating with resources within Onsite-Offshore model Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, Iterative and Extreme Programming.

Skills : Informatica 7.1, Flat Files, Erwin 4.0, MS SQL Server 2000, Oracle 9i, SQL, PL/SQL, IBM DB2 8.0, AGILE, Teradata V2R6, , Business Objects XIR2, COBOL, Quality Center 9.0 Autosys, UTL_FILE, TSO, ISPF, OS/z, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000.

Description :

    1. Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2 Assisted in creating fact and dimension table implementation in the Star Schema model based on requirements.
    2. Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
    3. Expertised in writing Complex SQL/PLSQL Scripts in querying SQL Server, Teradata, and Oracle.
    4. Defined data requirements and elements used in XML transactions.
    5. Tested the database schema with the help of data architects using ERWIN.
    6. Involved in the testing of Data Mart using Power Center.
    7. Identified and Documented additional data cleansing needs and consistent error patterns that could be diverted by modifying ETL code.
    8. Experienced in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors


Sr. ETL QA Tester Resume

Summary : 6 years of overall ETL QA Tester IT exposure in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client-Server and Legacy Mainframe applications.

Skills : MS Office, Management, SQL.

Description :

    1. Prepared Test Plan and Testing Strategy for the project.
    2. Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
    3. Tested different detail, summary reports and on-demand reports developed by Report Studio.
    4. Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads.
    5. Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
    6. Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
    7. Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

ETL QA Tester I Resume

Objective : Over 7 years of ETL QA Tester experience testing Data Warehouse, Database (ETL & BI), Web, and Client-Server Systems and Applications for Banking, Insurance, Financial, and Retail 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).

Skills : MS Office, SQL Server.

Description :

    1. Assisted in creating fact and dimension table implementation in the Star Schema model based on requirements.
    2. Used Quality Centre for tracking the defects.
    3. Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI's.
    4. Tested ad hoc and canned reports for Business objects.
    5. Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
    6. Worked as ETL Tester responsible for the requirements gathering / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
    7. Involved in Implementing Agile (Scrum) methodologies for the complex project modules.
    8. Tested and worked on creating open document reports for the business.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

ETL QA Tester II Resume

Headline : 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 for all databases including Oracle and SQL Server.

Skills : Ab Initio CO>OP 2.15, GDE 1.15, Informatica Power Center.

Description :

    1. Developed test plans based on test strategy for Data Warehousing Application.
    2. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
    3. Written complex SQL queries for querying data against different databases for data verification process.
    4. Prepared for technical specifications and Source to Target mappings.
    5. Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
    6. Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the business requirements.
    7. Used Quality Center to track and report system defects Design and execute the test cases on the application as per company standards.
    8. Prevented occurrences of multiple runs by flagging processed dates.
    9. Written Test Cases for ETL to compare Source and Target database systems.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

ETL QA Tester III Resume

Summary : Actively seeking internship opportunity as Business Analyst/Project Manager by leveraging my 3.5 years of ETL QA Tester professional experience with global corporations, such as Cognizant and HSBC. Developed Data Warehouse using Informatica as an ETL tool, under AGILE methodologies such as Scrum.

Skills : Test cases, MS Office, Management

Description :

    1. Broaded data, root cause, and process analysis of quality and compliance programs to ensure customer satisfaction
    2. Provided feedback on a team and departmental level on complex trends and root causes
    3. Recommended intervention strategies for continuous process improvements for improved efficiency and effective operations
    4. Monitored and improved existing quality processes to streamline and ensure compliance of internal/external regulatory inquiry areas
    5. Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version 4010 to 5010 and translation of ICD 9 codes into ICD 10 codes.
    6. Expertised in SQL queries for cross verification of data.
    7. Involved in extensive DATA validation using SQL queries and back-end testing.
    8. Used SQL for Querying the DB2 database in the UNIX environment.
    9. Validated batches of medical claims data, patient details, and service line data in the EDI 837 and EDI 835 files, 270 (Eligibility) and 276 (Claim Status) data.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Asst. ETL QA Tester Resume

Objective : Over 8 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client-Server Systems and Applications for Banking, Insurance, Financial, Healthcare, and Retail Industries. In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.

Skills : Oracle SQL Developer 2.1.1,Informatica Power Center.

Description :

    1. Involved in Business analysis and requirements gathering.
    2. Assisted in creating fact and dimension table implementation in the Star Schema model based on requirements.
    3. Defined data requirements and elements used in XML transactions.
    4. Involved in Business analysis and requirements gathering.
    5. Assisted in creating fact and dimension table implementation in the Star Schema model based on requirements.
    6. Assisted in kicking off ETL jobs using Data stage Director and analyzed the data in dimension and fact tables.
    7. Reviewed the session log files in Data stage Director in case of job failures.
    8. Experienced in testing the ETLs developed using the Data stage tool.
    9. Reviewed the Test Cases and Test Scripts with Business Users and made some corrections.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor's

Associate ETL QA Tester Resume

Headline : Around 6+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.

Skills : SQL Server, Management.

Description :

    1. Analyzed the requirements from the client and developed Test Cases based on functional requirements, general requirements and system specifications.
    2. Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
    3. Worked exclusively with Integration Test Team for E-Commerce units Integration Testing.
    4. Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
    5. Experienced working in Agile and Waterfall methodology.
    6. Created the Regression Test Cases and automated them for the purpose of Regression Resting using QTP.
    7. Verified session logs to identify the errors occurred during the ETL execution.
    8. Created Test Cases, traceability matrix based on mapping documents and requirements.
    9. Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor's

Lead ETL QA Tester Resume

Summary : Overall 9+ Years of experience in System Integration Testing of Web & ETL Applications. Excellent 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.

Skills : Waterfall model, Management.

Description :

    1. Completes all assigned functional, regression, performance, and tests of applications within the appropriate timeline.
    2. Participates in project-level planning and reviews and approvals sessions, which includes business requirements and Application Software Requirements/Design review meetings.
    3. Analyzes and understands ETL structural mapping and technical specification documents. Create test cases to perform Sanity, Functional, Regression, Database and ETL Testing. Analyze and report on complex data; both source and target systems to identify potential gaps in mapping documentation.
    4. Designs tests for DW/ETL source data extraction, business transformation logic and target table loading.
    5. Identify, analyze and document problems with functionality, output files, or tables. Monitor defect resolution efforts and track progress.
    6. Writes complex SQL queries and develop solution diagrams to demonstrate new capabilities.
    7. Defines data quality test strategy and test plan in collaboration with project stakeholders.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

ETL QA Tester Resume

Summary : The primary responsibility ETL QA Tester position is to conduct testing with jurisdictions or other entities on designated applications. The resource must have a good foundation of knowledge of the AAMVA applications, testing experience and be able to deliver a high degree of customer service.

Skills : SQL, Management.

Description :

    1. Conducts reviews on test results based on AAMVA business/technical specifications.
    2. Defects logging, tracking, status reporting, and communication.
    3. Facilitates and conducts testing with customers implementing new and/or enhanced applications, including system testing for any jurisdiction making system or platform changes.
    4. Participates in the review process for testing and procedural documentation related to testing.
    5. Attends periodic meetings to discuss testing, concerns, reviews and schedules of testing, and any changes to the technical or business documentation.
    6. Participates in customer out-reach, including but not limited to surveys, phone calls, scheduling, etc. and take part and provide input to various workgroups.
    7. Participates in or conduct the training of government staff.
    8. Provides input into department status reports.
    9. Attends periodic meetings to discuss issues, problems, and receive updates from management.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Consultant
Education
Education
Bachelors