Sr. Etl Tester Resume
Billings, MT
SUMMARY:
- IT professional with over 6+ years of experience as a ETL Tester & Software Quality Analyst with experience in Healthcare, Banking and Retail domain
- Proficient in performing ETL, BI, backend manual testing.
- Adept in writing SQL scripts required for testing various ETL and backend processes
- Worked with Initial and Incremental load testing within ETL Testing.
- Worked on UNIX platform heavily
- Worked in all phases of STLC and can prepare all kinds of documents and reports
- Thorough Knowledge in Web Services testing using SOAP UI
- Experience in working Agile Scrum environment
- Experience in understanding the business & technology of the client system AND providing them with quality deliverables
- Profound knowledge of Agile/ Waterfall Software Development Life Cycle and Software Testing Life Cycle
- Experience in analyzing Business Requirement Documents, Functional Requirement Documents and Technical Specification Documents
- Creation of Test Plans, Test Cases and Test Scripts based on Requirements and Specifications
- Expertise in QA project scoping, estimation, Defect tracking and reporting skills
- Worked in manual testing with an edge in end to end manual testing
- Familiar in using different defect tracking tools such as JIRA & HP Quality Center /ALM
- Experience in validating source d Confidential coming from various d Confidential base using SQL queries
- Experienced in Black Box, Integration, Regression, Functional and Front End testing
- Experience in Testing applications on UNIX environment
- Strong problem solving, troubleshooting and efficient to handle multiple tasks easily
- Excellent Communication, Analytical and Interpersonal skills
WORK EXPERIENCE:
Sr. ETL Tester
Confidential - Billings, MT
Responsibilities:
- Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
- Extensively used ETL methodology in testing for supporting d Confidential extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
- Expertise in writing SQL Statements in d Confidential base to make sure whether the d Confidential is populated in D Confidential Mart/D Confidential warehouse According to Business Rules.
- Tested the reports generated by OBIEE and verified and validated the reports using SQL.
- Performed d Confidential analysis and d Confidential profiling using SQL and Informatica D Confidential Explorer on various sources systems including Oracle and Terad Confidential,
- Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
- Promoted Unix/Informatica application releases from testing to QA and UAT environments
- Developed test reports and participated in testing prioritization and archived test results and user signoff
- Used TOAD Software for Querying ORACLE.
- Wrote Complex SQL queries to validate the standard reports, Dashboards and Business Objects Universes.
- Tested all OBIEE Dashboards according to the requirement
- Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
- Performed the tests in both the SIT, QA and contingency/backup environments
Environment: Informatica Power center 9.5 (ETL), HP Quality Center, Rational Clear Quest, Rational Clear Case, QTP,SQL SERVER, SSIS, Toad for Oracle, ORACLE 10g, Unix, Autosys, Hyperion 8.5, Java, Windows XP.
ETL Tester
Confidential, Great Falls, MT
Responsibilities:
- Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
- Performed Functionality, Stress, Security, and GUI & Regression testing of web-based applications.
- As QA Tester, performing responsibilities with both the functionality and back end testing.
- Wrote SQL, PL/SQL Testing scripts for Backend Testing of the d Confidential warehouse application.
- Worked with Production environment to resolve several d Confidential issues.
- Followed HIPAA implementation guides for preparing the EDI files.
- Created test cases for testing the 276/277, 270/271 and 278 transactions.
- Used PL/SQL programs for performance testing and wrote PL/SQL /Complex SQL queries for system testing.
- Written several Stored Procedures and modified existing stored procedures.
- Involved with extraction routines to verify all the required d Confidential loaded into target systems.
- Extensively executed SQL queries in order to view successful transactions of d Confidential and for validating d Confidential .
- Worked with SOAPUI for testing Web Services
- Enrolled members through online screens and 834 transactions
- Created the test d Confidential for interpreting positive/negative results during functional testing.
- Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
- Analyzed and created the bug tracking reporting and summary report in the Quality Center
- Used SQL queries and custom programs to perform d Confidential validation.
- Prepared test cases by understanding the business requirements, D Confidential Mapping documents and technical specifications.
- Tested both the Web Service Architecture and Service Oriented Architecture
- Testing of different types of ICD 9 as per requirements
- Used Quality Center to log defects and monitored the defects for successful resolution.
- Designs and directs the preparation of test d Confidential ; prepares test d Confidential, documents detailed results, provides regular and ad-hoc test reports.
- Did d Confidential analysis and d Confidential testing and verified fields present in the reports are as agreed in the ETL specifications.
Environment: Oracle 11g, SOA, SOAP, SOAPUI, SQL, PL/SQL, ALM/HP Quality Center 11.0, QTP, Stored Procedures, XML, XSLT, MS Excel, MS Access, TOAD
ETL/SQL Tester
Confidential - Atlanta, GA
Responsibilities:
- Created functional test cases, test conditions, test d Confidential and performed integration, system, regression, positive, negative, E2E testing.
- Escalated testing issues, interacted with business users/analysts, developers, external teams to resolve the defects/issues.
- Tested all the ETL process developed to load the d Confidential into the d Confidential marts.
- Tested the various reports like Dashboards, Summary and Drill through reports developed in business objects
- Execute SQL test scripts and record actual result.
- Interacted with Project team and users to get information about the application and decide various tests that can be performed for the specific application.
- Preparing and Reporting Daily/Weekly Status Reports.
- Extensively involved in Regression, smoke and Sanity testing.
- Tested various d Confidential feeds based on the d Confidential flow diagrams from deposits, loan to General ledger.
- Written complex SQL queries to perform d Confidential validations.
- Maintained and contributed the entire progress reporting exercise.
- Took part in daily scrum and weekly progress calls for the move.
Environment: Informatica 9, Agile - Scrum, Oracle 11g, MS SQL2008, MS Office, HP ALM
Quality Analyst
Confidential, NY
Responsibilities:
- Involve coordination with stakeholders for systems specification Analyzed user/business requirements and functional specifications documents.
- Performed various functions prior to conducting tests such as d Confidential analysis and mapping.
- Conducted Quality Assurance tests for ETL process.
- Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts Developed SQL queries /scripts to validate the d Confidential such as checking duplicates, null values, truncated values and ensuring correct d Confidential aggregations Evaluated and documented business requirements and technical specifications for Mobile App Perform QA Smoke, Acceptance, Regression, Function, UI, Usability and Compatibility Testing Involved in writing Requirement Tractability Matrix (RTM) detailed Test Plan and Test scenarios.
- Logged defects encountered in the application through Jazz team server during test cycles and conducted fix verification.
- Involved in testing application on different mobile Platform such as iOS and Android devices.
- Attended Demos, met with Client for User Acceptance, and providing QA Signoff on the testing.
- Prepared test cases for d Confidential verification Compared SQL results with application results by writing SQL queries.
- Involved in SCRUM meetings with the Development and Product Management team and analyzed and developed product stories and included them in Sprint backlog Perform REST APIs, Web & D Confidential base testing using postman.
- Involved in sprint planning and story grooming Maintained documentation of existing d Confidential flows for system interfaces
- Worked on the project releases and production tickets.
- As a scrum team member coordinated and worked with the business SME's, R&D development team and QA team members.
- Conducted system testing and developed system configurations.
Environment: Jazz Team server, Pega PRPC, PMF, MS Office Excel, Word, PowerPoint, Share point, SQL server