Senior ETL QA Tester Resume Samples

As a Senior ETL QA Tester, the profession takes responsibility for validating the data sources, extracting data, applying transformation logic, and loading data into the target tables. The key responsibilities associated to this role are listed on the Senior ETL QA Tester Resume as – verifying the tables in the source system, applying transformation logic, taking accountability for data loading; testing the ETL tools; creating, designing and executing the test plans and test cases; and testing the ETL data warehouse systems.

Apart from proven work experience, the following skills and abilities are expected from those applying for this role – proficiency with HP tools – ALM, ATP, and Quality Center; progressing skills on business analysis, business knowledge, software engineering, architecture knowledge, and technical solution design; ETL and SQL scripting expertise; and a strong background in both Agile and waterfall methodologies. A Computer science degree is a minimum requirement, however, the seniority level of the post demands a relevant professional certification and immense work experience as well.

Senior ETL QA Tester Resume example

Senior Etl Qa Tester Resume

Headline : Over 8 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client-Server Systems and Applications for Banking, Insurance, Financial, and Retail Industries. Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) .

Skills : ETL Tools such as Informatica or Pentaho. PL/SQL Oracle development experience.

Description :

    1. Involved in Business analysis and requirements gathering.
    2. Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
    3. Used Quality Centre for tracking the defects.
    4. Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI's.
    5. Tested ad hoc and canned reports for Business objects.
    6. Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
    7. 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.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors


Senior Etl Qa Tester III Resume

Summary : Over 8 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client-Server Systems and Applications for Banking, Insurance, Financial, and Retail Industries. Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) .

Skills : Hands-on experience with NoSQL databases, Experience pulling data from a variety of data source types.

Description :

    1. Validated the data in the reports by writing simple to complex SQL queries in the transactional system Executed the Test cases for Cognos Reports.
    2. Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
    3. Oversaw the historical loads in UAT and PROD environments.
    4. Worked on Integration of all the processes in UAT/PROD.
    5. Optimized/Tuned several complex SQL queries for better performance and efficiency.
    6. Involved in Implementing Agile (Scrum) methodologies for the complex project modules.
    7. Tested and worked on creating open document reports for business.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors


Senior Etl Qa Tester II Resume

Objective : Over 9.8 years of Software Quality Assurance (QA) experience which includes testing Data Warehouse Applications, Database (ETL & BI), Web and Applications for Banking, Financial, E-Commerce and Retail Industries. Setup of Data Profiling using PL/SQL, Hadoop QA using Hive, ETL QA, MSTR Dashboards QA, OBIEE Dashboards QA, Business Objects Dashboards QA and Qlikview Dashboards QA.

Skills : Experience pulling data from a variety of data source types, Dimensional modeling experience and parameterization.

Description :

  • Developed SQL based test script to perform Database and ETL Testing
  • Validated data quality across platform and document/report any anomalies
  • Identified opportunity to automate and define automation scope with ROI.
  • Automated scoped items by using inhouse automation framework.
  • Worked independently & play a liaison role b/w Functional QA, Development & DBA teams.
  • Tested- Functional, Database, ETL, Bigdata and Automation Testing.
  • Analyzed the business requirements to create test plan and test scenarios for SOA applications.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors In Computer Science Technology

Senior Etl Qa Tester I Resume

Objective : Bachelor's degree in Computer Science or a related IT field or equivalent experience A minimum of 4 years of experience supporting Testing/Software QA requirements, Ability to understand requirements and interpret into Test Cases, Basic SQL in Oracle or Microsoft Service testing on Oracle SOA ESB and Windows.

Skills : ETL Tools such as Informatica or Pentaho, PL/SQL Oracle development experience.

Description :

  • Provided technical test engineering expertise
  • Performed, planed, and supported tasks related to operational test and evaluation requirements
  • Wrote and executed test scripts, test cases and test scenarios
  • Analyzed and provided technical inputs and report for management on applicable program/application/service test requirements
  • Documented defects and provide reporting to management personnel for the purposes of recycling and correction of software/documentation
  • Supported requirements development
  • Provided operations and maintenance support to ensure continuous reliability and availability of applications.
  • Supported end-user training and related customer needs.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bs

Assistant Senior Etl Qa Tester Resume

Objective : Hands-on experience with Data transformation/ manipulation testing (SQL scripting), Working Knowledge of data quality/ completeness validation (SQL scripting), Experience in running the scheduler (Mainframe ESP), Firm grasp on testing technics (ie: black box testing, white box testing).

Skills : Knowledge on Testing, Dimensional modeling experience and parameterization.

Description :

  • Lead the collection, analyzing and testing of data for our data warehouse.
  • Experienced with both traditional and big data streaming
  • Created and maintained complex SQL queries such as; type 2 triggers, various joins, aggregations, groupings and more.
  • Executed ETL jobs using orchestration tools (airflow/scheduler/SQL agent).
  • Strategized and implemented data test automation and recommended testing improvements through QA best practices, supporting other testers and sharing knowledge of test tools.
  • Effectively communicated test plans, test reports, and test metrics to Senior Leadership.
  • Engaged with vendor partners in development, release management, and operations for test management and execution.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
