We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

CA

SUMMARY

  • Overall 7 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center and Power mart
  • Good understanding of QA methodology and Software Development Life Cycle(SDLC).
  • Involved in analysis, design and quality assurance of Client/server and Web applications for Healthcare, Health Insurance, Banking, Retail and gaming industries.
  • Extensive experience with testing multi - Tier application architecture.
  • Developed Test Plans,Test Scenarios,and Test cases,Test Scripts, Test reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance.
  • Diverse experience in Information Technology with emphasis onQuality Assurance, Manual Testing, Automated Testing.
  • Excellent knowledge in ETLvalidation,Data Model Validations.
  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
  • Experience in Dimensional Data Modelling using Star and Snow Flake Schema.
  • Have good knowledge with Applications like Calyx point,PEGA,CALLIDUSetc.
  • Extensive experience inclient/server and web application testing usingSystem Testing,Functionality Testing(White & Black Box),IntegrationTesting,Regression Testing, Smoke Testing,GUI Testing,Data base Testing and User acceptance testing.
  • Experience in usingVisual Source SafeandCVS
  • Extensive experience withData warehouseapplications.
  • Strong experience in automating the test usingQTPand modifying the script code usingVB Script.
  • Strong knowledge inAutomationtoolQTPandQuality Center.
  • Experience in End-to-Endtesting withCMMandISOstandards.
  • Experience in BPT (Business Process Testing)by using QTP
  • Expertise in Problem solving and Bug Reports using Bug TrackingTools.
  • Strong skills in backend (in both Relational & Hierarchical database) testing. WritingSQLqueries, generatingreportsto ensure data integrity and validating business rules
  • Experience in working with Databases and using SQL, SQL Server, Oracle
  • Good Knowledge in design/testing and implementation ofstored procedures,triggersandfunctionsat database level usingPL/SQL
  • Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, COGNOS and Business Objects.
  • Ability to handle multiple tasks and work independentlyas well as in a team.
  • Good team player with excellent writtenandverbal communication, interpersonal skillsand ability to work independently and deliver on time.

TECHNICAL SKILLS

Testing Tools: Quality Center, Quick Test

Languages: SQL, PL/SQL

Operating Systems: Windows UNIX

Methodologies: SDLC, Agile

Databases: Oracle (SQL PLUS), SQL Server, MS Access

Data warehousing Tools: Informatica, Business Objects, COGNOS, OBIEE

Office Software’s: MS Office (Word, Excel, PowerPoint). MS Project.

PROFESSIONAL EXPERIENCE

ETL QA TESTER

Confidential, CA

RESPONSIBILITIES:

  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Extensive experience in Business Intelligence reporting tools using Cognos Series, Power Play, Transformer, Impromptu Web Reports (IWR).
  • Involved in testing the Cognos reports by writing complex SQL queries.
  • Extensively used SQL, PLSQL to create complex queries, SQL Override, Stored Procedures, and Triggers.
  • Designed, stored procedures using PL/SQL and tuned SQL queries for better performance.
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • SQLNavigator is used to perform manual test in regular basis. Oracle is used in this project to writeSQL queries.
  • Followed waterfall and AGILE methodology and adhered to strict quality standards in requirement gathering.
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Raised defects in HP Quality Center defect tracking system.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defect’s module.

ENVIRONMENT: Informatica. Cognos, SQL, Oracle, AGILE, Hp quality center.

ETL QA TESTER

Confidential -PROVIDANCE, RI

RESPONSIBILITIES:

  • Responsible to design, develop and test the software (Informatica, PL SQL, UNIX Involved in Unit testing and integration testing of Informatica mappings.
  • Proficient with Informatica
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
  • Lead Cognos architecture design and implementation
  • Installation, monitoring, and updates of a Cognos environment (Windows and/or Linux)
  • Created TPT to transfer the data Oracle system to Teradata.
  • Strong knowledge in troubleshooting the issues related to Unix, Teradata and Data Stage
  • Excellent in writing SQL and PL/SQL queries and UNIX shell scripts to perform Backend testing
  • Have programming skills in SQL and PL/SQL and experience in SQL Server and Oracle databases on UNIX and Windows platforms.
  • Used Quality Center to maintain Test Case and Reports Repository.
  • Experience working with Agile Development
  • Ongoing role within a small agile software product development team.

ENVIRONMENT: Informatica, Cognos, Oracle, SQL, Quality Center

ETL QA TESTER

Confidential, Chicago, IL

RESPONSIBILITIES:

  • Strong testing Quality Assurance experience within Agile environment
  • Configured Quick Test Professional with Quality center
  • Modifying and executingtest scriptsfora web-based environment-usingQuality Center.
  • Design and d Tested of OBIEE RPD layer, dashboards and reports
  • Tested all OBIEE Dashboards according to the requirement
  • Tested Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Tested Designed OLAP Cubes using SSAS.
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Strong in SQL preparation in Oracle
  • Good working experience in Databases like MS SQL, Oracle
  • Any Data Profiling Tool (Ex: Data Flux, Informatica Data Explorer, Data Quality) and Advanced Teradata SQL
  • Managed all the QA processes in anAGILEdevelopment environment andleada small team of QA personnel in all the testing efforts of the Products in the Organization and reported directly to the Executive Vice President of Operations

ENVIRONMENT: Quality center, OBIEE, SSAS, Oracle, SQL, Agile.

ETL QA TESTER

Confidential

RESPONSIBILITIES:

  • Tested Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
  • Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
  • Well versed with automated testing for Abinitio
  • Understand various security models for Linux and Abinitio
  • Experience in working testing through Informatica, Oracle, Informatica MDM and Data quality projects
  • Experience with relational database products and query tools such as Oracle SQL Developer and basic SQL coding skills
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Tested complex SQL queries for data validation for verifying the ETL Mapping Rules.
  • Manage and maintain Cognos Frameworks
  • Create COGNOS projects, logical data marts and table structures; define attributes, dimensions, hierarchies and Strong SQL/PLSQL Knowledge
  • Hands on experience on UNIX and Create, execute complex SQL queries to perform data completeness, correctness, data transformation and data quality testing for source to target mapping within the data warehouse
  • Wrote UNIX Shell Scripts and pm cmd command line utility to interact with Informatica Server from command mode.

ENVIRONMENT: Quality center, Abinitio, Oracle, SQL, Cognos, UNIX.

Hire Now