SUMMARY:

• Overall 5+ years of overall experience in Information Technology Industry as ETL Tester on various platforms.
• Experience in Utility and Retail sector.
• Experience on Unit Testing, Smoke Testing, Functionality Testing, Integration testing, GUI Testing, System Testing, Regression Testing, Sanity Testing, Performance Testing, Database Testing, User Acceptance Testing (UAT), Compatibility Testing and Product Assurance Testing for web based and Client/Server applications.
• Highly experienced in performing data quality test, data correctness test, data consistency test and process interdependency tests to determine whether processed data is correctly extracted, transformed, and loaded.
• Extensive experience in writing complex SQL queries and PL/SQL scripts to validate the database systems and for backend testing.
• Extensive ETL testing experience using Informatica, Power Center (Designer, Workflow Manager, Workflow Monitor and Repository Manager)
• Experience in writing and executing UNIX Shell scripts to schedule and automate tests.
• Experience in writing test scenarios, creating test plans, and test cases and debugging skills.
• Experience in creating manual test cases from requirements, design, specification and process flow diagrams.
• Experience with various databases including MS SQL Server, Oracle, Sybase, IBM DB2, and Teradata.
• Worked with various teams from ETL perceptive to come up with processes in dev/qa/prod for extraction, transformation and loading the data into the data marts.
• Extensive knowledge with dimensional data modelling, star schema/snowflakes schema, fact and dimension tables.
• Experience in Data Analysis/Data Profiling and Data Governance.
• Experience in complete project life cycle including documentation, analysis, and development and testing.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center, Test Director, Rational Rose, Rational Clear Quest

Bug Reporting Tools: Quick, Test Pro, Load Runner, Winrunner, Toad

Test Management Tools: Quality Center, Microsoft Test Manager

Databases: MS SQL Server, Oracle, MS Access, DB2

Languages: C, C++, SQL, PL/SQL, XML, Stored Procedures, HTML

Query Tools: TOAD, MS SQL Server Management Studio, SQL Analyzer, SQL+, My SQL

Operating Systems: LINUX, UNIX, Windows

Other Tools: MS Office Suite (word, Excel, Power point, Visio), TFS

PROFESSIONAL EXPERIENCE:

Confidential, Juno Beach,FL

QA Analyst

Responsibilities:

• Designed and created Test Cases based on business requirements.
• Conducted source - system data analysis to understand current state, quality and availability of existing data.
• Validated that design meets requirements and function according to technical and functional specifications.
• Performed extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Used HP Quality Center 12.21 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Documented and reported various bugs during manual Testing.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Executed Test Cases with respect to Source and Target database tables.
• Mapping test cases to requirements.
• Creating mappings using different transformations to integrate data from form various sources and load.
• Created Test Execution summary report and got approval from all stakeholders.
• Responsible for parameter file validation testing.
• Determined the Sprint scope by working to establish acceptance criteria for User Stories, estimating the level of complexity within each User Story, and detailing a preliminary set of tasks for each User Story.
• Designing Data Modeling and Loading data from Multiple Datasources.
• Expert in Business Intelligence Applications using Cognos Tools such asCognos10.1/8, QLIK.
• Excellent hands on experience in handling the defects throughout the bug life cycle from detection until resolved using JIRA.
• Knowledgeable on SDLC methodologies, especially agile scrum and waterfall, at the system
• Analysis, design, development and implementation stages.
• Capable of using data from SQL server, ORACLE, Excel, CSV files and FLAT files.
• Extensively tested several Cognos10 and QLIK reports for data quality.
• Worked with various teams from ETL perceptive to come up with processes in Dev/QA/Prod for extraction, transformation and loading the data into the data marts.

Environment:- HP Quality Center 12.26, Informatica Power center 9, Business Objects, Oracle 11G, SQL Server 2008, Flat Files, SQL, UNIX, QLIK, COGNOS, Winscp, Windows XP/8.1/10, MS office suite

Confidential, Houston, TX

ETL QA Tester

Responsibilities:

• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the database in UNIX environment for testing the business rules imposed on data movement.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Executed backend data-driven test efforts with a focus on data transformations between various systems and data warehouse.
• Implemented effective data quality testing standards, verification procedures and tools.
• Implemented SCD I, II to the extracts based on the business requirement and client expectations.
• Performed batch sequence and dependency testing for ETL mappings.
• Responsible for parameter file validation testing.
• Used minus query for comparing source and target records.
• Tested transformation and business rules for ETL mappings.
• Performed all aspects of verification and validation.
• Worked with other member of Quality Assurance and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency.
• Involved in running the ETL loads in development server.
• Created all test plans and cases updated to changing requirements
• Written SQL queries to define, identify and validate the code written for the data movement into the database tables.
• Developed PL/SQL procedures and triggers. Tested ad hoc and canned reports for business objects.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Worked in Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Created rules, mapplets, mappings using transformations like standardizer, match, parser, labeler and joiner, profiles and scorecards in IDQ developer and Analyst.
• Used IDQ to create rules and mappings using transformations like Aggregator, Expression, Exception, Joiners, Labeler, Match, Parser, Standardizer.
• Strong experience in developing DQ components like Data Objects, Quick Profiles, Custom Profiles, Creating and executing scorecards.
• Retesting the resolved defects/issues after the developers fix the defects.
• Manual verification of data in the backend using SQL.

