ETL QA Analyst Resume Samples

An ETL QA Analyst is responsible for delivering quality, and well-tested ETL processes to production. While specific duties vary based on the client’s requirements, the following are certain core tasks that are mentioned on the ETL QA Analyst Resume – creating detailed database test automation scripts capable of validating schemas, data elements, and advanced calculations; writing and executing tests, monitoring testing progress, finding and logging defects, tracking defect fixes, gathering and reporting status, and taking responsibility for quality. Other duties include adherence to SDLC and QA processes and participating in continuous improvement of team and processes.

Hiring employers will look for the following skills on the resume – experience testing ETL processes typically in SQL server and Vertica and Hadoop environment; advanced level SQL and data analysis skills; strong knowledge and understanding of QA theory and methodologies and solid knowledge of data analysis, data modeling, database design, data migration, and BI solutions. Those looking for such a role should exhibit on the resume a Computer-related degree with relevant certification.

ETL QA Analyst Resume example

ETL QA Analyst Resume

Objective : Information technology professional with expertise in Quality Assurance and over 8 years of experience in software testing. Extensive testing ETL experience using) Informatica 6.1, 7.1, 8.1, 8.6.1 (Power Center/ Power Mart (Designer, Workflow Manager, Workflow Monitor and Server Manager) Strong knowledge of Software Development Life Cycle (SDLC), Testing Methodologies, Techniques, testing documentation and implementation in all phases.

Skills : Management, MS Office, Testing

Description :

    1. Integrated various types of available Physicians care management information and gives all the information about the number of active patients, prescriptions, number of outpatients, number of ambulatory prescriptions and then screens this data for cost effective patient care.
    2. Coordinated and assisted with the test lead testing at every step of the quality cycle from test planning through execution to defect management.
    3. Participated in Business Analysis, Requirement Analysis and Data Analysis.
    4. Participated in conducting Manual and Automated Tests with Mercury Tools.
    5. Defined and performed the Test strategies and associated scripts for the verification and validation of the application ensuring that it met all defined business requirements and associated functionality.
    6. Performed rigorous manual testing such as GUI testing, black box testing, integration testing and system testing.
    7. Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
    8. Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Masters


Jr. ETL QA Analyst Resume

Objective : Result oriented ETL QA Analyst professional with 2 Years of hands-on experience in diversified fields of the Software Development Life Cycle with experience in managing testing lifecycle process end to end using Waterfall & Agile methodologies. 4 years of experience as a Test Lead in multiple projects managing and delivering enterprise scale software on-time and quality with their scope intact.

Skills : Oracle SQL, ETL Testing, Salesforce.com Testing, Microsoft VBA.

Description :

    1. Provisions aim is to satisfy the data requirements for projects looking to source the data from IAS and clean up the current IAS environment.
    2. Sources by Data Provisioning will be uniquely identified, and mappings and coding will be reviewed by proper resources.
    3. Reviews and analyzes the business requirements.
    4. Creates a high level test strategy and present it to the business team.
    5. Attends the source to target mapping walkthrough meeting and analyze the source to target mapping document.
    6. Develops and executes the Test Plan, Test Scripts and Test case execution based on Waterfall methodology.
    7. Prepares the source and target SQL queries in Oracle SQL developer and Teradata SQL Assistant.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor


Sr. ETL QA Analyst Resume

Summary : 7+ years of total IT experience in all aspects of project development life cycle including Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling, and Supporting for Enterprise Data warehousing, Data marts, Data Conversion, Data Integration, Data management projects. Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.

Skills : MS Office, Management.

Description :

    1. Involved in requirements gathering and analysis to define functional specifications.
    2. Worked on Process Design, Development, Testing and Implementation of the Project.
    3. Analyzed existing database schemas and designing star schema models to support the users reporting needs and requirements.
    4. Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files.
    5. Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
    6. Worked in Informatica B2B Data Transformation.
    7. Extensively worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
    8. Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

ETL QA Analyst I Resume

Objective : Having 2+years of extensive experience in Software Quality Assurance and ETL Testing with strong knowledge of Software development life cycle (SDLC) and Software Testing Life Cycle (STLC) Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios Hand on experience in Functional testing, Integration testing, System testing, Regression testing, coordinating User Acceptance Testing (UAT) and End to End testing Expertise in Data warehousing, database testing in Financial, Health Care and Banking domains.

Skills : Testing, MS Office, Management.

Description :

    1. Led provider of personal and commercial property and casualty insurance and long-term retirement savings products.
    2. Involved in developing Right, a web based system for quoting, and maintaining and issuing auto and homeowner insurance policies.
    3. Involved in Data Validation using SQL queries.
    4. Performed negative testing, to make sure validations are done properly.
    5. Provided update to management on testing status and some other issues.
    6. Carried out and oversee test execution for Business scenario, User acceptance and Regression testing Involved in Data Validation with Business Team.
    7. Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
    8. Created and executed SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

ETL QA Analyst II Resume

Headline : Over 8 years of extensive experience in software quality assurance, data analysis and testing with strong knowledge of software development life cycle (SDLC) and software testing life cycle (STLC). Hands on experience in analyzing business requirements, functional requirements, design specification and developing test plan and test scenarios.

Skills : MS Office, Management.

Description :

    1. Prepared test plans and test scenarios by understanding and analyzing business requirements.
    2. Developed test cases, test scripts from the data mapping documents and functional specification documents.
    3. Mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
    4. Worked on all the stages of SDLC for this project and designed and executed functional, integration, regression, and system (end-to-end), UI testing, browser compatibility, backend (database) testing.
    5. Developed and executed test cases and test scripts.
    6. Involved in testing the UI screens, reports which was used by the internal business team.
    7. Prepared test scenarios by creating mock data based on the different test cases.
    8. Involved in testing SSIS packages, and also involved in data migration.
    9. Involved in testing the functionality of Ab Initio graphs.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

ETL QA Analyst III Resume

Summary : 7+ years of total IT experience in all aspects of project development life cycle including Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling, and Supporting for Enterprise Data warehousing, Data marts, Data Conversion, Data Integration, Data management projects. Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.

Skills : MS Office, Management, Testing.

Description :

    1. Involved in requirements gathering and analysis to define functional specifications.
    2. Extensively worked on Process Design, Development, Testing and Implementation of the Project.
    3. Analyzed existing database schemas and designing star schema models to support the users reporting needs and requirements.
    4. Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files.
    5. Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
    6. Worked in Informatica B2B Data Transformation.
    7. Extensively worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
    8. Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Asst. ETL QA Analyst Resume

Objective : Experience as ETL QA Analyst in testing of web based applications and manual testing Involved in testing end-to-end ETL process, DWH applications and SQL Queries for data validation.

Skills : MS Office, Management.

Description :

    1. Explored, understood, and owned the entire study lifecycle.
    2. Explored, developed, and presented insights that to the whole company that inform product roadmap and strategy, using one of the world’s largest learning science databases.
    3. Driven maturity and excellence in the way we measure the success of our business.
    4. Led A/B testing through the entire experimentation life cycle, including inception, creation, measurement, and recommendations.
    5. Worked closely with Business user in Understanding designing and documenting the Functionaltesting plan and then Writing, executing, documenting the results and Logging defects.
    6. Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings Involved in complete life cycle activities like pre-testing phase and testing phase.
    7. Analyzed system requirements specifications, developed executed detailed test plan test cases, security and usability of application information.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Associate ETL QA Analyst Resume

Headline : Around 7 + years of ETL QA Analyst professional experience in Software Industry, Expertise in all kinds of testing (Manual and Automation) with focus on Business Intelligence, ETL, Data warehouse, DataMart, Databases, Web services, Client-Server applications Extensive knowledge on all phases of Software Development Life Cycle (SDLC).

Skills : MS Office, Management.

Description :

    1. Connected consumers, businesses, financial institutions and governments in more than 200 countries and territories to fast, secure and reliable digital currency.
    2. Underpinned digital currency is one of the world's most advanced processing networks - VisaNet - that is capable of handling more than 10, 000 transactions a second, with fraud protection for consumers and guaranteed payment for merchants.
    3. Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
    4. Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
    5. 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.
    6. Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
    7. Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
    8. Tested the XMLs feeds received from another source which is a third party for data consistency.
    9. Tested the ETL with XML as source and tables in the data warehouse as target.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Management

Lead ETL QA Analyst Resume

Summary : 6+ years of IT experience in analyzing business requirements, development and execution of test cases and defect management. Experience with test plans, test cases, test scripts and customizing test data. Extensive experience with RDBMS technologies , Oracle [] and MS SQL Server. Excellent experience with SQL concepts like DDL, DML, subqueries, joins, set operators and conditional expressions.

Skills : MS Office, Management.

Description :

    1. Analyzed the Functional requirements using Detailed Design Document.
    2. Set up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
    3. Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting Developed test cases and SQL queries based on mapping document.
    4. Worked with development team to ensure testing issues are resolved.
    5. Executed Ab Initio ETL graphs from UNIX environment.
    6. Reviewed log files in UNIX for error cause when graphs failed.
    7. Written SQL queries to validate Ab Initio graphs and transformations.
    8. Coordinated and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
    9. Queried Teradata target tables using SQL Assistant and documented results.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Management

ETL QA Analyst Resume

Summary : Expertise in all kinds of testing (Manual and Automation) with focus on Business Intelligence, ETL, Data warehouse, DataMart, Databases, Web services, Client-Server applications Extensive knowledge on all phases of Software Development Life Cycle (SDLC).

Skills : MS Office, Management.

Description :

    1. Involved in testing the claims application for Aetna, This application accepts different claims like Medical claims, Dental claims, Pharmacy claims and vision claims from different vendors and route the claims into Batch Adjudication System and Online Adjudication.
    2. Checked the files and then they will move the claims to Payment department.
    3. Assisted entry-level tester (s) on reviewing requirement, preparing and executing test cases and report software defects.
    4. Performed black box, Functional, Integration, Stress and Regression testing of the Website.
    5. Performed Regression Testing to verify various sections of the system to ensure that changes or fixes in the system not only work, but also do not adversely affect the remainder of the system.
    6. Created and executed SQL queries to validate the data and used data manipulation language.
    7. Updated the data in the database and verify with front end that application handles the changes correctly.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Consultant
Education
Education
Bachelors