BS

Associate Senior Etl Qa Tester Resume

Objective : Senior Test Engineer will build, automate and execute test suites to ensure the data transformation, data quality rules and features of the data products built by the Enterprise Datawarehouse and Data Platform team work as expected. The candidate must have an in-depth data testing and software quality assurance knowledge and must provide Testing thought leadership across the IT organization. This associate will lead the day-to-day activities on their assigned teams, comprised of FTE and contractor testing resources.

Skills : SQL Skills, ETL Tools such as Informatica or Pentaho.

Description :

  • Experienced in root cause analysis and defect diagnosis techniques.
  • Ability to document software defects, conduct defect triage meetings and report defects to project stakeholders.
  • Experienced with utilization of appropriate test methodologies and use of test management tool like JIRA, HP ALM
  • Ability to operate comfortably in a multi-task / multi priority environment across a global team.
  • Experienced working with SaaS solutions, including data interfaces is a plus.
  • Ability to understand requirements and changes to requirements
  • Experienced in automated test case management tools such as HP ALM would be a plus. 
     
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
BS

Assistant Senior Etl Qa Tester I Resume

Objective : Over 8+ years of experience in ETL Testing (Both SQL and Teradata, Redshift), Strong SQL knowledge with hands-on experience in Relational databases such as Oracle and Redshift, Experience with automation - Python Robot framework.

Skills : Oral development experiance, Knowledge on testing.

Description :

  • Tested vendor base solutions for the implementation effort
  • Tested within assigned areas of responsibility (e.g. data conversion, configuration testing, external and internal integration testing, data creation, functional/system testing, security testing, execution, etc.)
  • Worked all phases in software development life cycle with experience in different methodologies (i.e. agile, iterative, waterfall, etc.) with emphasis on agile
  • Evaluated testing results against predetermined objectives.
  • Applied recommended actions for improvements, creating test data, test estimates, performance testing, coordinating, and conducting readiness meetings.
  • Developed, published, and executed test cases and test scripts for complex, distributed applications throughout the project life cycle.
  • Created, executed, and automated SOAP UI scripts for Web Services testing.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
BS

Associate Senior Etl Qa Tester I Resume

Objective : Over 8+ years of QA Analysis Experience, including Test strategy and Test design, Test case execution & reporting, 8+ years of automated data testing background using scripts, preferably Python, 8+ years of experience in development of data intensive ETL based test scripts based on technical specifications/Data design documents and Source to Target mapping.

Skills : Experiance on SQL , Effective Communication Skills.

Description :

  • Created, managed, and maintained efficiencies in the automated script execution and script development using Selenium web driver in addition to keeping abreast of automation best practices
  • Created, executed, and automated SOAP UI scripts for Web Services testing.
  • Developed test plans and user acceptance tests and developing test data as needed.
  • Executed sanity, smoke, functional, security, regression, stress/performance, and load testing based on projects, applications, and services.
  • Participated in production implementation verification.
  • Worked with minimal assistance with a can-do attitude.
  • Created test data to meet testing needs
  • Established processes for collecting data, data entry, and prioritizing defects reports for defect tracking tools, etc.
  • Created traceability matrix of test cases to requirements; and work with cross functional teams.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor's

Senior Etl Qa Tester/Engineer Resume

Objective : Bachelor's degree in computer science, mathematics, or a related field, and three (3) years of experience in an appropriate field of electronic data processing or an equivalent combination of education and experience, Management requires applicants with: Seven (7) or more years of experience testing web applications and web services

Skills : Knowledge on testing, Experiance on Pulling Data.

Description :

  • Experienced testing and created automated test suites.
  • Experienced working with cross functional teams that included development, QA, documentation and product management.
  • Supported end-user training and related customer needs
  • Supported creation and maintenance of test automation
  • Provided oversight and guidance to other Testers and technical members of the team to ensure success technical performance and delivery of services.
  • Validated data quality across platform and document/report any anomalies
  • Identified opportunity to automate and define automation scope with ROI.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
BS

Senior Etl Qa Tester Resume

Objective : An expert in writing and executing test cases, managing and analyzing large sets of data, creating automation scripts and communicating relevant insights to the team, Collaborate with other data professionals, engineers, and business operation experts to understand and address reporting needs.

Skills : Knowledge on QA Testing, Experiance With No-SQL database.

Description :

  • Worked with minimal assistance with a can-do attitude
  • Understood the technical details of projects, applications, and systems.
  • Wrote test cases and execute testing within a web service environment.
  • Created test data to meet testing needs.
  • Established processes for collecting data, data entry, and prioritizing defects reports for defect tracking tools, etc.
  • Created traceability matrix of test cases to requirements.
  • Worked with cross functional teams.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
BS