SUMMARY:

• Experience in full Software Development Life Cycle (SDLC) Data warehouse /Business Intelligence Methodologies, and Validations in Manual Testing towards Quality Assurance Control of over 7 years.
• Strong analytical and QA/ testing skills, capacity for work and diagnostic ability, Gathering different kind of projects requirement. Covered Agile and Waterfall models of SDLC.
• Diverse experience with various testing methods such as Functional testing, Regression Testing, System Testing, Integration Testing, User Acceptance Testing (UAT), Database Testing, End to End Testing.
• Extensive testing ETL experience using) Informatica Power Center 9.1.0/9.0/8.5. x/7.x, (Source Analyzer, Warehouse Designer, Repository Admin console, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server)
• Proficient in writing SQL queries, PL/SQL and executing SQL queries to perform backend testing.
• Expertise in Analyzing Business Specifications and develop Test Plans, Test Cases and Test Scripts and execute them.
• Worked in important phases of Software Testing Life Cycle (STLC) like Smoke Testing, Functional Testing, Integration Testing, Regression testing, and was involved in Load Testing, Performance Testing, End to End Testing and User Acceptance Testing (UAT).
• Thorough knowledge of Internet standards (HTML, HTTP), web site design principles and software usability practices
• Expertise in Integration Testing, System Testing, Performance Testing, Functional Testing, ETL Testing and Regression Testing.
• Strong hands on experience in testing Commercial Websites and Business Applications.
• Extensive experience in Testing both WEB and Client/Server environment.
• Experience in testing database applications of RDBMS in ORACLE, PL and SQL Server.
• Expertise in writing and executing SQL Queries.
• Knowledge of Software QA Standards and Methodologies.
• Excellent communication, interpersonal, intuitive and analytical skills.
• Expertise in participating actively in the meetings & tele - conferences with Users, Business Analyst team, Development team, QA team members and Managers.
• Proven ability to work efficiently in both independent and team work environments.
• Ability to work in a team.

TECHNICAL EXPERTISE:

ETL/BI Tools: Informatica PowerCenter 9.1.0, 9.0.1, 8.6., Oracle Data Integrator, Microstrategy 9.x/8.x/7.x

Testing Tools: Quality Center 8.2/9.0/9.2/ 11.52/12.50 , ClearQuest, Microsoft test manager, HP ALM 11, Jira

Languages: SQL, PL/SQL, T-SQL

Internet Technologies: VBScript, JavaScript, XML, HTML

Database Tools: TOAD, SQL Developer, Rapid SQL, Dv visualizer

Others: MS-Word, MS Excel, MS-PowerPoint, MS- Outlook, IIS

Operating system: Windows, UNIX, Mac OS X

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr.ETL SQL 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.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Involved in extensive Data validation using SQL queries and back-end testing
• Used SQL for Querying the Oracle database in UNIX environment
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Used SQL to perform Backend Testing/Database testing.
• Worked closely with the developers to perform Batch Job Testing.
• Involved in downstream ETL testing for Data Warehouse and Data Mart.
• Involved in ETL Informatica Mapping Process
• Wrote SQL queries to validate the authenticity of data in the database
• Performed the XML testing and ETL testing in Staging Database, Data Warehouse and Data Mart
• Executed the automation scripts using Quality Center. Created test cases and tested Web based and consumer applications, using manual and automation tools like HP QC/ALM and QTP.
• Involved extensively in User Acceptance Testing (UAT).

Environment: Informatica Power Center 9.1.0, ALM/Quality Center 11.52/12.50 , JIRA, VB Script, Agile, Microsoft SQL 2012, MS Office 2010.

Confidential, NC

ETL SQL Tester

Responsibilities:

• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing
• Maintain, backup and restore the Informatica ETL repositories for the QA team.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
• Developed, executed, and maintained Test Plans, Test Case, Test Scripts, and Test Data for manual testing approaches using track & defect management tool HP Quality Center (QC).
• Involved in Manual Testing, Functional testing (Black Box Testing),
• Created Manual Test Scenarios and Test Scripts by analyzing Functional, Business and Technical Requirements.
• Worked on SQL Tools like Toad and SQL Server Management Studio to run the SQL Queries to perform manual test in regular basis and validate the data.
• Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts
• Installed, administered and updated Oracle database tools and systems.
• Conducted SQL Server production database analysis on a regular basis.
• Extensively used SQL queries to check storage and accuracy of data in database table
• Worked on trimming the SQL and optimizing the SQL by using various VLDB settings in the MSTR to avoid the cross join and removing multiple passes
• Thoroughly analyzed the functional requirements documented in the Software Requirements Specifications to develop the corresponding test cases in Mercury/HP QC.
• Performed on Agile to emphasize face-to-face communication over written documents.
• Used HP Quality Center/ALM, QTP, SoapUI for tracking and reporting for Internal High Level access and also to create reports and update bug status
• Participated in Defect assessment meeting.

Environment: Informatica Power Center 9.0, SQL, Quality Center 9.2, Jira, Agile, UNIX, shell scripting, MS Excel, Powerpoint, Mac OS X.

Confidential, Nashville, TN

ETL SQL Backend Tester

Responsibilities:

• Gathered, refined, and prioritized business requirements from business owners through meetings and questionnaires.
• Initial testing was conducted manually, and later phase was executed using Mercury Tools.
• Developed Test cases from Requirements, Functional Specifications and Design Documents and executed them manually in Quality Center.
• Experience in using SOAP Sonar for providing simple, intuitive and comprehensive testing for SOAP-, XML- and REST-based services
• Selected and implemented agile development practices according to the application requirements for every project
• Designed and coded application components in an agile environment utilizing a test-driven development approach.
• Extensive Agile and Scrum experience. Responsible for delivering agile projects that provide exceptional business value to users.
• Experienced in data analysis using SQL, PL/SQL and many other queries-based applications.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Performed extensive Database Testing by writing complex PL/SQL Queries in TOAD to test different scenarios of the application
• Worked with ETL group for understating mappings for dimensions and facts
• Tested ETL process to push the transactional data from the normalized data structure into the data marts.
• Tested SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data and verifying the ETL mapping rules
• Worked with ETL group for understating mappings for dimensions and facts.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Backend and Database Testing: Oracle, MS-SQL Server, MS Access databases.
• Performed data validation testing of production defect using SQL and resolving and testing back end process.
• Developed Requirements Traceability Matrix (RTM) to track requirements during the QA Testing Phase using Quality Center.
• Write SQL Query to extract data from various database tables for testing purpose.
• Leveraged the test management features of Quality Center for System Testing, UAT and Regression Testing.
• Involved heavily in Database Testing. Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.

Environment: Informatica Power Center 8.6.1, Quality Center 9.0, VB Script, HP ALM, SQL, XML, and MS Office.

Confidential, Baltimore, MD

ETL SQL Tester

Responsibilities:

• Involved in analyzing System Requirements and developing test plans for Functional and Regression testing.
• Involved in writing test cases and test plan for the system application.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Tested many complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Conducted extensive database testing, passing SQL queries to the Oracle using TOAD, Solved queries using SQL
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables
• Extensively executed T-SQL queries to view successful transactions of data and for validating data in Sql Server Database.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records
• Created automated scripts using Quick test pro and developed test suites to execute the scripts using Quality Center. Documented problems found during test on the Quality Center system and communicated recorded problem to the responsible QA Manager.
• Conducted manual testing for checking Functionality, Security, and Performance testing during the various phases of the development of the online application.
• Used SQL to perform Backend Testing, Involved in Load Testing and Regression Testing using Load Runner.
• Involved in User Acceptance Testing (UAT).

Environment: Informatica Power Center 8.0,Quick Test Pro 8.0, ALM, Quality Center 8.0, Agile, SQL, Oracle, MS Office, Windows NT, UNIX platform.