SUMMARY:

• 7+ years of overall IT exposure in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Proven skills in all phases within the software development lifecycle and very strong in the implementation and maintenance of Quality Engineering Processes.
• Expert in understanding of DW/BI concepts
• Expert in ETL & Reports validation, SQL
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica & Data stage
• Extensively written Test Strategy, Test plans, Test cases and followed STLC extensively for DWH testing practices.
• Strong in both Manual & Automation Testing.
• Used various Automation & performance tools like QTP & Load Runner
• Experience in Business Intelligence in generating various reports using Micro Strategy, Cognos, Business Objects and OBIEE
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Power Mart, Power Analyzer, Power Connect.
• Experience in bug reporting and bug tracking using management tools such as Quality Center and communicated recorded problems to the responsible QA or development personnel.
• Experienced in using testing tools like Test Director, HP Quality Center, ALM to write and maintain Test scripts

TECHNICAL SKILLS:

Data Warehousing/ ETL Tools: Informatica Power Center 7.x/8.x/9.x, Data Stage, Ab Initio, Repository & Data mart

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

BI Tools: Business Objects XIR3/XIR2/6.x, Cognos, Micro Strategy, OBIEE

Databases: Oracle 11g/10g/9i/8.0, MYSQL, SQL Server 2008, DB2, Teradata v2r6

Scripting Language: Shell Scripting, Shell, C Shell, Bourne Shell, Bash

Other Tools: SQL*Plus, Dream weaver

Operating system: UNIX (Sun Solaris 8.0), Windows XP/Vista

Automation Tools: QTP 9.5, UFT 11.5, Load Runner 9.10, Postman

Testing Tools: HP Quality Center 10, ALM 11, Test Director, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Tallahassee, FL

Sr. ETL Tester

Responsibilities:

• Extensively worked on all phases of SDLC i.e. requirement gathering, gap analysis, worked with developers, building test strategies which involves test scenarios, test cases, test execution, and post production validations.
• Worked on several projects simultaneous.
• Worked with several cross functional teams with in enterprise landscape in identifying the requirements, understanding the data flow within each system, and executing end to end test scenarios.
• Worked on Agile and Waterfall methodologies.
• Wrote several test scenarios & test cases to validate data from source to target.
• Worked with business users in assisting for UATs and documentation.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Design/developed and managed Power Center upgrades from v7.x to v8.6, Migrate ETL code from Informatica v7.x to v8.6. Integrate and managed workload of Power Exchange CDC.
• Performed REST Testing by creating REST requests in SoupUI
• Performed Functional Integration, System, Regression, End to End, Ad Hoc and UAT Testing.
• Worked on several systems like Microstrategy, Business Objects, & EDW.
• Created and joined tables in MS Access and generated desired output as a part of data validation.
• Tested several mapping rules as per the business requirements.
• Supported business-wide Oracle and Informatica data quality and ETL testing for investment accounting system
• Extensively wrote several simple to complex SQL Queries using various joins and Sub Queries.
• Worked extensively on Teradata SQL Assistant to fetch target data as per the requirements.
• Uploaded and executed test cases in HP Quality Center and HP ALM. Also logged defects and assigned to concerned developer.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.
• Created detailed periodic Status Reports for senior management to keep them on the progress of implementation.
• Attended periodic meetings, teleconferences and led discussions on problem resolution.
• Extensively used MS Excel and MS Access to validate data between source and target.
• Validated Transactional data on a weekly basis.
• Extracted and validated flat files using UNIX environment.
• Attended daily Stand up, Scrum and Defect Review meetings.

Environment: Teradata SQL Assistant 13.10, Oracle, Quality Center 10.00, SoapUI, JIRA, Data Stage, MS Access, Excel, Unix, Putty, Control - M, Micro Strategy, Pipe delimited Files

Confidential, Westlake, TX

Sr. ETL Tester

Responsibilities:

