Quality Assurance Dw&bi Integration Test Engineer Resume
Houston, TX
SUMMARY
- Offering 7+ years of experience in Software testing with outstanding Planning, execution, monitoring and resource balancing skills/Evaluation with ability to support multiple simultaneous projects parallel.
- Implemented several Innovative activities & introduced several Best Practices.
- Gained high satisfaction & Awards by Managers & Clients.
- Extensive experience in ETL/Data Warehouse Testing with solid SQL.
- Experience in Hadoop / Big Data Testing using Hive and Python Scripts.
- Experience in Database Testing with a primary focus on the ETL and Reports testing in Health Care, Retail, Hospitality and in Data Warehousing applications
- Very good experience in testing reports on OBIEE
- Good Knowledge on Cognos, MSBI SSIS and SSRS Reports Testing.
- Hands on Testing experience in SAP BO X - Celsius Dashboards.
- Well expertise in Automating the Validations using Shell and Python Scripts.
- Experience in using the Informatica Automation Tool DVO to validate Source and Target Data.
- Proficiency in providing Metrics to management, Defect management including Defect tracking, prioritizing and reporting using Quality Center, JIRA, Rational Clear Quest, Test Director, and manually using excellent detailed formats in Microsoft Excel
- Expertise in preparing Testing related documentations like Requirement Traceability Matrix, Test Execution Report and Test Summary Report.
- Experience in analyzing Source Systems, Staging area, Fact and Dimension tables in Target Data warehouse. Hands on experience inStar schema/Snowflake schema.
- Good understating of various phases of SDLC and involved in complete Test Lifecycle.
- Versatile with Agile-model, Water-fall model and Iterative model.
- Very good exposure on Health Care, Retail, Insurance and Hospitality domain
- Solid experience on ALM (Quality Center) end-to-end process.
- Experience in UNIX Commands required for ETL Testing.
- Good knowledge in Automation Tool QTP.
- Good knowledge in PIG Scripting
TECHNICAL SKILLS
Technologies: ETL testing, Database testing, Report Testing
Functional Areas: Manual & Automation
Databases: Hadoop CDH 5.1.0, Hive, Avro, ORACLE 11g. SQL Server 2008
Business Intelligence Tools: Cognos, MSBI, OBIEE
Scripting Languages: SQL, Python, Shell
Languages: C#, ASP.NET
Operating System: Windows 2003 server for Embedded Systems, XP, 2007, 8.1
Automation Tools: QTP, DVO
Test Management Tools: HP QC/ ALM, IBM Rational Clear Quest, JIRA
Software Engineering Methodologies/Tools: Agile Model, V-Model, Waterfall Model, PuTTY, TOAD, MS-Office
ETL Tools: Informatica, DataStage and Autosys
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Quality Assurance DW&BI Integration Test Engineer
Environment: Data Warehouse, Oracle 11gR2, ETL tool Informatica 9.1.0, DVO, Business Objects reporting tool CRRT, Autosys, Apache tomcat 6.0.37, TOAD 11.6.1.6, Unix, shell scripts, Putty, WinSCP, HP ALM, JIRA, SQL, Hadoop CDH 5.1.0, Apache Hive, Microsoft Office.
Responsibilities:
- Review Business/Functional specifications & design document to ensure full understanding of technical deliverables and provide feedback.
- Attending LLD, HLD, STM and Code review meetings
- Identify & document test requirements from specifications & design documents, map test case requirements and design test coverage plan in test strategy document.
- Develop, document and maintain functional, technical & business test cases in HP Quality Center.
- Conduct and facilitate test plan/case reviews with required stakeholders.
- Preparing the Validation Queries and implementing the Jobs in the Automation Tool DVO.
- Validating the Source and Target using DVO Tool
- Preparing Hive, Shell & Python Scripts to validate the data in Hadoop
- Testing Data Warehouse applications developed in ETL & BO tools and Oracle on Unix/Linux servers.
- Execute and evaluate manual or automated test cases and report test results.
- Analyze test results, identify discrepancies and clearly document and report defects.
- Timely escalation of Issues affecting testing & project timelines.
- Participate in project related meetings.
- Ensure Issue tracking process is followed & enforced.
- Ensure QA & Control & Compliance processes are followed and enforced.
Confidential, Atlanta, Georgia
ETL Test Engineer
Environment: Oracle 11g, Informatica, DVO, DAC, PL/SQL Developer, Autosys, Putty
Responsibilities:
- Review Business/Functional specifications & design document to ensure full understanding of technical deliverables
- Analyzing the Requirements / Mapping Documents and write Test Cases
- Applying different Testing Techniques Boundary Value Analysis, Equivalence Partitioning & Cause Effect Analysis
- Exporting and running test cases in HP ALM.
- Preparing the Validation Queries and implementing the Jobs in the Automation Tool DVO and running the Jobs to validate the Data
- Writing and executing SQL Queries in PL/SQL Developer under Client’s remote desktop SIT environment
- Data quality checking and interacting with the Development team and business analysts
- Raised defects with exact re-creation steps and reported them to developer to fix the bugs through HP QC
- Modified the test cases according to the change request.
- Responsible for verification, Validation of closure of bugs -- Defect Tracking.
- Analyzed test results and prepared a summary report.
Confidential, Akron, Ohio
ETL/BI Test Engineer
Environment: Oracle 10g/11g, Informatica, DVO, DAC, PL/SQL Developer, Autosys, Putty
Responsibilities:
- Review Business/Functional specifications & design document to ensure full understanding of technical deliverables
- Designing test cases for System Integration Testing of Full loads and Incremental Loads
- Exporting and running test cases in HP ALM.
- Preparing the Validation Queries and implementing the Jobs in the Automation Tool DVO and running the Jobs to validate the Data
- Writing and executing SQL Queries in PL/SQL Developer under Client’s remote desktop SIT environment
- Data quality checking and interacting with the Development team and business analysts
- Raised defects with exact re-creation steps and reported them to developer to fix the bugs through HP QC
- Modified the test cases according to the change request.
- Responsible for verification, Validation of closure of bugs -- Defect Tracking.
- Analyzed test results and prepared a summary report.
Confidential
Test Engineer
Environment: Oracle 10g/11g, Informatica, DAC, PL/SQL Developer, OBIEE, Oracle BI Publisher, Autosys, Putty
Responsibilities:
- Designing test cases for E2E System Integration Testing
- Exporting and running test cases in HP QC
- Writing and executing SQL Queries in PL/SQL Developer under Client’s remote desktop SIT environment
- Generating reports in OBIEE and Oracle BI Publisher and comparing the results with database
- Data quality checking and interacting with the Development team and business analysts
- Raised defects with exact re-creation steps and reported them to developer to fix the bugs through HP QC
- Modified the test cases according to the change request.
- Responsible for verification, Validation of closure of bugs -- Defect Tracking.
- Analyzed test results and prepared a summary report.
Confidential
BI Test Engineer
Environment: Oracle 10g/11g, Informatica, DAC, PL/SQL Developer, OBIEE, Autosys, Putty
Responsibilities:
- Designing test cases for System Integration Testing of Full loads and Incremental Loads
- Exporting and running test cases in HP QC
- Writing and executing SQL Queries in PL/SQL Developer under Client’s remote desktop SIT environment
- Generating reports in OBIEE and comparing the results with database
- Data quality checking and interacting with the Development team and business analysts
- Raised defects with exact re-creation steps and reported them to developer to fix the bugs through HP QC
- Modified the test cases according to the change request.
- Responsible for verification, Validation of closure of bugs -- Defect Tracking.
- Analyzed test results and prepared a summary report.
Confidential, Austin, Texas
ETL / DWH Tester
Environment: SAP BO X-Celsius, SQL Server 2008, and SQL Server Business Intelligence Development Studio
Responsibilities:
- Preparation of Test Scenarios, Test Cases and Test Reports
- Performed Manual Testing and Created test cases including Functional test cases, Acceptance test cases and Regression Test cases.
- Wrote simple to complex SQL queries to verify the database tables and as well as verifying the data in X-Celsius Dashboards and SSRS Reports generated.
- Data quality checking and interacting with the Development team and business analysts
- Verification and analysis of the Graphs, lookups, reusable components in Dashboard as per the design documents/communication
- Raised defects with exact re-creation steps and reported them to developer to fix the bugs.
- Modified the test cases according to the change request.
- Verified test checklist for various tests and maintains the test documents.
- Responsible for verification, Validation of closure of bugs -- Defect Tracking.
- Analyzed test results and prepared a summary report.
- Provided guidance and support to the documentation team to provide quality documents
- Preparing daily and weekly status report
- Handling the data migration and solving the issues of migration.
Confidential
Manual Tester
Environment: Java, SQL Server
Responsibilities:
- Build receiving and deployment on test server
- Performing sanity test
- Creating test plans and schedules
- Preparing test cases based on enhancements and testing Scope
- Reviewing of test cases.
- Test case execution, tracking defects and analyzing reports.
- Bug Re-producing and verifying fixed bugs.
- Posting new bugs with detail scenarios.
- Communication with the end users.