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.