• Responsible for creating Test Strategy, Test Plans, Test Cases and other test documents based on business requirement.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica flow.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Reviewed the existing reports in MicroStrategy and analyzed the freeform SQL to understand the reporting requirement
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema.
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner
• Change Data Capture can do using the Power Exchange.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Performed Functional Integration, System, Regression, End to End, Ad Hoc and UAT Testing.
• Validated various dashboards.
• Written Test Cases and tested them on Postman for REST API Testing.
• Extensively used SQL queries for data validation and back end testing.
• Tested UNIX shell scripts created for data migration.
• Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options drill up, drill down and drill anywhere
• Involved in extensive data validation using SQL queries and back-end testing
• Used HP ALM for test scripts creation, execution, test coverage and defect tracking
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance

Environment: Teradata, Informatica 9.5.1, Control M 6.4, HP ALM 11.52, Informatica Power Exchange (8.6/8.5), Postman API, Putty, UNIX, Core FTP Lite, Filezilla, Microstrategy, OBIEE, Oracle, Excel & MS Access

Confidential, Cherry Hill, NJ

ETL Tester

Responsibilities:

• Extensively written several Test Scripts to compare source and target database.
• Analyzed the requirements and wrote simple to complex queries to test the requirements.
• Performed Dry Run on the test scripts before System Integration Testing.
• Involved in verification, validation, functional, GUI, system integration, sanity, and regression testing
• Validated data from source to stage and stage to target database.
• Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data.
• Worked on Informatica workflow monitor to create and execute workflows
• Used Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Performed record count from source to target database
• Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Extensively worked with flat files and Excel sheet data sources. Wrote scripts to convert Excel to flat files.
• In the process of data migration, migrated data from an Oracle data source to Teradata.
• Prepared test/Seed data for various positive and negative testing scenarios.
• Tested Micro Strategy reports and written test cases using HP Quality Center.
• Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents.
• Extensively worked on Quality center to execute a bunch of test scripts.
• Logged the defects found in quality center while execution of test scripts
• Automated & executed test cases using UFT
• Tracked the bad records present in the table.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Micro Strategy SQL engine generated queries.
• Validated the data present from flat files to database
• Wrote complex SQL queries using Teradata SQL assistant and toad for various testing purpose
• Developed test/QA environment using Informatica.
• Created mappings and executed workflows using Informatica power center
• Tested the layout of the table from the database to the data model.

Environment: Teradata SQL assistant 13.0, Micro Strategy, Toad for Oracle10g, Informatica Power Center 8.6.1, MS Excel, Erwin Data Modeler, SQL loader, Quality Center, Cobol Files, UNIX, UFT 11.5,

Confidential, Foster City, CA

ETL Quality Analyst

Responsibilities:

• Worked closely with Business Analysts and Developers to gather Application Requirements and Business Processes in order to formulate the test plan.
• Developed and maintained innovative, repeatable QA test plans based on functional requirements, use cases, user interface designs, system design documents and domain noledge.
• Created high level strategy documentation and detailed test documents.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Test planning, documentation, coordination and execution and work with other QA engineers to coordinate testing.
• Extensively used Load Runner to validate the performance testing.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Experienced in writing complex SQL queries.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Determined the level of testing required validating new or revised system capabilities.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Developed Test Plans and developed Test Cases/Test Strategy with input from assigned business analysts and data architect.
• Reported accurate testing status and created test summary reports.
• Continuously improved test models, test data, and test processes based on lessons learned.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor
• Coordinated component and system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used TOAD, SQL developer software for querying the Oracle databases.
• Used Teradata SQL Assistant 12.0 for accessing Teradata database on DEV, QA and Production areas.
• Created test mappings and MLOAD scripts for testing purposes.
• Used Maestro scheduler for composing and executing jobs to simulate the production environment in QA.

Environment: ETL (Informatica 8.5.1, Power Center), Business Objects XIR2, UNIX, Mercury Quality Center 8.2 (Test Director), Maestro Conman Scheduler, Oracle 10g, TOAD, Teradata SQL Assistant, Load Runner 9.10