ETL Tester Resume Samples

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.

Experience

2-5 Years

Level

Junior

Education

Master's

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

Experience

2-5 Years

Level

Junior

Education

Associates

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

Experience

10+ Years

Level

Senior

Education

BS

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

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.

Experience

7-10 Years

Level

Management

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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

Experience

5-7 Years

Level

Executive

Education

Bachelors

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.

Experience

10+ Years

Level

Senior

Education

Bachelors

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.

Experience

7-10 Years

Level

Consultant

Education

Master's