We provide IT Staff Augmentation Services!

Data Warehouse Qa Engineer Resume

5.00/5 (Submit Your Rating)

Springfield, MA

SUMMARY

  • Dynamic and skilled data warehouse testing professional with diverse knowledge of system testing processes and methodologies.
  • Seeking a challenging position as a data warehouse tester in an organization that offers opportunities to grow professionally.
  • Proficient in End - to-End QA management and Environment Management activities
  • Experience in testing natures like Database using SQL Script, GUI, Smoke, Functional/Non-Functional, Regression, Integration, Ad-Hoc and System testing which includes basic level of automation testing.
  • Good experience in Waterfall & Agile methodologies (SCRUM).
  • Excelled in creation of Test ware (Test strategy Approach, Test Plan, Test Case, Test Scripts and Test Summary Report)
  • Having experience in Data warehouse, Data Migration Testing & ETL Testing
  • Experience of Data warehousing, ETL in Informatica/SSIS to perform Source to Target testing.
  • Well versed in data warehouse architecture, data modeling, and ETL process
  • Comprehensive knowledge of data warehouse design methodologies and industry standards
  • Extensive experience in writing SQL queries for all kinds of data validation between source and target tables.
  • Experience in planning and estimation the tasks for user Stories/Requirement.
  • Experience on reporting and tracking defects using Atlassian Jira.
  • Expertise in maintaining Requirement Traceability Matrices (RTM).
  • Proficient in Teradata, Oracle, Microsoft SQL Server & Flat Files.
  • Strong analytical, problem solving & organizational abilities. Possess a positive, flexible & detail-oriented attitude, strive to be my best.
  • Strong knowledge in SQL queries
  • Sound knowledge in Software Development Life Cycle and Software Testing Life Cycle.
  • Ability to communicate effectively with excellent management and organizational skills

PROFESSIONAL EXPERIENCE

Confidential, Springfield, MA

Data Warehouse QA Engineer

Responsibilities:

  • Involved in Agile Daily Scrum Meeting, Sprint review & Retrospective & Planning call with Clients to get the Knowledge & Progress of the product.
  • Estimation of story points, progress tracking etc. in Version One to ensure deliverables are on track
  • Utilized Agile-Scrum methodology to perform the QA Activities like verification and validation during the sprints of the project.
  • Performed Functional, System, DB, Regression and Back-end testing in scrum based user story releases.
  • Responsible for creating Test cases, Writing SQL Queries for ETL testing (Target: Teradata database. Source: Policy Admin System Files/Databases).
  • Design/Analyze/Develop/Update/Review Test Plan, Test strategy and Test Summary reports.
  • Ensured adherence to QA process best practices including defect management, test case execution and metrics reporting.
  • Worked closely with Project Managers and Development team to resolve spec(s) related issues.
  • Reviewed the Functional and Design specification.
  • Participate in the identification and implementation of continuous improvement opportunities in QA processes and procedures.
  • Collaborated with Dev team to provide the required scenarios to avoid More no of QA Defects.
  • Reviewed the Deployment instruction for our Production release plan.
  • Participated in production check-out testing for all prod deployments.

Environment: Teradata, Informatica, Mercury Quality Center 9.0, MS Access, Jira, Confluence

We'd love your feedback!