PROFESSIONAL SUMMARY:

• Over 8+ years of experience in the Information Technology industry, involving analysis, both Manual and Automated testing of Client Server and Web applications.
• Proficient in writing Test strategies, Test plans, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports for both Manual and Automated Testing.
• Hands on expertise in Data ware housing concepts and tools.
• Expertise in the ETL processes where in the organizations were using Data stage, Informatica, Abinitio and Autosys tools.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Blackbox, Integration Verification and Validation End to end and User Acceptance testing.
• Experienced in Agile Methodology, Proficient in Black Box and White Box testing methodologies.
• Created test plans and performed unit testing for the Ab Initio graphs.
• Possess specific experience performing Regression and Functional Testing using Quick Test Professional.
• Proficient in Mercury’s Test Director and Quality Center for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking.
• Proficient in Rational Clear Quest and Quality Center for Defect Tracking Defined and Implemented Processes and Procedures for QA Departments.
• Expertise in writing SQL Queries using Oracle, SQL Server, and Tera Data in validating data into Data Warehouse.
• Experienced in testing full and Incremental loads through ETL tools on different environments.
• Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test management tools like such as Quality Center, MS Visual Studio and TFS.
• Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/ Database Testing.
• Experience with working tools like TOAD, MS SQL Server Management studio, Win SQL for creating and executing SQL Queries.
• Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle and Bug Life Cycle.
• Testing ETL applications in relational databases and flat files using Informatica and involved in the report generation of BI systems using Crystal Reports.
• Experienced in using UNIX shell scripts for automation of ETL process.
• Experienced and good track record of testing the ETL, Data, Reporting, and End to End testing.
• Involved in testing of Business Objects reports by executing the SQL Scripts.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

TECHNICAL SKILLS:

ETL tools: Informatica 9.1/8.x/7.x, SSIS 2005, Ab Initio, Data Stage

Operating Systems: UNIX, Linux, Windows.

Database: DB2 8/7/5.1, Oracle 10g/9i, SQL Server 2008/ 2005/2000, Teradata

Scripting: Javascript, C, Shell Scripts

Programming Languages: PL/SQL, T - SQL, C, C++, Java, SQL

Utilities: MS Word, MS Excel, MS Power Point, MS Visual Studio

Bug Reporting: Quality Center, JIRA, Rational Clear Quest, Test Director, Bugzilla

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

ETL Lead

Responsibilities:

• Analyzed Business Requirements and Identified documents required for system and functional testing efforts for all test scenarios.
• Used TOAD and SQL Plus for testing execution of ETL processes, PL/SQL procedures, and packages for business rules.
• Developed all the necessary documents for testing like Test strategies, Test Plan which includes all test items and Test cases and User Documents etc.
• Maintain, backup and restore the Informatica ETL repositories for the QA team.
• Test the complete user experience for all assigned products, including input, calculations, user interface screens, payroll tax filing, quarterly reconciliation, electronic tax return filing, and tax forms printing functionalities.
• Validated the daily and monthly reports in against the data in Oracle databases.
• Reviewed manual testing methods and created and implemented an automated test strategy and generated automation scripts.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Extensively used Informatica tool to extract, transform and load the data from DB2 to Oracle.
• Extensively worked on debugging ETL process graphs.
• Conducted Functional testing, Regression testing, Integration testing, User Acceptance testing and Data Validation Testing.
• Used Agile testing methodology for achieving deadlines in UAT.
• Created Test Procedures and Test cases to perform the system testing and Regression testing.
• Worked on generating reports using SQL and PL/SQL and on tuning SQL statements.
• Worked closely with users and Application developers to ensure that application development meets to user’s expectations.
• Maintained client database, working closely with team to relationship-manage customers and maximize referrals and sales opportunities.
• Enhanced test scripts by inserting synchronization and checkpoints.

Environment: Oracle, SQL, SQL Server, Windows, Manual testing, Java, Java script, Rally, Jenkins, DB2, Data warehouse, TOAD, Quality Center, HTML, Oracle, SQL Server, Windows.

Confidential, NJ

ETL QA Engineer

Responsibilities:

