SUMMARY

• 7+ years of IT experience in ETL Tester for Data warehouse, ETL, BI, SQL, PL/SQL, Hadoop, MS SQL Server, Teradata, ORACLE, UNIX, Web based, Client/Server applications using Manual and Automated testing tools.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and Data warehouse ETL.
• Exposure to Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification.
• Wrote extensive SQL and PL/SQL scripts to test the Data warehouse ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it is complete and fully understand EDW and ETL Architecture
• Experience in Business Intelligence in generating various reports using Cognos and Business Objects
• Excellent experience in different Databases like Oracle, Hadoop, SQL Server, DB2 and Teradata.
• Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented Architecture, Top to bottom and Bottom to top test methodology, QA Validations & QA Compliances to ensure the Quality Assurance Control.
• Experienced in Data Warehouse projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica.
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL.
• Expert in writing UNIX Shell scripting for various needs including text processing, data archiving, data parsing and database connectivity.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Used Test Director, HP ALM/Quality Center and Business Process Testing for management of test plan, test design, test execution and defect log phase. Also Rational Quality Manager for management of STLC including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Experience in Data Analysis, Data Validation, Data Verification, data profiling, identifying data mismatch and Good experience with data sources.
• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.
• Strong knowledge of RDBMS concepts. Developed SQL queries in SQL Server databases to conduct DB testing.
• Worked on Data files & label parameter of data files, strong in writing UNIX scripting.

TECHNICAL SKILLS

Defect Tracking Tools: HP Quality Center/ALM, IBM Clear Quest 9.0, QTP, Bugzilla and Jira

ETL Tools: Informatica 9.5/9.0, Data Stage, SSIS

BI/Reporting Tools: SAP BO, Crystal Reports, Cognos 8.4

Operating System: Windows, UNIX, Linux

Methodologies: Waterfall, Iterative, Agile/Scrum

Programming Languages: SQL, PL/SQL, XML, VBRDBMS/ Database SQL Server, Oracle, IBM DB2, Teradata 12.0GUI Tools TOAD, Oracle SQL Developer, SQL* Plus, SQL server

PROFESSIONAL EXPERIENCE

Sr. ETL Tester

Confidential

Responsibilities:

• Responsible for development, review, analysis, and coordination of the test plans, test scripts, and testing of internally developed software system.
• Extensively used ETL to load data from Oracle database, SQL Server, Flat files, DB2 to the DB2 Data warehouse.
• Performed Data Analysis and developed Data Mapping documents for ETL (Informatica) project.
• Performed Metadata Analysis by Data Profiling and acted as a data steward in maintaining the quality metrics on a continuous basis.
• Written complex SQL queries to validate the data movement based on data mapping document.
• Developed ETL test cases for various lines of businesses based on mapping document.
• Ensure alignment of testing strategy with the project’s quality goals and resource limits and escalates issues to the QA Lead and alerts the project team on potential impact to test schedule.
• Work with requirements analyst to get a good understanding of functionality.
• Documentation: Data migration document for various metadata tools/ procedures/ functions/ shell scripts.
• Tested Complex Data warehouse Data warehouse ETL Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS.
• Identification and documentation of test cases for multi-component systems.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Wrote ETL test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per ETL specifications.
• Responsible for verifying the log files using UNIX and database for the submitted application.
• Designed ETL architecture to Process large no of files and created High-level design, low-level design documents.
• Responsible for development of test plan and test cases and executing of test cases and documentation of software defects in Quality Center/ALM.
• Tested all the ETL mappings developed on Informatica from source level to staging and from staging to target.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Experience in creating simulated data and invoking UNIX process for data fill jobs. Provided training to the team members for working with interfaces

Environment: SQL, ETL Informatica, BI Business Objects, SAS, Metadata, Oracle 11g, HP Quality Center, MS Office Suite, HP ALM, SQL, PL/SQL, SAS, UNIX, SOAP UI and XML.

ETL Tester

Confidential, Irvine, CA

Responsibilities:

• Review functional and design specifications to ensure full understanding of individual deliverables.
• 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.
• Tested ETL Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications provided in enterprise metadata repository (EMR).
• Studied the feasibility of the reports by conducting the data analysis. Worked as Data warehouse ETL Tester responsible for the requirements / ETL Analysis, ETL Informatica Testing and designing of the flow and the logic for the Data warehouse project.
• Expert in writing Complex SQL and PL/SQL Scripts in querying SQL Server, Teradata and Oracle.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica.
• Identify any potential quality issues per defined process and escalate potential quality issues immediately to management.
• Responsible for testing all new and existing ETL data warehouse components in regression testing.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP ALM/Quality Center and executed them.
• Reporting and tracking defects using Quality Center. Validate all UAT scenarios and scripts.
• Document all phases of the Systems in QA process. Checking database transactions using SQL Server.
• 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 Data Analysis for the data warehouse and data mart system for the process of report generation.
• Prepared test data by executing SQL queries and Joins. Tested several Data warehouse ETL Informatica Mappings to validate the business conditions
• Executed SQL queries to compare the data in database with GUI and web services. UNIX / Linux commands Executed for backend data validation.
• ETL Testing process - Validated source and target databases to validate the report. Worked with automation team to identify regression test cases.
• Tested the Reports generated by the BI tool Micro Strategy and validated the data on the Reports.

Environment: Data warehouse ETL Informatica Power Center, Metadata, SQL, SAS, Agile, SQL Server 2012/2008, SQL, PL/SQL, QTP, UFT, VB Script, Teradata, Unix Shell Scripting, XML, Selenium, Cucumber, HP ALM/Quality Center.