Environment:- Informatica 9.6.1,8.6, IDQ, Business Objects, Oracle 11G, Teradata 12.0, Teradata SQL Assistant, SQL Server 2008, Flat Files, PL/SQL, TOAD 8.0, SQL, UNIX, HP Quality center 10, IBM AIX 6.1.

Confidential, Houston, TX

QA Analyst

Responsibilities:

• Participated in requirements analysis, project definition, analysis and scoping activities associated with the SLD project
• Collaborated with QA staff on using documentation standards in the development and review of test plan and test cases.
• Validated the most granular data items against OLTP systems and identified the source tables from which the data warehouse extracts data.
• Extensively worked with backed activities by writing complex SQL queries for testing several reports developed by BI tools.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Excel.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development teams.
• Created UNIX scripts for file transfer and file manipulation.
• Tested whether the report developed in Business Objects BOXI are as per company standards.
• Validated the base table (Star schema-Fact and Dimension) by writing complicated SQL statements and reports.
• Performed count validation, duplicate validation, data validation, null validation, Referential integrity testing.
• Tested mappings involving SCD Type 1, Type2 and Type 3 scenarios.
• Used UNIX commands like cmp, diff, wc for checking number of lines in files and comparing files.
• Extensively tested several Cognos reports for data quality.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Exclusively worked on Informatica Mappings testing and developed small graphs to copy data and join multiple source tables for testing purpose.
• Involved in testing of Informatica mapping & UNIX script testing for efficiency improvement of loading process.
• Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Tested complex ETL Mapping and session based on business user requirements and business rules to load data from source flat files and RDBMS tables to target Tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extensively
• Tested BOXI reports for data accuracy and static errors.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica jobs.
• Tested the ETL AB Initio graphs and other ETL processes (Data Warehouse Testing)
• Worked in 24×7 execution support for the pre-production support in UTA team.
• Executed Batch jobs in UNIX as background process.
• Involved in System Integration Testing and amp; user acceptance testing.
• Involved in testing the functionality of Informatica jobs.
• Performed data analysis using match and consolidation transformations in IDQ (Data Quality)
• Used Informatica Power Center to create ETL process using various transformations like Aggregator, Filter, Lookup, Normalizer, Router, Union, Update Strategy, and mapping parameters and variables.
• Involved in data profiling using IDQ (Analyst tool) prior to data staging, applying the business rules to identify the bad records and reporting them to the business.
• Worked with the QA and project Managers to set and evaluate milestone criteria to ensure released products are on schedule with high quality.

Environment: Oracle 9i10g, SQL, PL/SQL, UNIX, IDQ, Use Cases, Cognos and business objects BOXI reports, Informatica 8.6, Quality Center, Teradata, Teradata SQL Assistant, TOAD, Autosys, SSIS, SSRS, SQL server 2008, Windows XP/8.1/10, MS Projects, MS Visio, MS office suite, Rational Clear Case, Rational clear Quest.

Confidential, Conway, SC

QA Tester

Responsibilities: 

• Wrote SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Participated in meetings with Business Analyst and Design review meetings with the Developers for better understanding of the modules.
• Prepared test plans, strategies and estimations.
• Wrote various UNIX SHELL SCRIPTS for file manipulation, data parsing, text processing, job scheduling and cleanup needs.
• Source to target requirements, ETL map specifications and business requirements were referred to write precise test cases.
• Conducted walkthrough with business and development team to get approval of the test cases.
• Performed smoke test to make sure all the test environment is set and executed the test cases in Quality Center.
• Used Quality Center to log the defect and fallow the complete cycle.
• Conducted status meetings with Development Team and Quality Assurance Team to discuss and resolve the issues reported in Quality Center.
• Involved in developing, debugging and executing UNIX shell scripts.
• Performed regression testing and negative testing of the application once the defect is fixed.
• Wrote and executed test scripts and test cases for different source to staging, staging to accredited and accredited to data warehouse data flows.
• Participated in functional and design review meeting of conversion components.
• Participated in meeting on peer review of test cases on conversion components mentioned above and secured sign off on them before conversion test executed.
• Tested the above components by running the AbInitio ETL jobs in UNIX box, verified and validate the requirements as per designed and functional specs.
• Written queries, various DML, statements, applying join conditions, functions to analyze the data in the database using SQL, Server Manager.
• Wrote Sub Queries, correlated sub queries to retrieve data from multiple tables.
• Interacted with BA s, Developers, team leads to resolve the issues.
• Peer-reviewed test cases written by peers and Mentored new test analyst at onsite and offshore.
• Submitted a weekly report on test case development and execution.

Environment: UNIX IBM - AIX, Ab Initio (GDE 1.15, co-op 2.15), Oracle 10i, Mercury Quality Center, Toad, Toad for DB2, SQL, PL/SQL, XML files, Shell Scripting, PERL.