ETL QA Analyst Resume Samples

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. Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.

Experience

2-5 Years

Level

Junior

Education

Masters

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor

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.

Experience

10+ Years

Level

Senior

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Monitored and alerted on any deviations from expected results.
2. Ensured that all business analysts have a clear understanding of the ETL process.
3. Documented the ETL process so it can be communicated to others.
4. Worked with other engineers to troubleshoot and fix any issues.
5. Reviewed any new processes or changes to existing processes before implementation.
6. Communicated changes to business analysts throughout the project lifecycle.
7. Maintained a clean environment by ensuring tools are up to date and unused software is removed when no longer needed.

Experience

7-10 Years

Level

Management

Education

Bachelors

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 worlds 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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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. Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
7. Tested the XMLs feeds received from another source which is a third party for data consistency.
8. Tested the ETL with XML as source and tables in the data warehouse as target.

Experience

5-7 Years

Level

Executive

Education

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.

Experience

10+ Years

Level

Senior

Education

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.

Experience

7-10 Years

Level

Consultant

Education

Bachelors