ETL Tester Resume Sample
Work Experience
- Test execution and 25% planning and test coordination.
- Extensive Knowledge on Authoring MS SQL queries Joining tables
- Develop functional and integration test scripts
- Perform functional and integration acceptance testing
- Document functional and integration acceptance test evidence
- Assist the clients during the User Acceptance Testing (UAT)
- Complete status reports on each phase of the work
- Participate in team meetings to provide a status report of work in progress, accomplished and problems / issues encountered
- Experience in functional and integration test scripts
- Experience in documenting functional and integration acceptance test evidence
- Assisted the clients during the User Acceptance Testing (UAT)
- Develop, implement and maintain quality and test procedures, processes and best practices for QA
- Develop and maintain test plan and test cases with associated test data based upon functional and non-functional requirements
- Identify test automation opportunities to improve efficiency and effectiveness of test services
- Contribute to test automation scripting standards and best practices
- Firm understanding of data architecture and ETL workflows
- Write SQL scripts to extract data from various databases and systems and compare against data warehouse
- Elicit & understand ETL testing requirements
- Conduct tests, document and analyze test results and present findings to development teams
- Report and document defects found during test cycles. Participate in defect prioritization sessions
- Communicate timely status, including any potential risks/issues to the appropriate teams to ensure completion of all deliverables within schedule, budget and quality constraints
- Be proficient in writing SQL independently, including complex joins (without the help of a developer)
- Experience in root cause analysis and defect diagnosis techniques
- Tools experience: SQL Developer, TOAD, Informatica DVO, JIRA, Mainframes (MVS, CICS, JCL, DB2)
- Create and execute end-to-end test plans for our Enterprise Data Warehouse and associated ETLs
Education
Professional Skills
- Strong in SQL and PL/SQL. #Strong background working with large data sets in Data Warehousing and Business Intelligence environment
- Testing experience in Data Migration projects and executing and verifying ETL jobs (DataStage)
- Testing and validating results of new or updated data operations/processes
- Strong Career Planning and Coaching Program
- Experience with implementing ETL test automation using selenium or informatica DVO
- Strong background working with large data sets in Data Warehousing and Business Intelligence environment
- Experience in working testing through Informatica, Oracle 11g, Informatica 360T MDM and Data quality projects
How to write ETL Tester Resume
ETL Tester role is responsible for database, automation, sql, software, training, integration, java, architecture, analysis, reporting.
To write great resume for etl tester job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For ETL Tester Resume
The section contact information is important in your etl tester resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your ETL Tester Resume
The section work experience is an essential part of your etl tester resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous etl tester responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular etl tester position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative ETL Tester resume experience can include:
- Verifying data transformations according to business rules
- Helping other teams investigate failures in their tests that rely on ETL services
- Working knowledge of SQL Server Integration Services
- Leading on-shore and off-shore vendor resources
- Database testing (ETL, SQL, data mining, data profiling)
- Test Design, Test Execution and Defect Reporting & Tracking
Education on an ETL Tester Resume
Make sure to make education a priority on your etl tester resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your etl tester experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in ETL Tester Resume
When listing skills on your etl tester resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical etl tester skills:
- Good experience in customer management
- Good understanding on test methodology
- Experience writing test plans and test cases
- Experience in data warehouse (ETL) testing
- Overall 8+ years of experience in Data Warehouse (ETL) Testing
- Good knowledge in requirement study/ambiguity review
List of Typical Skills For an ETL Tester Resume
Skills For Senior Data & ETL Tester Resume
- Good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture, tools and testing
- Personal Time Off (PTO) - Ensuring a balance of work and home life
- Read data mapping documents
- BIG DATA testing knowledge
- ETL Testing
- 401(k) Savings Plan - Matched 150% up to 6%
- Medical/Prescription/Dental/Vision Coverage - Employees pay no premiums!
Skills For QA ETL Tester Resume
- Company-paid mobile phone plan
- $12,000 annually in Tuition Reimbursement
- Perform Test design and execution activities
- Experience in working with large scale Enterprise Data Warehouse, Data Integration, Data Migration and upgrade projects. #Strong Data ware house and BI concepts
- Property & Casualty Insurance industry experience
- Strong database experience in Oracle, SQL Server, IBM DB2 and Teradata, extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database
- Have solid knowledge of testing process, procedure, and best practices along with a demonstrated ability to perform and analyze results of planned upgrades and changes in multiple complex Enterprise Data Warehouse environments
Skills For ETL Tester Resume
- Be familiar with automated testing of EDW solutions and ETLs
- Expert level in-depth SQL querying knowledge
- Understand the requirements, traceability matrix and test matrix
- Create test cases for ETL script, metadata configuration, transformation rules, source to target mapping verification based on requirements and establish traceability
- Execute test cases and report results including defect reporting and triaging
- Maintain test documentation via Test Execution and Test Summary reports