Etl Quality Assurance Analyst Resume
SUMMARY
- Over 10 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 domain.
- AWS Cloud Practioner Certified.
- Expertise in understanding Business/Functional/technical requirements and compliance rules.
- Experienced in writing test plans, test cases and test scenarios.
- Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
- Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
- Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
- Expertise in Data Analysis, Understanding inDimensional Data Modelling, Data Extraction, Transformation& Loading (ETL), Cubes and End User Reports.
- Good Understanding on Star Schema Modelling, Snow - Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modelling.
- Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
- Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
- Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
- Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
- Experienced infunctional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing.
- Advanced user in using Test management tools like HP Quality Center/Test Director,JIRA.
- Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2008/2005/2000/7.0/6.5 , IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases.
- Prepared and loaded test data in different environments for different testing needs.
- Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
- A good team player with excellent written and verbal communication skills.
- Excellent problem solving skills with a strong technical background and good interpersonal skills.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center9,8.5.1(Designer, Workflow Manager, Workflow Monitor,)AbinitioGDE, Data Stage, Control-M.
OLAP Tools: IBM Cognos v9, SAP Business Objects 2010/2008/XIR2, Microstrategy 8.0
Data Modelling: Erwin, Microsoft Visio, Rational Rose (UML), ER Studio
Operating Systems: Windows NT/2000/2003/XP, UNIX, Solaris and MSDOS
Databases: Oracle 11g/10g/9i/8i, SQL Server2008/2005,DB2, MS Access, Teradata V2R5, TOAD DB2, MongoDB
Testing Tools: Rational ClearQuest, Test Director, JIRA, HP ALM & Quality Center 9.0/9.2/10.0 , Doors, QTP Automation. SOAP Web services.
Languages: XML, SQL, PL/SQL, C,C++, VB, Java Script
PROFESSIONAL EXPERIENCE
Confidential
ETL Quality Assurance Analyst
Responsibilities:
- Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
- Data Modeling, Data Analysis for OLTP and OLAP systems.
- Participated in analysis of Business and functional requirements.
- Interacted with Business users to determine User requirements and goals.
- Tested of complex mappings using slowly change dimension (SCD) Type I, Type II and Type III involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
- Entered new bugs and maintained the current status of those bugs.
- Responsible for communicating Defect Status Reports to business in project meetings.
- Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
- Strong ability in developing advanced 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.
- Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
- Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
- Responsible for creating the Requirements Traceability Matrix.
- Developed Test Strategy, Test plans and Test scenarios using MS Word and MS Excel.
- Developed Test Cases and Test Scripts for System and UAT Testing.
- Performed Positive and Negative Testing for many scenarios and applications.
- Testing the source and target databases for conformance to specifications.
- Conditional testing of constraints based on the business rules.
- Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
- Tested the Oracle SQL testing programs and tested the Oracle Applications and Portals like Executive Dashboard, lookup built on Oracle.
- Conducted review sessions on test case and regression test scripts in Quality Center.
- Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
- Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
- Tested several UNIX Korn Shell scripts for ETL data loading
- Extensively used SQL queries to check storage and accuracy of data in database tables.
- Used SQL for Querying the Oracle database.
- Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
- Tested whether the reports developed in Cognos are as per company standards.
- Tested different detail, summary reports and on demand reports using Report Studio.
- Reported bugs and tracked defects using Quality Center 10.
- Worked with business team to test the reports developed in Cognos.
- Personalized Cognos Connection for specified display options for testing regional options and personal
- Information; Also written several complex SQL queries for validating Cognos Reports.
Environment: Ab Initio CO>OP GDE 3.0.4, Oracle 11g&10g, TOAD DB2,Data Stage, Informatica, UNIX, MDH, Cognos 8.0 Series, XML, Test Matrix, Control-M, HP ALM, IBM Clear Quest.
Confidential
Sr.QA /ETL Analyst
Responsibilities:
- Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
- Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
- Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
- Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
- Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
- Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
- Exported Requirements, test plans and test cases to QC 9.2.
- Created Traceability Matrix to ensure that all requirements are covered in test cases.
- Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
- Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
- Worked in Agile methodology during application development and participated in daily scrum meetings.
- Developed user defined functions, created objects where required and used descriptive programing to automate.
- Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
- Tested several data validation graphs developed in Ab Initio environment.
- Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
- Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting Test cases, Test Scripts in Quality Center 9.2
- Created defects, manage defect reports and defect status in Clear Quest tool
- Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
- Developed and ExecutedSQL statementsinToadto retrieve data and to validate data.
- Tested data migration to ensure that integrity of data was not compromised.
- Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
- Responsible for documentation of test results, test matrix,andparticipated in daily/weekly QA meetings.
- Conducted down test and up test for release builds pushed to UAT and to Production.
Environment: Informatica PowerCenter,Oracle 10g,MS SQL,HP Quality Center 9.2,TOAD, Business Objects, MS Excel, MS Project, Control-M, Cognos and IBM Clear Quest.
Confidential
Sr. QA Analyst/ETL Test Analyst
Responsibilities:
- Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
- Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
- Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
- Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
- Experienced in writing complex SQL queries for extracting data from multiple tables.
- Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
- Testing the ETL data movement from Oracle Data mart to Teradata Data mart on an Incremental and full load basis.
- Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
- Tested whether the reports developed in Business Objects and Crystal Report is as per company standards.
- Tested Ad-hoc reports, drill down and drill through reports using Business Objects.
- Tested different detail, summary reports and on demand reports.
- Involved in pre and post session migration planning for optimizing data load performance.
- Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.
Environment: Informatica PowerCenter8.6, MS SQL 2000, Oracle 9i, SQL, PL/SQL, Windows XP and 2000,Business Objects, Crystal Reports, Quality Center.
Confidential
Data warehousing Tester
Responsibilities:
- Analyzed business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
- Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
- Scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
- Written Test Cases to cover overall quality assurance testing.
- Performed manual testing on different modules of the application.
- Performed data integrity testing by executing SQL statements and manually verifying the contents.
- Used SQL to perform Backend Testing on databases.
- Involvedin supporting the deployment of data marts and reports.
- Performed manual testing prior to automate testing on the application.
- Scheduled and monitored transformation processes using Informatica Server Manager.
- Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
- Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
- Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.
Environment: Informatica Power Center, Oracle 9i, PL/SQL, SQL*Loader, XML, XSLT, XSD, MVS, SQL, PL/SQL, HTML, Windows NT/2000