PROFESSIONAL SUMMARY:

• Around 6 years of excellent IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Data Warehouses using ETL & Business Intelligence solutions, UNIX, OLAP for multiple domains.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from heterogeneous sources into Data warehouse using ETL Tools.
• Proficient in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Experience in testing and writing SQL and PL/SQL statements.
• Expertise in utilizing Oracle utility tool like SQL*Loader and Toad for developing Oracle applications.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Having good knowledge about Selenium.
• Very good Experience in ETL tools like Abinitio and Informatica
• Strong technical Knowledge of UNIX Utilities, shell Script to automate process.
• Extensively involved in Data - centric testing to test the data completeness, data integrity, data validation, data quality of the data as it is extracted from source and loaded into target.
• Experienced in Source to Target Testing to validate the data before and after it passes through the transformation/mappings are exactly same and to test if the values before transformation and after are corresponding to the expected values.
• Experienced in creating the SSIS packages, DTS packages.
• Involved in application upgradation testing during which, data validation was performed to test if the data from the older application was same as the data loaded into DB through new application.
• Involved and implemented various phases of testings such as integration testing, system testing, regression testing, performance testing, operational testing of the mappings, jobs and sessions atat are involved in extraction, transformation, and loading of data from source to DWH.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging, Data integration of operational sources using ETL processes.
• Experience in all phases of Software Development life cycle.
• Excellent communication skills, Good organizational and interpersonal skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.0/8.6/8.1/7.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS, DataStage 8.X

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2 9.0/8.0, Teradata

Languages: SQL, PL/SQL,, Visual Basic

Tools: Toad, SQL* Loader, WinSQL, Teradata SQL Assistant 6.0, SoapUI

BI Tools: OBIEE, Business Objects XIR2/XIR3, SSRS,Cognos and Hyperion, Microstratergies

Testing Tools: QTP, Quality Center 10.0 / 9.2, Selenium, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL Tester

Responsibilities:

• Tested the ETL process to automate the testing process and also load the test data into the testing tables.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Reported debuging using informatica and tracked defects using Quality Center/ALM.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Writing complex SQL queries for data validation for verifying the Informatica Packages and business Rules
• Tested the Front-End Web Applications developed in J2EE for data portal for matching.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested WebServices /XML / SOAP and RESTFul services using SoapUI tool .
• Validated WSDL, request and response XML. Added Assertions to validate the response xml with database.
• Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Strong ability in developing advanced and complex SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Written several complex SQL queries for validating Business Objects Reports.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Responsible for verifying the log files using UNIX and database for the submitted application.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Involved in developing Test Automation Framework for the application using Selenium WebDriver
• Worked with Data Conversion projects for testing data quality after migration.
• Used SQL Loader for data retrieval and querying.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Production reconciliation was performed before the deployement of the developed application to the production systems to ensure that the data is being processsed efficently and to test the correctness of the data.
• Tested reports based on the statistical analysis of the data from various time frame and division using SQL Business Objects
• Tested all Business Objects Dashboards according to the requirement
• Validate the business functionality usingUATTesting

Environment: Informatica 9.0/8.6, SQL Server 2008, Teradata SQL Assistant, Teradata V2R6, Business Objects, Quality Center 10.0/ALM, Selenium, SoapUI, Oracle 10g / 11g, Agile, UNIX, Jira.

Confidential, Richmond, VA

ETL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Used Quality Centre for tracking the defects.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base
• Responsible for testing packages using Informatica (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
• Tested various operational Drill-through and Drill-down reports using Business Objects
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Tested the outgoing links from all the web pages from specific domain.
• Involved in Implementing Agile (Scrum) methodologies for the complex project modules.
• Tested and worked on creating open document reports for business.
• Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures, Reporting and Tracking the defects.
• Interacted with Users to understand the bugs in Business Reports generated from Business Objects
• Tested existing Data web application from classic ASP and VB6.0 to VB.NET, ASP.NET, C# (.NET Framework 3.5), SQL Server 2005.
• Developed automation test scripts using Selenium Web Driver and Java.
• Worked on REST Webservices both as a standalone testing and through client side.
• Tested WebServices by providing required input data to request XML and get the requireddata from response XML.
• Coordinated and Interacted with Development team and actively participated in status meetings during the defect life cycle, reported the bugs and maintained their status.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Extracted data from various sources like Oracle, flat files and DB2.
• Tested SCD tables Type 1, Type 2 and Type 3.
• Experience in loading from various data sources like Teradata, Oracle,Fixed Width and Delimited Flat Files.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.

Environment: Informatica, Business Objects, Quality Center 10.0, Selenium, SoapUI, Teradata SQL Assistant, Agile,Unix, Autosys, Oracle9i / 10G, Jira.

Confidential, Arlington, VA

ETL QA Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Involved in Data Extraction from Teradata and Flat Files using sql assistant
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Worked in an Agile technology with Scrum
• Written several UNIX scripts for invoking data reconciliation
• Reported bugs and tracked defects using Quality Center
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Enhancing the QTP QuickTest Pro Scripts with GUI checkpoints, Database Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Experience in loading from various data sources like Teradata, Oracle,Fixed Width and Delimited Flat Files
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Tested Cognos reports to check whether they are generated as per the company standards
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center, Cognos 7 Series, QTP, Oracle 8i, SQL Server, Agile, SQL, PL/SQL, Unix, Quality Center, and TOAD .