SUMMARY:

• Over 7 + years of experience as an ETL Tester and Software Quality Analyst
• Proficient in performing ETL BI and backend manual testing.
• Experience with Initial and Incremental load testing within ETL Testing.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Experience in preparation of Test Cases and to ensure detailed test process wrote Test Scripts
• Hands on experience working and Agile Methodology.
• Extensive Experience in creating Test Cases, Test scripts, Test Strategies and Test.
• Plans based on FSD's, BRD's & Use Cases Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, Microstrategy, ssrs.
• Strong Business and Functional exposure on various business applications including Financial and Healthcare.
• Flexible, resourceful, and self - motivated and can work as a team and independently.
• Authorized to work in United States for any employer
• Experience in preparation of test data to test the functionality of Informatica Sources Mappings and Targets.

TECHNICAL SKILLS:

Test Management Tools: Quality Center/ALM, JIRA.

Functional Testing Tools: Unified Functional Testing UFT/QTP

Languages: C, C++, .Net, Java, XML, HTML, Visual Basic 6.0.

DWH/BI Tools: Informatica Power Center

Databases: Oracle, SQL Server, SQL Developer, TOAD

PROFESSIONAL EXPERIENCE:

Confidential - MC LEAN, VA

QA/ETL TESTER

RESPONSIBILITIES:

• Tested Informatica ETL mappings that transfer data from source systems to the Data Mart.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Involved in Teradata SQL Development, Unit Testing and Performance
• Expertise in utilizing Oracle utility tool SQL and expertise in Toad for developing Oracle applications.
• Performed Teradata SQL Queries, creating Tables, and Views by following
• Extensively used Informatica power center for extraction, transformation and loading process
• Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
• Used Toad for query Oracle, SQL and SQL Management studio for SQL Server
• Written several complex validating Cognos Reports
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes.
• Used Toad for query, SQL Assistant and SQL Management studio for SQL Server
• Generated Cognos reports target view and validating to match user requirements
• Participated in defining and executing test strategies using agile methodology
• Created complex SQL queries for querying data against different data bases for data verification process
• Good working experience in Oracle, Unix Shell Scripting
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting Coordinating data movement and validation with third party vendors.
• Used Toad for, SQL Assistant for Teradata and SQL Management studio for SQL Server.
• Managed and executed the test process, using Agile Methodology

Environment: Informatica, Cognos, SQL, Quality center, Oracle, Teradata, Agile.

Confidential - IRVINE, CA

SQL/ ETL TESTER

RESPONSIBILITIES:

• Expertise in utilizing Oracle utility tool SQL and expertise in Toad for developing Oracle applications
• Hands on experience working in V-Model and Agile Methodology.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins using Rapid SQL.
• Writing and Executing Test cases and defect tracking using Quality Center.
• Extracted data from various sources like Oracle, flat files and SQL Server
• Used Toad for query Oracle, SQL Assistant for and SQL Management studio for SQL Server
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center / ALM, SharePoint
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
• Worked with business team to test the reports developed in Cognos and executed the test process, using Methodology.
• Test ed ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Involved in validating the batch processes such as Informatica and UNIX Scripts scheduled using Autosys.
• Developed SQL queries to test the data after uploading vehicle, buyer, and saler information into Autotrader
• Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI Managed and executed the test process, using Agile Methodology.

Environment: Informatica, Cognos, SQL, Quality center, Oracle, Teradata, Agile

Confidential -NORRTHBROOK, IL

ETL TESTE

RESPONSIBILITIES: -

• Worked on Data Stage to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables
• Tested several reports detailing price/volume trends and expense variance over previous periods by using micro strategy
• Developed SQL scripts to test business logic from source to target.
• Used JIRA to state requirements, test plan, test cases, and update test run status for each iteration and to report the defect
• Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using ETL tools and Data Stage
• Performed extensive Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application.
• Participated in defining and executing test strategies using agile methodology.
• Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using JIRA.

Environment: Data stage, Microstrategy, Oracle, DB2, Jira, SQL, Agile.

Confidential

ETL TESTER

RESPONSIBILITIES:

• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide -ETL Solution using Data Stage
• Extensively used MicroStrategy for report generation.
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Good understanding of FACT and Dimension tables. Very strong in SQL and PL/SQL, extensive hands on experience in creation of database tables, triggers, sequences, functions, procedures, packages, and SQL performance-tuning.
• Reported bugs and tracked defects using JIRA
• Used SQL for Querying the DB2 in UNIX environment
• Working knowledge in Agile/Scrum (using Rational Team Concert - IBM), Waterfall and Iterative SDLC methodologies.
• Validated various Reports, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in MicroStrategy.

Environment: Data stage, Microstrategy, Oracle, DB2, Jira, SQL, Agile