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