Etl Tester Resume
Deerfield, IL
SUMMARY:
- 7 + years of experience as an ETL tester.
- Experienced in all stages of Software Development Life Cycle and Software Testing Life Cycle.
- Good knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and dimension tables in Target D/W.
- Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
- Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
- Collaborating with project team to discuss and resolve issues
- Experience in Web based applications like online banking, transactions applications, healthcare, and telecommunication.
- Tested the ETL Informatica mappings and other ETL Process (Data Warehouse Testing)
- Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
- Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
- Extensive worked on HP Quality Center 10.0 & HP ALM Quality Center 11.0 to upload Test Cases, Execute Test Cases, Log Defects, Track Defects, and Track Progress Status.
- Experience in working with Software Development team in resolving Defects, presenting the Defects status reports, resolving requirement, and observed design inconsistencies.
- Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
- Experience in Reports testing in Crystal Reports XI Environment.
- Tested Web Services /XML /SOAP services using SoapUI tool.
- Validated WSDL, request and response XML. Added Assertions to validate the response xml with database.
- Strong working experience in Windows NT/2000/XP and UNIX environments
- Clear understanding of business procedures and ability to work as an individual and as a part of a team.
- Experience in interacting with business analysts, developers, and technical support and help them base line the requirement specifications.
TECHNICAL SKILLS:
Operating Systems: Windows, LINUX, UNIX
Languages: SQL, PL/SQL, XML
Test Management: HP ALM, JIRA
ETL Tools: Informatica 9.5 DataStage 8.7/8.1, Informatica
Web Services: Soap UI
RDBMS/ Databases: Oracle 11g/10g, SQL Server 2008/2005, Teradata
BI Tools: Tableau, Cognos
PROFESSIONAL EXPERIENCE:
Confidential, Des Moines, IA
ETL Tester
Responsibilities:
- Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
- Involved in complete life cycle activities like pre - testing phase and testing phase.
- Created Test Procedures and Test Cases to perform the system testing and Regression testing.
- Used Jira to log the bugs
- Participating in business discussions with business, product owner, BA and Tech lead to define test requirements and to provide test estimations to satisfy the business objectives.
- Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
- Ran workflows created in Informatics by developers then compared before and after transformation of data generated to ensure that transformation was successful.
- Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
- Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability.
- Created various User Defined Functions for script enhancements and to verify the business logic.
- Extensively used SQL queries to perform database validation
- Responsible for reviewing complete test plans, test cases, test data and ensuring accurate coverage of requirements and business processes for the Big data warehouse
- Manage the Test data, Test environment and resolving QA environment issues.
Environment: HP ALM 11.0, Informatica Power Center 10, MS Excel, Oracle 11g, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, Windows, Cognos 10.2
Confidential, Deerfield, IL
ETL Tester
Responsibilities:
- Involved in Business analysis and requirements gathering
- Involved in Preparation of Test Plan and approach based on the Business requirements
- Experienced in Data warehouse testing, in all the phases of Data warehouse life cycle.
- Expertise in Writing, Executing and Maintaining Test Plans, Test Procedures, Test Cases, Test data in all phases of SDLC
- Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
- Analyzing complex reports and to improve the performance of those reports by adding some new filters to filter the data.
- Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s using Oracle Analysis Services.
- Optimized the queries by creating various clustered, non-clustered indexes and indexed views.
- Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
- Strong experience using Oracle, MS SQL Server, Teradata.
- Experienced in Database / Data warehouse testing life cycle.i.e., Conversion Testing, Integration testing, System & Acceptance testing and Regression testing.
- Validating the complete source to target mappings along with transformation rules.
- Implemented data verification procedures for ETL processes in load testing.
- Used Data Stage ETL tool to load data from various sources into target database and validated different transformations to move data from source to target.
- Extensively used SQL scripts to perform backend database testing and Tested Data Stage Mappings.
- Reviewed requirements and mapping documents to identify gaps analysis.
- Worked with developers in understating the ETL code for writing several complex test plans for testing both front-end and backend.
- Prepared several test scenarios for the work flow of the entire ETL cycle.
- Developed Test Plans/Test Cases to Validate Key Business Requirements.
- Written and executed complex SQL queries to validate accuracy of the reports.
- Extensively used ETL tool to extract data from Oracle database and loaded into SQL Server database.
- Tested Web Services /XML /SOAP services using SoapUI tool.
- Validated WSDL, request and response XML. Added Assertions to validate the response xml with database.
- Participated and conducted Agile Scrum Daily project meeting and planning using the AGILE process.
Environment: SQL, PL/SQL, SQL SERVER, Oracle 11g, Unix, Jira, DataStage 8.5, XML, Jira, Agile, SoapUI, Cognos 8.4.
Confidential, Texas
DWH TESTER
Responsibilities:
- Worked on creating Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
- Proficient in testing several data migration application for security, data protection and data corruption during transfer.
- Responsible for testing packages using (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT and regression testing.
- Created test cases and executed test scripts using HP ALM/Quality Center.
- Tested the data and data integrity among various sources and targets.
- Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
- Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
- Involved in preparing test data for UAT and participated in UAT signoff.
- Involved in Data migration and Data distribution testing.
- Worked on testing the Application in UNIX Environment and collecting the Test data from the Business Team.
- Involved in testing the Cognos reports by writing complex SQL queries.
- Performed Functional, Data Validation, Integration, regression and User Acceptance testing.
- Participated in defining and executing test strategies using agile methodology.
- Used TOAD, DB Visualizer tools to connect to Oracle Database to validate data that was populated by ETL applications.
- Developed Oracle SQL test scripts from test procedures and expected results and executed them in various test environments.
- Responsible for integration testing activities with other Data Warehouse teams and upstream/downstream application test teams.
- Adopted Agile/scrum methodology for - Risk Mitigation, Monitoring and test Management (risk analysis) at every stage of the project Cycle with transparency in planning and module development.
Environment: SQL, PL/SQL, SQL SERVER Oracle 11g, Unix, Jira, Informatica power center 9.5, XML, Jira, Agile, SoapUI, Teradata, cognos, HPALM.
Confidential, Hamilton, NJ
Manual QA Tester
Responsibilities:
- Involved in creating Test Plan, Test Cases by analyzing Business Requirement Document.
- Documented and executed Test plans, Test cases and Test scripts based on business requirement document.
- Implemented agile methodology throughout the process.
- Experienced in functionality testing, black box testing, system testing, integration testing, regression testing, backend testing, compatibility and user acceptance testing.
- Possess good judgment skills while reporting and prioritizing software bugs in conjunction with the development and QA Managers.
- Involved in executing the basic SQL Queries for Data Validation, Record Counting and Non-duplication Testing.
- Developed SQL scripts, to implement business rules.
- Manually performed integration and Regression testing, documented bugs and worked with development team to resolve issues.
- Used JIRA to log bugs
- Exported test cases into the Quality Center, ran manual test cases from test lab and logged defects from defect module.
- Performed Ad-hoc, Smoke, Functional, and Regression testing by executing test cases maintained in Quality Center.
- Performed Smoke testing in the UAT environment to ensure successful migration prior to notifying the customer to start performing UAT testing.
- Generated Test Status Reports, Defect Reports.
- Actively participated in the test plan review meetings, Walk through, Weekly meetings.
Environment: HP Quality Center 10.0, Microsoft office, UNIX, Windows OS, Mac OS, JIRA, Internet Explorer