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.