We provide IT Staff Augmentation Services!

Etl Tester Resume

Malvern, PA

SUMMARY

  • Over 5+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Banking and healthcare Industries.
  • Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
  • In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, Netezza, Teradata, Oracle, and ETL.
  • Extensive work experience in T-SQL and PL/SQL by writing Packages, Stored Procedures, Functions, Views, Database Triggers, User-Defined Types, Dynamic SQL, Bulk binding techniques using SQL developer, TOAD and SQL Server Management Studio.
  • Good knowledge in Software Development Lifecycle (SDLC), Agile, scrum methodologies.
  • Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
  • Experience in ETL tools like power center 10.x/9.x integration with process server databases Oracle, SQL Server, Netezza.
  • Working knowledge in ETL development, Data Migration concepts using native tools of Oracle (SQL LOADER, PL/SQL, and TOAD).
  • Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
  • Experience in validating star schema, fact and dimension tables, physical and logical modeling.
  • Good Knowledge on Netezza analytic functions and written complex queries using Aginity Workbench.
  • Experience in Debugging of Informatica mappings.
  • Experienced in writing SQL queries, PL/SQL collections and Exceptional handling, understanding requirements and developing plans.
  • Experience in using automated testing tools like Informatica IDQ.
  • Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
  • Strong knowledge on Health insurance portability and accountability act (HIPAA) and HL7 formats.
  • Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
  • Extensive experience in Black Box testing, Functional testing, Integration testing, System testing, Regression Testing, Performance testing on Warehouse Applications.
  • Involved in preparation of Test Cases based on High level requirements and make an ensure detailed/system level process wrote Test Scripts
  • Involved in preparation of Test data to test the functionality of ETL Sources Mappings and Targets.
  • Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Tools such as Quality Center, Test Director.
  • Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
  • Experience in maintaining support documents, Test Plans, QA Sign off Documents and Maintaining Weekly Status Reports.
  • Excellent communication skills, Good organizational skills, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS

Testing Tools: Quality Center10.0/9.0, Quick Test Pro 9.2/ 10.0, ALM

GUI: C, C++, .NET, Java, JUNIT, J2EE, Java script, Visual Basic

ETL TOOLS: Informatica Power Center 10.x/9.x (Data Exchange, Data Transformation), SSIS, SSRS, Cognos.

DATABASES: Oracle, Netezza, SQL Server, MS Access

LANGUAGES: HTML, C, Java, SQL, C#, PL/SQL, T-SQL

DB TOOLS/TOOLS: Toad 11.x/9.x/8.x, SQL *Plus, SQL Developer, SQL Server Query analyzer, Management Studio, Aginity

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

ETL Tester

Responsibilities:

  • Successfully completed multiple projects involving complex business rules and technical skills.
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
  • Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.
  • Involved in writing Complex queries using SQL for Data Integrity checks.
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
  • Performed Functional, Smoke, Integration, and System testing of Data warehouse application.
  • Involved in testing the ETL processes to load data from Flat files, XML, SQL Server, Access and Excel spreadsheets into the target Oracle database/netezza by applying business logic on transformation mapping for inserting and updating records when loaded.
  • Validating the data in various stages of data movement from Source to Staging and from Staging to Data Warehouse tables.
  • Performed Data Quality Checks, Cleansed the incoming data feeds and profiled the source systems data as per business rules using IDQ.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Written test cases for checking the populated data correctly into fact and dimension tables.
  • Actively participating in project specification reviews, writing and maintaining QA technical documentation.
  • Worked extensively with transformations like Lookup, Update strategy, Expression, Filter, Stored Procedures, Router and other.
  • Active interaction with business clients in requirement gathering, analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design logic.
  • Worked on different task in Workflow like sessions, events raise, event wait, decision mail, commands, worklets, Assignments, Timer and Scheduling of the workflow.
  • Develop and execute functional/system test cases to ensure that Datamart meets functional and design specifications.
  • Tested the SQL queries on clinical DATA MART and Reviewed and collect medical information for creating Reports on lab results. The application was originally created for Windows platforms.
  • Report product bugs, bug isolation, verify fixed bugs and issue resolution.
  • Executed Medical Protocols to emulate Doctor-Patient scenarios to validate data accepting by device.
  • Extensively used ETL to load data from XML source feed from vendor and Flat Files to Staging area using Informatica Power Center 9.1 Worked with pre and post sessions, and knowledge of identifying facts and dimensions tables.
  • Produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off for a high volume of data and regular release schedule for successful project delivery.
  • Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables (Data Warehouse).
  • Provide feedback to design reviews and test tool selections/improvements.
  • Verified the logs to identify the errors occurred during the ETL execution.
  • Written several complex SQL queries for data verification and data quality checks.
  • Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.

