We provide IT Staff Augmentation Services!

Etl Quality Assurance Analyst Resume

2.00/5 (Submit Your Rating)


  • 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.


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



ETL Quality Assurance Analyst


  • 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.


Sr.QA /ETL Analyst


  • 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.


Sr. QA Analyst/ETL Test Analyst


  • 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.


Data warehousing Tester


  • 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

We'd love your feedback!