• As part of QA team, is involved in implementation of ETL best practices.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
• Involved in providing production support to various Ab Initio ETL jobs and Oracle Database programs.
• Worked on a variety of scheduling tools like Argent, Autosys and Control M.
• Analyzed and verified the flat, Mainframe IMS and xml data using Ab Initio Data Profiler.
• Tested various ETL process flow graphs using TOAD to meet the Business rules and Technical Requirements.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Tested the application for web functionality and verified the online modules for broken links.
• Used Rational Clear Case to maintain the versioning and change management for the test documentary repository.
• Extensively used Oracle/ Teradata to write SQL Queries to verify and validate the Database Updates.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Developed and tested transformation functions and record formats for various input data files.
• Identified the requirements and arranged peer reviews, walk throughs and sign off meetings.
• Conducted weekly batch testing to in corporate changes in new builds.

Environment: ETL, Ab Initio, LoadRunner, Quality Center, Clearcase, DB2, Data warehouse, Control M, SOAP, XML, TOAD, FTP, HTTP, Pracle, JAVA, SQL, Windows, MS OFFICE, MS Outlook Express, SQL SERVER, PL/SQL, UNIX, Linux, Windows.

Confidential, CA

ETL QA Engineer

Responsibilities:

• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Experience in ETL Data Warehousing, database testing using Ab Initio for ETL process.
• Tested data models and data maps (extract, transform and load analysis) of the data marts and feeder systems in the aggregation effort.
• Installation of DB2 and IBM Products and Fix packs on AIX/Linux environment and Designing and configuring Client Server on AIX platform.
• Execute SQL queries in TOAD to validate back end information and compare it with the information retrieved from Data ware house Ab Initio.
• Automated and scheduled the Informatica jobs using UNIX shell scripting.
• Analyzed business rules to generate consolidated (fact/ summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and source to Target Mappings.
• Monitor security batch processing jobs in multi-platform shop via Control M and Tidal Schedulers.
• Expertise in using Configuration Management tools like Clear Case, Clear Quest.
• Performed version control of files using Clear Case.
• Expertise in using Configuration management tools like Clear Case, Clear Quest.
• Performed version control of files using Clear Case.
• Executed and managed test cases and reported bugs in Quality Center.
• Automation of the job flow and scheduling the jobs in Control M.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Tested Cognos Reports according to the business requirements.
• Imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Prepared Test cases with the complete description of requirements, uploaded test cases and report results into Test Director.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Participated in weekly status meetings, conducted walkthroughs, documented proceedings, and mentored new team members in test documentation and test case execution.

Environment: Oracle, SQL, Server 2005, SQL/PL SQL, Informatica, HTML, .NET, Javascript, VB script, Crystal, XML, HTML, SSIS/SSRS, QC, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.

Confidential, GA

ETL Tester

Responsibilities:

• Execute SQL queries in TOAD to validate back end information and compare it with the information retrieved from Data Warehouse Ab-Initio Metadata graphs from legacy source system to target.
• Used MS Access and Mercury Quality Center as test management tool to manage and organize Requirements Coverage, Test case management, Test Execution and Defect Management.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance testing and Data validation testing.
• Conducted weekly batch testing to in corporate changes in new builds.
• Automated and scheduled the Informatica jobs using UNIX Shell scripting.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
• Used Agile testing methodology for achieving deadlines in UAT.
• Executed and managed test cases and reported bags in Quality Center.
• Performed Verification, Validation and Transformations on the Input data (Text files, XML files) before loading into target database.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance testing and Data Validation Testing.
• Used Agile testing methodology for achieving deadlines in UAT.
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Prepared scripts, running tests, Analyzing results in Load Runner for Performance testing.

Environment: Control M, Ab Initio, Cognos, FTP Power Center, Power Plug, Power Connect, Windows, Oracle, SQL Server, Java, PL/SQL, Visual Basic, Java Script, Crystal, XML, HTML, QC, Outlook.

Confidential, NJ

ETL Tester

Responsibilities:

• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts and Documenting all phases of QA process
• Set up and Executed FTP sessions with the remote server using Filezilla as FTP Client.
• Responsible for System testing of Ad-Hoc Query Packages in Cognos which involved developing and execution of Ad-hoc reports and corresponding Test SQLs based on various join conditions and filters and calculations.
• Create test plan, test cases and do the Unit testing, SIT and UAT and send them to projects lead for approval.
• Maintained various versions of the documents generated during the project using Rational Clear Case
• Troubleshoot UNIX and Database related problems.

Environment: ETL, Ab inito, Control M, Cognos, Performance Center, DB2, Toad, Oracle, Mainframe, MQ Series, Unix, HTML, DHTML,XML, QTP, IIS, Apache, Quality Center.