ETL QA Tester Resume Samples

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

10+ Years

Level

Senior

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

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.

Experience

7-10 Years

Level

Management

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

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.

Experience

5-7 Years

Level

Executive

Education

Bachelor's

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.

Experience

10+ Years

Level

Senior

Education

Bachelors

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.

Experience

7-10 Years

Level

Consultant

Education

Bachelors