SUMMARY

• Over 8+ years of IT experience in Data warehousing testing with extensive usage of SQL, PL/SQL, UNIX, Shell Scripting & HP QC
• Good understanding of SDLC and STLC methodologies including Waterfall, Iterative, Agile and Scrum methodologies.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, and Ab Initio and Autosys tools
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Strong testing Quality Assurance experience within agile environment.
• Experienced working with SQL Server 2008, Netezza, Oracle 10g/11g, Teradata, Sybase & DB2.
• Experienced in testing different source feeds of data for ETL and prepared mock data for ETL.
• Experience in testing Business Report developed in Business Objects XIR2 & Cognos 8 series, OBIEE, Hyperion reports.
• Skills in back end testing using SQL queries on SQL Server, oracle, Teradata and DB2 tables and generating reports to ensure data integrity and validate business rules.
• Good exposure in working various test management and defect management tools like Quality Center, Jira and HP ALM.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader,
• Experienced in Writing UNIX Korn Shell Scripting for job scheduling and sequencing.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Well versed in SQL 2008, Oracle, Teradata and DB2 database concepts and usage.
• Extensive experience in UNIX Shell Scripting, AWK and file manipulation techniques.
• Experience with QA Methodology and QA Validations to ensure the Quality.
• Solid Back - end testing experience in writing and executing SQL Queries.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
• Ability to interact with all levels of personnel from technical to high level executive management within the information technology and business communities.

TECHNICAL SKILLS

Quality Assurance/ Test Management: DOORS, Requisite Pro, HP ALM 11/Quality Center 10, IBM ClearQuest 9.0, IBM Clear Case 9, Test Director 7.5, BugZilla, jIRA

SDLC/STLC: Agile, SCRUM, Water Fall, RAPID, Spiral, V- Model

RDBMS Technologies & Data Sources: Oracle 11g/10g/9i, Teradata 13.0/12.0, SQL Server 2012/2008R2, IBM DB2, SYBASE, MS Access, MS EXCEL, FLAT Files, XML

RDBMS Query Tools/GUI Tools: TOAD 10.6, SQL* Loader, Oracle SQL Developer, Teradata SQL Assistant 13.0, WinSQL

ETL/Datawarehouse: Informatica 9, SSIS, Ab Initio 2.15, IBM DataStage 8.1

BI/Reporting Tools: Business Objects XIR4, Cognos 8.4, OBIEE 10, Hyperion 11.1.2

Operating System: MS - Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Sun Solaris 5.8)

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Created some macros in Teradata to load the test data in to Target tables.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: Oracle 10g, TOAD, SQL Server 2008R2, SSIS,SSRS, SQL Server Management studio 2008, Business Objects Enterprise XI R3.1, Business Objects Designer, HP Quality Center 10

Confidential, NJ

ETL Tester

Responsibilities:

• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the performance bottle necks Confidential sources, targets, mappings, and sessions and employed required measures.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
• Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
• Used Agile testing methodology for achieving deadlines in UAT.
• Developed automated Test scripts using QTP to perform Functional and Regression testing.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Prepared scripts, running tests, Analyzing results in Load Runner 9.1 for Performance testing.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting

Environment: Oracle 10g, TOAD, SQL Server 2008R2, SSIS,SSRS, SQL Server Management studio 2008, Business Objects Enterprise XI R3.1, Business Objects Designer, HP Quality Center 10

Confidential, Rochester, NY

ETL Tester

Responsibilities:

• Participated in the requirements, design, and release readiness reviews.
• Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of the Informatica based ETL process.
• Created and maintained test documentation and test plans. Development and Execution of Test Cases for Informatica ETL components.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality.
• Used SDK to validate reports for CognosReportnet and Cognos SDK.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Performed Database Testing by writing SQL queries for generating reports to ensure data integrity and validating business rules
• Extensively executed SQL queries in order to view successful transactions of data and validating data after Backend testing
• Based on change requests, performed Impact analysis to determine the regression testing efforts
• Analyzed Test Execution Results and reported the Bugs/defects using Quality Center Performed Defect fix verification after each release
• Performed Verification, Validation, and Transformations on the Input data (flat files) before loading into target database
• Responsible for documentation of test results, test matrix, and participated in daily/weekly QA meetings

Environment: Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), ODI, Hyperion Interactive Reporting 9,Mercury Quality Center 9.0, SQL *Loader, Oracle 9i, SQL Server 2005, Erwin 3.5, Windows 2000, TOAD 7.

Confidential, NY

ETL/Backend Tester

Responsibilities:

• Created test cases and test plans for testing the ETL process and reports.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL queries.
• Tested the entire reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them in closing the defects by coordinating with the dev team.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and co-ordinated with integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
• Maintained all the test cases in Quality Center and logged all the defects into the defects module.

Environment: Oracle 8i+9i, SQL, PL/SQL, Quality Center 8.0, XML, Informatica 7.1, Business Objects 6.5, TOAD for Oracle