Environment: Informatica Power Center 9.x, Oracle 11g/10g (SQL, PL/SQL), Erwin, Windows, Netezza 7.*, UNIX, JIRA, Informatica IDQ, Winscp, Putty, SSMS 2014/2012, TOAD, SQL Developer, QC, ALM, Cognos, Informatica IDQ.

Confidential, Boston, MA

ETL Tester

Responsibilities:

  • Involved in leading and participating in the full software life cycle for testing (STLC) activities - from test planning, test execution to test monitoring, status reporting, documentation and Business Objects report validation.
  • Reviewed requirements documented (mapping document/Report Specs) by Business Analyst for thorough understanding of the application.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Identifying duplicate records in the staging area before data gets processed.
  • Extensively written test scripts for back-end validations.
  • Ensured that the mappings are correct and conducted data validation testing.
  • Designing and defining test cases in ALM Quality center.
  • Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules and good understanding of BI business models.
  • Validating the Archive process to purge the data that meet the defined business rules.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Testing included Unit, System, Regression testing, UAT testing Business Objects reports testing.
  • Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
  • Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating to SQL Server and Validated the OLAP cubes generated in SQL Server Environment.
  • Prepared test plans/test schedules with inputs from Project manager and development team.
  • Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
  • Validating the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
  • Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
  • Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
  • Validating the external data source by connecting thru Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
  • Provide flexible & high quality support to wider Testing strategies on key regular deliverables & ad hoc reporting issues.
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables
  • Involved in validating the aggregate table based on the rollup process documented in the data mapping.
  • Retested the modifications, once bugs are fixed after reinstalling the application.
  • Reported the bugs through email notifications to developers using Quality Center.
  • Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.

Environment: Informatica, Business Objects, SQL developer, SSMS 2014/2012, JIRA, ALM, Java, HTML, XML, Oracle 9i/10g, TOAD.

Confidential, Wexford, PA

ETL Tester

Responsibilities:

  • Successfully completed multiple projects involving complex business rules and technical skills.
  • Worked extensively with transformations like Lookup, Update strategy, Expression, Filter, Stored Procedures, Router and other.
  • Active interaction with business clients in requirement gathering, analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design logic.
  • Worked on different task in Workflow like sessions, events raise, event wait, decision mail, commands, worklets, Assignments, Timer and Scheduling of the workflow.
  • Develop and execute functional/system test cases to ensure that Datamart meets functional and design specifications.
  • Expertise in DWH technologies like Teradata concepts and loading utilities.
  • Tested the SQL queries on clinical DATA MART and Reviewed and collect medical information for creating Reports on lab results. The application was originally created for Windows platforms.
  • Report product bugs, bug isolation, verify fixed bugs and issue resolution.
  • Executed Medical Protocols to emulate Doctor-Patient scenarios to validate data accepting by device.
  • Extensively used ETL to load data from XML source feed from vendor and Flat Files to Staging area using Informatica Power Center 9.1 Worked with pre and post sessions, and knowledge of identifying facts and dimensions tables.
  • Coordinate execution activities at EDW level such as documentation requirements, technical reviews by Agile Lifecycle System, and verification, approval activities.
  • Successfully completed ETMS training on FDA software validation and verification processes and procedures.
  • Analyze data using SQL, Excel, UNIX and data testing tools.
  • Produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off for a high volume of data and regular release schedule for successful project delivery.
  • Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables (Data Warehouse).
  • Provide feedback to design reviews and test tool selections/improvements.
  • Verified the logs to identify the errors occurred during the ETL execution.
  • Written several complex SQL queries for data verification and data quality checks.
  • Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.

Environment: Informatica Power center 8.6, Oracle 10g/9, SSMS, JIRA, Putty, Winscp, SQL, Flat files, HP Quality Center.

Confidential

Data Warehousing Tester

Responsibilities:

  • Worked with Business Analysts to define testing requirements to satisfy the business objectives.
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Experience in SDLC and Agile methodologies such as SCRUM.
  • Analyzing requirements and creating and executing test cases
  • Test Case Execution and Adhoc testing
  • Performed Integration, End-to-End, system testing.
  • Involving in Functional Testing & Regression Testing
  • Involving in writing complex SQL queries to verify data from Source to Target
  • Performed data validation testing writing SQL queries.
  • Written complex queries in SAS tool check the data from Source and Target.
  • Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
  • Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
  • Experienced in retest the existing test cases with the different kind of source systems for different periods of data.
  • Preparing documentation for some of the recurring defects and resolutions and business comments for those defects

Environment: Informatica Power center 8.6, Oracle 10g/9.is, SQL, Flat files, HP Quality Center

Hire Now