We provide IT Staff Augmentation Services!

Etl Qa Analyst Resume

Dallas, TX

SUMMARY:

  • Lead QA Analyst consultant with 8 years of experience in Information Technology field with strong experience as Quality Analyst (Tester) in ETL Testing FunctionalTesting, Automation Testing using various testing methodology like waterfall Model, and AgileModel.
  • Experience in UNIX and SQL commands.
  • Experience includes Automation using selenium and Agile Testing (Sprint, Backlog, Scrum board maintain).
  • Experience in designing, documenting, and executing Risk Analysis, Project Plan, Test plans, Test Scenarios, Test cases bug reporting.
  • Experience in creating project related various Matrices to ensure the process.
  • Proficiency in ETL/Database Testing specifically in developing and executing SQL queries to interact with databases like Oracle 11g, Teradata, DB2, and SQL SERVER.
  • Experience in UNIX scripting, job scheduling tool UC4.
  • Expertise in use of Quality Center ALM (QC) for writing test cases, test execution, defect management (using Jira), defect tracking and Bug Reporting.
  • Experience with version control, configuration management and change control procedures using tools such as VSS, SharePoint.
  • Experience in various ETL tools like informatics, Action,AbInitio.
  • Experience in testing Big data tool like Splunk.
  • Experience with reporting tool OBIEE.
  • Experience in FIXML trading messages.
  • Experience in onshore offshore model and client interaction.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

ETL QA Analyst

Responsibilities:

  • Responsible for reviewing Requirement Specifications and Mapping Document.
  • Responsible for creating the Test Plan, Test case preparation, execution of test cases.
  • Tested and Automated Various ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the Data Mart using AbInitio.
  • Performed GUI, Functional, Regression and compatibility Testing.
  • Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
  • Involved in Test Reporting on daily/ weekly basis through company prescribed format.
  • Tested reports using OBIEE.

Skills: Linux, Windows 7, Informatica, Teradata, SharePoint server, Jira, Rally, OBIEE

Confidential, Fairfield, Virginia

Lead ETL QA Analyst (offshore)

Responsibilities:

  • Responsible for reviewing Requirement Specifications and Mapping Document.
  • Responsible for creating the Test Plan, Test case preparation, execution of test cases.
  • Tested and Automated Various ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the Data Mart using AbInitio.
  • Performed GUI, Functional, Regression and compatibility Testing.
  • Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
  • Involved in Test Reporting on daily/ weekly basis through company prescribed format.
  • Tested reports using OBIEE.

Skills: Linux, Windows 7, AbInitio, Teradata, Jira, SharePoint server, Rally, OBIEE

Confidential

Lead Consultant

Responsibilities:

  • Responsible for reviewing Requirement Specifications and Design Documents.
  • Responsible for creating inbound message FIXML for trade posting.
  • Developed and Tested Various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Tested the performance bottlenecks at sources, targets, mappings, and sessions and employed required measures.
  • Used Toad and SQLPlus for execution of ETL Processes' PL/SQL procedures, packages for business rules.
  • Tested data marts; tested the security levels and granting of appropriate roles.
  • Tested Informatics folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
  • Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the Data Mart and feeder systems in the aggregation effort.
  • Involved in Test Case Design with respect to Test Plan.
  • Involved in Test Execution and Bug Reporting using QC.
  • Performed GUI, Functional, Regression and compatibility Testing.
  • Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
  • Involved in Test Reporting on daily/ weekly basis through company prescribed format.

Skills: Linux, Oracle 11g, UC4 (scheduler), JIRA, SharePoint server, Toad, Informatica 9.5., Splunk

Confidential

Lead Consultant

Responsibilities:

  • Understanding the project requirements.
  • Interaction with onsite coordinator regarding requirements and scheduling.
  • Responsible for web services testing using SOAPUI.
  • Responsible for Functional Testing, Regression Testing, Creation of test plan, executing test cases, preparing test summary report.
  • Responsible for web testing.

Skills: Linux, Java, Windows, Web server, Eclipse, Quality Center, XML, and Bugzilla

Confidential

QA Analyst

Responsibilities:

  • Did a thorough walkthrough of business requirements and prototypes with Business Analysts, Code reviews with development team and got a good grasp of requirements, functionality of the airline system.
  • Developed Test plans by coordinating with other team members on the road map.
  • Developed test cases by reviewing the requirement documents.
  • Mapped the test scripts to the functional requirements in Quality Center 10.0.
  • Identified Test Data by querying and created Test scripts for SIT, Regression and UAT
  • Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application .
  • Execution of Manual Test scripts and responsible to track and log the defects using QC.
  • Responsible for data analysis, report validation and functional testing.
  • Automation test with Selenium scripts.
  • Worked closely with Technical Project Managers and Development Team in defect tracking, re-testing and validation.
  • Verified bug fixes and tested all impacted modules in application.
  • Coordinating with other team members and providing status to project manager.
  • Created UAT documentation to be used by users.
  • Ensure Requirements Coverage with Traceability Matrices.

Skills: UNIX, SQL, Oracle, Web Services, SOAP UI, Oracle Quality Center,Jira,QC,Selenium

Confidential

QA Analyst

Responsibilities:

  • Responsible for Extraction, Transformation, Loading (ETL) data from various sources into various targets using Informatica Power Center (Repository Manager, Designer, Workflow Manager).
  • Responsible for creating Transformations like Sorter, Router, Filter, Joinner, Sequence generator, Aggregator, Expression, Mapplets, Union and lookup in mappings.
  • Used text files, relational and XML files as sources and targets.
  • Work experience reviewing and testing of data maps between various legacy systems and relational databases.
  • Responsibility includes development /testing of applications which use integrated database using Informatica.
  • Designing, documenting, and executing test plans, test scenarios, test cases& bug tracking tools.

Skills: Mongo dB, Linux Tools - Oracle 11g, Linux, Jira, Quality Center,Informatica.

Hire Now