SUMMARY

• Around 7 years of focused experience in IT Industry with a strong back ground in testing of Client Server and Web based applications.
• Having good knowledge in Software Development Life Cycle SDLC Software Testing Life Cycle STLC which includes Requirement Gathering, Data Analysis, Application Design, Implementation and Testing of various applications.
• Strong knowledge in life cycle of Data Warehouse using Data Extraction, Data Transformation and Data Loading processes ETL and having profound knowledge in Dimensional modeling techniques Kimball and Inmon , Star and Snowflake schema addressing Slowly Changing Dimensions SCDs .
• Experience with structured QA Methodology and QA Process to ensure the Quality Assurance Control. Experience in ETL testing using tools like Informatica Power Center 9.0.1/8.6.1 and reporting tools like SAP Business Objects X1 3.1, IBM Cognos 8.4.
• Experience in integration of various data sources like Oracle, IBM UDB DB2, MS SQL Server, XML and Flat files.
• Worked on Test tools like Mercury HP Quality Center/Test Director and having knowledge on automated tools like QTP 9.2, HP Load Runner 9.5, Win Runner, Quick Test Professional QTP and Rational Clear Quest.
• Experienced in creating Traceability Matrix, Test plans, Test design, Use cases, Test cases, Test procedures, Test log, Test Scenarios, Automated Test scripts, Defect reporting and Documentation for both Manual and Automated Testing.
• Having hands on experience in client/server and web applications using White Box, Black Box, Functional, Unit, Integration, End to End, UAT Acceptance testing, Smoke Testing, Deployment Testing, Performance Testing and Regression Testing.
• Expertise in RDBMS backend testing for data validation of the business rules to ensure data integrity using SQL Assistant.
• Experience in writing simple and complex SQL queries using TOAD, Squirrel SQL and Oracle SQL Developer/Navigator.
• Write complex SQLs to validate the transformation and data cleansing rules defined in data mapping documents
• Report testing on Cognos Report Studio, Query Studio
• Excellent working knowledge on UNIX environment and unix commands.
• Experience of testing on heterogeneous datawarehouse environments like Oracle, SQL Server, Teradata and Netezza.
• Experience in design/testing and implementation of stored procedures, triggers and functions at database level using PL/SQL.
• Executed negative and positive test cases to test application functionality against user requirements.
• Experience in creating and scheduling jobs using Autosys, TWS Scheduler and Control-M.
• Experience in executing shell scripts for testing in UNIX environment.
• An excellent team member with an ability to perform individually with strong verbal, interpersonal and written communication skills.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows -NT/XP/Vista/ Windows 7, UNIX, LINUX

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Power Mart 5.x

Reporting Tools: SAP Business Objects XI 3.1 Designer, Desktop Intelligence, Web Intelligence, Info View, Central Management Console, Import Wizard , IBM Cognos Framework Manager 8.x

Languages : C, Java Script, VBScript, SQL, .Net, VB, UNIX, Shell Scripts

Databases : Oracle, DB2, MySQL, SQL Server 2000, MS Access-2000

Web Technologies : HTML, DHTML, XML

MS Office : Word, Excel, Access, Power point, Outlook

Testing tools : QTP, Selenium, SoapUI, IBM Robot, Win Runner, Quality center, Bugzilla, Jira

Work Summary

Confidential

ETL QA Tester

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested design strategy of the Extract, Transform and Load for various ODW tables.
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules.
• Written test cases and completed unit test documentation.
• Used Unix environment variables in various .ksh files which comprises of specified locations to build Ab Initio Graphs.
• Involved in pager rotation program to support 24 x 7 production support.

Environment: Informatica 8.6.1, Business Objects XIR3, Teradata SQL Assistant, Quality Center 10.0, Unix, UDB DB2, TOAD, WinSQL, Putty, SQL PL-SQL, Windows 2000/XP, MS Office, Visio, Perl, Shell Scripts, XML, XSD, Maestro 8.5, XML Spy 2010, CSV Files, XML Files, VSAM COBOL Files, JCL, MVS, ISFP, Main Frame

Confidential

ETL Tester

Responsibilities:

• Involved in Analysis and ETL testing of various Enterprise Data Warehouse and Business Intelligence applications.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
• Created ETL Test plans and Detailed Test cases based on business requirements.
• Developed ETL test scenarios based on test plans. Scenarios covered the constraint validation, Structural validation, Data transformation and all the data completeness issues.
• Conducted the Structural validation testing on source target table structure, check field to field mapping on the Informatica Power Centre 9.1 including the check on data types, length, column names on both source and target tables, field types formats.
• Generated the test data to perform the Transformation testing, Validation testing, Dependency testing based on the DMLs and Record Formats.
• Analyzed Source qualifier, Update strategy, Filter, Router, Joiner, Sort and Rank transformations using Informatica Power Center to perform Transformation testing.
• Validated data flow from source to target, including the staging tables .
• Extensively used TOAD to test various ETL process flow whether they meet the Business rules and Technical Requirements.
• Worked with the workflow monitor to check the session logs to locate if any errors occurred with Records update to Target.
• Extensively worked on validating data loads during the ETL process.
• Focused on Data Quality issues/Problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Reported weekly status report, documented defects as testing is in progress.

Environment: Informatica power center 9.1, Oracle11g, Quality Center 10.0, SQL Server 2008, TOAD, UNIX Shell Scripts, Erwin 8.0, Business Objects

Confidential

ETL Tester

Responsibilities:

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Executed and scheduled tasks batch processing, metadata management and data mapping.
• Responsible for setting timelines and reaching deliverables.
• Facilitated meetings with business users, Project Managers, and IT personnel.
• Responsible for data analysis, business/systems analysis ETL process documentation user requirements/ functional specs technical specifications.
• Created ETL documents detailing the ETL database navigation and data transformation logic used by developers as coding specifications.
• Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
• Reviewed specifications for feasibility of customer list pull criteria and commit date.
• Executed Campaign based on customer request and reviewed execution log to keep track of the number of records going into and coming out of every job step.
• Created waterfall reports to show total lead pull, number of records dropped as result of each suppression or set of suppressions.
• Delivered file in various file formatting system ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.
• Followed company code standardization rule.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
• Worked with T-SQL for validating the SQL Server 2000 data.
• Worked intensively with indexes to tune the query, exploited the B-tree and Bitmap index functionality of oracle to get the better performance.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings.
• Involved in complete life cycle activities like pre-testing phase and testing phase.

Environment: Informatica Power Mart 5.1, Erwin, Visual Safe Source, SQL Server 2000, MS Excel, T-SQL, SQL, PL/SQL, TOAD, Test Director, Oracle 8i, Windows 2000, UNIX, Shell Scripting Korn

Confidential

QA Tester Responsibilities:

• Prepare test cases.
• Testing System, Regression, Report, Performance .
• Handle Team Communication.
• Ensure end to end Data Consistency and Integrity across different layers of Data warehouse DRA-Data Reception Area, DSA- Data Staging Area, ODW- Orbit Data warehouse ALD-Aggregate Layer Data mart making use of ETL tool OWB.
• Perform duplicate, count, incremental data checks on source and target.
• Run ETL jobs on OWB Oracle Warehouse Builder .
• Write complex SQLs to validate the transformation and data cleansing rules in Data warehouse.
• Train project team members on technologies implemented business functionalities in the project

Environment: OWB, Oracle, Toad, SQL/PLSQL, HP Quality Center, Unix.