We provide IT Staff Augmentation Services!

Sr.etl Qa Resume

Oakland, CA

SUMMARY

  • 8+ years of extensive experience in IT industry, spanning across areas Data mining, Data warehousing and Data Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design ETL and reporting on Windows and UNIX environments.
  • Strong expertise in Business Intelligence Strategy, Performance Management Scorecards / Dashboards, Data Mining, Data Warehouse Architecture, Business Intelligence Software Evaluations, ETL Architecture (Data Integration, Data Migration), Master Data Management, Conversions/ Migrations, OLAP / Business Intelligence Reporting Tools, Data Modeling, Data Quality/Metadata Tool.
  • Extensive experience in Informatica ETL testing of DWH applications and reporting applications. Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
  • Experienced in Software Development Life cycles (SDLC), Business Process Modeling (BPM) and in various software development methodologies Waterfall, Agile and SCRUM.
  • Experience in Black box testing with a complete QA cycle - from testing, defect logging and validation of fixed bugs
  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse usingInformatica.
  • Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
  • Experienced in testing requirements that were developed in ETL and BI of DWH applications and reviewed scripts for positive and negative test scenarios, and prepared test summary.
  • Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
  • Extensive testing ETL experience usingInformatica(Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager
  • Experience in Continuous integration, continuous delivery/deployment tooling.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Proficient in Dimensional Modeling-Star/Snowflake modeling, OLAP, OLTP and Data Warehouse Appliances.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, MAC

Database: Oracle, Microsoft Access, MySQL, Teradata, DB2, SQL Server

ETL Tools: Informatica, SSIS

Methodologies: Waterfall, Agile (Scrum, XP)

Desktop Tools: MS Word, Microsoft Excel, MS PowerPoint.

Defect Tracking Tools: JIRA, Informatica, Toad

PROFESSIONAL EXPERIENCE

Confidential - Oakland, CA

Sr.ETL QA

Responsibilities:

  • Transformed business requirements into Technical requirement documents and Technical design documents.
  • Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
  • Extensively used ETL to load data from Greenplum, XML & Flat files Source to Database Server.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, and application testing.
  • Prepared Test Plan and Test strategy from the Business Requirements and Functional Specification for the integrations.
  • Understood the ETL Informatica mapping document and created the test ware.
  • Developed Test Cases for Deployment Verification, Informatica ETL Data Validation, and application testing.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Tested to verify that all data were synchronized after the data is troubleshoot and used SQL to verify/validate my test cases.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Created queries using join and case statement to validate data in different databases.
  • Created specifications and documented source to target mappings according to the business rules and involved in Data Collection.
  • Tested Informatica mappings for various ETL functions.
  • Involved with ETL test data creation for all the ETL mapping rules.
  • Preparing and supporting the QA and UAT test environments.
  • Perform in-depth source data analysis and source-to-target gap analysis. Document the source-to-target data mappings for ETL design.
  • Involved in developing all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.

Confidential - Charlotte, NC

Sr. ETLQA

Responsibilities:

  • Worked with business users for requirement gathering, understanding intent and defining scope and am responsible for project status updates to Business users.
  • Developed, implemented and evaluated metadata and cataloging workflows and standards.
  • Performed Black System testing, Regression and end-end testing.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Designed and developed reports to support business intelligence activities and business data management.
  • Extracted Data using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Involved with ETL test data creation for all the ETL mapping rules.
  • Participated in analyzing and modeling the requirements for the logical and physical design of the database using star schema and normalization techniques.
  • Tested to verify that all data were synchronized after the data is troubleshoot and used SQL to verify/validate Informatica ETL.
  • Experienced in writing complex SQL queries for extracting data from multiple tables. Testing has been done based on Change Requests and Defect Requests.
  • Preparation of System Test Results after Test case execution.
  • Tested several packages developed using SSIS.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Written several test cases for SSIS Packages and for data flow.
  • Participate in biweekly technical huddle meeting with development and DBA team.

Confidential - Austin, TX

Data Analyst

Responsibilities:

  • Written complex SQL queries for querying data against different data bases for data verification process.
  • Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
  • Developed executive dashboard for several departments.
  • Participated in business requirement walk through, design walk through and analyzed Business requirements.
  • Tested the reports generated by SQL Server reporting services (SSRS) and checked as they are as per the Organization standards.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
  • Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
  • Tested and supported data extraction, transformations and loading processing in a corporate-wide-ETL Solution using SSIS.
  • Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.
  • Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
  • Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
  • Written customized SQL queries for business needs.
  • Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT and regression testing.
  • Created Test Plans for major functional components, migration of application in different windows & browser environments.

Confidential, Kansas City, MO

ETL QA

Responsibilities:

  • Involved in testing data mapping and conversion in a server-based data warehouse.
  • Worked on Performance tuning to ensure reports and reporting environments are optimized to the fullest extent.
  • Created database objects like stored procedures, function, packages, Cursor and Ref Cursors
  • Performed Unit Testing and Prepared Application for Release to Testing Team. Analyzed defects found in testing and fixed Coding errors.
  • Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
  • Excellent experience on SQL tuning.
  • Prepared test environment for QA team to test the developed application from end-end.
  • Reviewed the Business Requirement Documents and the Functional Specification.
  • Prepared Test Plan and Test strategy from the Business Requirements and Functional Specification for the integrations.
  • Developed Test Cases for Deployment Verification, ETL Data Validation, and application testing.
  • Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Followed waterfall and AGILE development methodology and adhered to strict quality standards in requirement gathering.
  • Functioned as the Onsite / Offshore coordinator for a team.
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Created custom views to improve performance of the PL/SQL procedures.
  • Testing has been done based on Change Requests and Defect Requests.
  • Preparation of System Test Results after Test case execution.
  • Performed Functional, Regression, Data Integrity, System, Compatibility.
  • Extensively executed SQL queries in order to view successful transactions of data and for validating data in Oracle Database.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting

Confidential

ETL QA

Responsibilities:

  • Involved in testing data mapping and conversion in a server-based data warehouse.
  • Tested data warehouse ETL process using SSIS Integration Service.
  • Involved with ETL test data creation for all the ETL mapping rules.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Responsible in testing Initial and daily loads of ETL jobs.
  • Designed, developed and deployed both one-time and continuous production data analysis processes that include SQL queries, tables, reporting, Business Intelligence Tools and ETL functions.
  • Tested and Validated ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables
  • Wrote Requirement documents for new ETL Process, data migration process and new Data Warehouse Design.
  • Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping.
  • Analyzed and created the bug tracking reporting and summary report in the Quality Center
  • Tested Complex ETL SSIS and SSRS Packages and Sessions based on business user requirements and business rules to load data from different source.

Hire Now