An ETL Tester will be responsible for validating the data sources, data extraction, applying transformation logic and loading data in the target tables. A professional ETL Tester Resume mentions the following key responsibilities – verifying the tables in the source system, conducting data threshold validation check; loading data from the staging area to the target systems; ensuring if aggregate values and calculated measures are loaded in the fact tables; testing the ETL tools; checking view created based on the target table, and checking reports based on loaded fact and dimension table.
Key qualifications that can highlight a resume include the following – proficiency in using testing tools, knowledge of various databases including Oracle and SQL; skillful in MS Office, a solid understanding of various programming languages and extensive testing ETL experience using Informatica. An advanced computer science degree is expected for this role.
Objective : Having 7+years of experience on Manual and Automated Software Testing. The software testing experience includes ETL testing on Informatica, Data Stage tool and web based testing on PeopleSoft CRM system with functional knowledge of CRM. Good understanding of SDLC methodologies and worked elaborately on all phases of STLC.
Skills : Informatica 8.6.1, 9.0.1, Data Stage 7.5, 8.1
Description :
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.
Experienced using query tools for Oracle, Teradata, Redbrick and MS SQL Server to validate reports and troubleshoot data quality issues.
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.
Experienced in Automation testing using QTP.
Developed and maintained test cases for ETL processes, improving test coverage by 30%.
Collaborated with data engineers to identify and resolve data quality issues, reducing defects by 25%.
Executed ETL testing processes, ensuring 99% data accuracy across multiple data sources.
Experience
2-5 Years
Level
Junior
Education
B.Sc. CS
Jr. ETL Tester Resume
Objective : Results-driven Jr. ETL Tester skilled in executing test cases and analyzing ETL processes. Successfully improved data accuracy by 30% through rigorous testing and collaboration with development teams.
Lead Sears Holdings Corporation is the nation's fourth-largest broad line retailer with approximately 3,900 full-line and specialty retail stores.
Enabled for quickly supplement our existing catalog with products from large retailers.
Involved in identifying the defects and developed defect tracking reports using hp quality centre, which involved the bug life cycle.
Reached testing goals by doing data completeness, data transformation, data quality, performance and scalability performed with system testing, functional testing, regression testing.
Tested and validated the report net reports by running similar SQL queries against the source system(s).
Developed and maintained test cases for ETL processes, achieving a 95% test coverage rate.
Performed regression testing on ETL workflows, reducing defect leakage to production by 25%.
Experience
2-5 Years
Level
Junior
Education
B.Sc. CS
Sr. ETL Tester Resume
Summary : Over 5+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence. Extensive ETL Testing experience. Package Software: Expertise in Informatica ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
Skills : Unix, Teradata SQL, Quality Center, Ab-intio, Wherescape Red
Description :
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.
Performs performance testing on the entire module of AirCore (every 10 builds once) Analyzing and translating business and functional specifications into testing requirements.
Performs manual testing on different modules of the application.
Prepares the Test Cases, Review of Test cases, Test Scripts, Test Documentation Actively participated in Build Verifications Testing (smoke test).
Designed and executed ETL test cases, improving data accuracy by 30% across multiple projects.
Collaborated with data engineers to optimize ETL processes, reducing data load times by 25%.
Developed automated testing scripts, increasing testing efficiency and reducing manual effort by 40%.
Experience
10+ Years
Level
Senior
Education
M.S. CS
ETL Tester I Resume
Objective : 7+ years of 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 using Cursors, Functions, Joins for all databases including Oracle, SQL Server, DB2 and Teradata.
Written Test Cases for ETL to compare Source and Target database systems.
Prevented occurrences of multiple runs by flagging processed dates.
Personalized Cognos Connection for specified display options for testing regional options and personal information.
Developed data quality test plans and manually executed ETL and BI test cases.
Used various types of transformations such as Expression, Joiner, Update Strategy, Lookup, filter for developing mappings.
Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools.
Experience
2-5 Years
Level
Junior
Education
BSc CS
ETL Tester II Resume
Headline : Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications. Solid Back End Testing experience by writing and executing SQL Queries. Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software.
Skills : Testing, SQL Server, Coding, Test Automation
Description :
Involved in understanding the Logical and Physical Data model using Erwin Tool.
Prepared Execution procedure document format to prepare the Test cases based on a mapping document.
Lead team of 6 people offshore and 2 onsite.
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.
Validated XML Documents before sending the Message Bus.
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.
Written several complex SQL queries for validating Cognos Reports.
Experience
5-7 Years
Level
Executive
Education
B.Sc. CS
ETL Tester III Resume
Summary : A Seasoned ETL Tester consultant with 6+ years of experience in Investment Banking and Financial Services, Clearing and trading domains. Experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server, and Informatics Power Center, Power art (Repository Manager, Server manager, and Mapping Designer, Mapplet Designer, Transformation Developer and Warehouse designer).
Skills : MS Office, SQL, Testing, Test Case Design
Description :
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.
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.
Tested and Analyzed ICD 9 and 10 codes.
Identify & record defects with the required information for the issue to be reproduced by the development team.
Scheduled jobs using Tidal Tool Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
Tested the claims processing with EDI transactions (270, 834, 835, 837) in HIPAA and HL7 Environment.
Experience
7-10 Years
Level
Management
Education
M.S.
Asst. ETL Tester Resume
Objective : 7+ years of IT experience as an ETL Tester in Banking and Healthcare Domain. Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments. Expertise in Software Quality Assurance Testing specialized in ETL, Business Intelligence and Data Testing and Solid Back End Testing experience by writing and executing SQL Queries.
Skills : Management, SQL Server, Testing, Data Governance, Metadata Management
Description :
Worked on projects of moderate to high complexity that requires in-depth knowledge across multiple technical areas and business segments.
Performed detailed software Business requirements and technical design reviews to assure comprehensiveness and consistency.
Analyzed Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
Provided high-level and detailed QA testing resource estimates to the QA Manager and Project Managers in a timely manner.
Translated Business requirements and technical design into comprehensive test plans and test cases assuring maximum requirements coverage.
Developed SQL queries for back-end testing/database testing and participated in end-to-end testing.
Validated the source system data with the staging data using SQL and SQL scripts.
Experience
2-5 Years
Level
Junior
Education
BSc CS
ETL Tester Resume
Headline : Experienced Quality Assurance Analyst (ETL) with 7+ years of experience in the Information Technology industry, involving analysis, both Manual and Automated testing of Client Server, ETL, OLAP and Web applications. Worked on various Domains like E-Commerce, Supply Chain and Possess specific experience in the Banking, and Finance.
Skills : MS Office, Management, Continuous Integration, Data Lineage, API Testing
Description :
Created to promote and support the common business interests of the Commercial and Residential Mortgage markets.
Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
Created Test Cases and developed Tractability Matrix and Test Coverage reports.
Managed and conducted System testing, Integration testing, and Functional testing.
Worked on SQL scripts to load data in the tables.
Extensively worked with DS (Designer, Director, and Manager).
Experience
5-7 Years
Level
Executive
Education
B.Sc. CS
Lead ETL Tester Resume
Summary : 5 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Client-Server and Legacy Mainframe applications and Data Warehousing. Worked with IT Operations to ensure test environment readiness. Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
Skills : MS Office, Management, SQL Server, Data Warehousing, SQL Querying
Description :
Prepared Test Plan from the Business Requirements and Functional Specification.
Experienced with onsite-offshore Co-ordination.
Tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
Created resource forecast, ramp-up plans, & resource utilization plans.
Worked will include a loading of historical data onto the Teradata platform, as well as reference data and metadata.
Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
Tested Business Objects reports and Web Intelligence reports.
Experience
10+ Years
Level
Senior
Education
B.S. in CS
ETL Tester Resume
Summary : 8+ years of ETL/QA/DWH 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. Very good knowledge of data ware house systems and ETL systems.
Skills : Test Director, Quality Center, Data Profiling, Test Automation, Performance Testing
Description :
Participated the sessions for requirements review and Analyzed business requirements, data mapping requirement specifications along with the team.
Worked on Functional and GUI testing of the web application making sure the application looks and functions as per requirements.
Created Test Plans which included test deliverables, features to be tested/not tested, Pass and Fail criteria of a test and so on.
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.
Involved in Creating The Business Assurance Strategy Document and Test Strategy Document.
Conducted review sessions for the Test cases with the BSA's and Developers.
Conducted performance testing on ETL jobs, optimizing execution time by 20% through tuning.
Creating an account is free and takes five seconds.
You'll get access to the PDF version of this resume template.
Choose an option.
Sign up with Google
Sign up with Facebook
Sign up with Linkedin
This helps us make sure you're human and prevents spammers from abusing our services.
By continuing, you agree to our Privacy Policy and Terms.
Unlock the Power of Over 10,000 Resume Samples.
Take your job search to the next level with our extensive collection of 10,000+ resume samples. Find inspiration for your own resume and gain a competitive edge in your job search.
Get Hired Faster with Resume Assistant.
Make your resume shine with our Resume Assistant. You'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want.
Get Noticed with Resume Templates that Beat the ATS.
Get past the resume screeners with ease using our optimized templates. Our professional designs are tailored to beat the ATS and help you land your dream job.
