An ETL tester is responsible for validating the data sources by applying transformation logic and loading data in target tables. The professional is required to test both the tools and test cases. The job duties and responsibilities of an ETL tester includes verifying tables in the source system, reconciling records with the source data, understanding logical flow of the application, analysis of specification provided by the clients, participating reviews of design, document and models, approving requirement and designing specification and technical documents to target mapping documents and other related documents, creating and maintaining test strategy document for ETL tasks, designing test cases as per test plan, estimating the time required to design the test cases, defining various criteria for code and data migration into the test and production environment, maintaining and executing re-usable script, playing a key role in the automation of SQL queries while preparing test case scripts and identifying bugs, issues, and problems. The ETL tester must have enough experience in the similar field. They must have knowledge about writing data scripts, executing the scripts and creating strategies for an application that uses the ETL component.
ETL Tester Resume
Name: Anika Robel
Address: 1797 Walnut Street, Jackson, MS 39201
Phone: 505 – 331-7476
Email: [email protected]
Current Job: ETL Tester, Primesoft Inc., Jackson, MS
Objective:
An experienced ETL tester having extensive knowledge in data models identification and testing schemes. Awareness about transformation rules verification process and data sample comparisons. High analytical and detail-oriented ETL tester with a great understanding of data models and excels at the transformation.
Skills:
- Have strong time management and organization skill
- Great understanding of ETL testing principles and concepts
- Proficient with DataStage and Informatica
- Wide knowledge of data warehouse principles and procedures
- Able to test web-based and mainframe application
- Able to validate the completeness and accuracy of data
Work Experience
ETL Tester, Primesoft Inc., Jackson, MS ( 2016 – present )
Duties and Responsibilities:
- Collaborated with developers and prepared and implemented a test plan
- Evaluated the requirements of business and developed test plan according to the needs
- Documented and reviewed test cases and procedures with senior management
- Organized all results and implemented QA test scripts
ETL Tester, Sheffield Industries Inc., Jackson, MS (2014 – 2016 )
Duties and Responsibilities:
- Identified data streams and reviewed data models for testing strategies
- Conducted various sources to target data mapping
- Identified defects in data prior to data processing
- Collaborated with back end and database testers
ETL Tester, Mega Corp Inc., Jackson, MS (2012 – 2014 )
Duties and Responsibilities:
- Conducted package testing and scheme testing
- Verified data completeness and transformation rules
- Processed data for testing and analytics after mitigation of data errors
- Performed various functions prior to conducting testing such as data analysis and mapping
- Performed quality assurance tests and data warehousing and ETL projects
- Coordinated with managers and developed automated solutions
Education:
Bachelor Degree in Computer Science – Trine University, Angola, IN
High School: Rolling Hills High School, Jackson, MS
Reference:
Robert Johnston, ETL Tester, Sheffield Industries Inc., Jackson, MS
Personal Information:
- Civil Status: Married
- Date of Birth: 20/8/1996
- Hobbies: Playing volleyball and gardening
