We provide IT Staff Augmentation Services!

Qa Analyst Resume

Marlborough, MA

SUMMARY

  • Total experience of 6.8 years in ETL DWH/BI Cognos/Big Data - Hadoop/Integration testing in Retail and Transportation domain
  • Experience in test designing, verification, validation, testing techniques for ETL applications
  • Experience in the software delivery process by reviewing functional and design specifications, develop and review test cases, coordinate efforts and communication with the developers and other team members to ensure resolution of defects, and manage/triage defects in the bug tracking system
  • Experience with agile test methodologies and Scrum environment
  • Good experience of testing a large BI&DW solution that includes Data Integration Testing (Data Acquisition, Data Load/ETL, data cleansing and enhancement) / BI Reporting Applications
  • Proficient experience in databases like Netezza, Oracle and SQL Server
  • Good understanding of dimensional modeling like Star Schema, Snow Flake Schemas
  • Experience in testing Big Data problems on Hadoop platform (MapRFS, MAPRDB, DRILL, HIVE and SQOOP)
  • Good knowledge on Apache Hive and Drill
  • Good understanding on ETL automation tool ICEDQ
  • Experienced in Test Data Management tool IBM Optim for Data sub setting and masking and setting up production like data in test and dev environment
  • Experience on Test Management and Defect tracking tools like HP Quality Center, RQM, Bugzilla and Jira
  • A positive attitude team player with excellent Organization, Interpersonal, communications skills and ability to work independently and deliver on time

TECHNICAL SKILLS

  • ETL/DWH Testing
  • Root cause analysis
  • Hadoop Testing
  • Test Environments
  • BI Reports Testing
  • Data Profiling
  • Toad for Netezza and Oracle
  • Data management
  • UNIX Commands (QA
  • Integration Testing
  • Test Data
  • Management
  • SQL
  • SQL Server, Oracle, Netezza
  • IBM Datastage, Informatica
  • SSIS, SSRS
  • HDFS, MAPRFS
  • Drill, Hive
  • QC ALM
  • Cognos, QlickView
  • IBM
  • Zookeeper, Oozie, YARN
  • ICEDQ ETL Automation
  • SSH
  • Sqoop, Flume

PROFESSIONAL EXPERIENCE

Confidential, Marlborough, MA

QA analyst

Responsibilities:

  • Participated in the requirements review meetings to define QA deliverables
  • Prepared the QA estimations based on the requirements and participating in the team building activities
  • Performed the Schema and Structural Validation based on Low level design document
  • Created the Test Plan, Test Scenarios and Test Cases for review and approval
  • Responsible for tracking the resolutions for QA clarifications and Test Readiness Review
  • Validated data from source to target at each individual phase by ensuring the right external data source is mapped the right internal data source
  • Validated Files in MapR-FS (ODS like) using ETL Automation tool ICEDQ
  • Validated tables in Apache Drill using complex SQL queries running in Drill shell against business requirement
  • Validated data duplicates between data warehouse and MapRFS and whether there is any real business benefit in duplicating the data
  • Validated data is extracted correctly as per business rules
  • Performed Hadoop Eco system behavior validation by changing some parameters in Hadoop profile file
  • Evaluated in advance number of nodes required in each test environment
  • Prepared and used the test data by dumping some masked production data (realistic)
  • Performed negative testing by Changing the input data, replicate the data files and validate all possible variations of input data
  • Validated QlickView reports against Apache drill data and business requirements
  • Validated Hadoop eco system is working as expected after node failure or network failure
  • Responsible for defects tracking and publishing the test results
  • Responsible for metrics submission and team leading activities

Confidential, Marlborough, MA

QA analyst

Responsibilities:

  • Understanding the project requirement by going through Business Requirement Documents, Mapping Documents Gathering user requirement, and prepare and conduct requirement analysis. Analyzing Testing Requirements
  • Identify the Scope of testing and approach. Test strategy creation, test plan creation, Design of Test Scenario's, test case writing, RTM, test data creation, Retesting/Regression testing Writing SQL/PLSQL codes to Verify and validate the Database, Data Mart, DWH data. Monitoring and executing Data Stage and Unix Batch Jobs
  • Testing the data in the generated output file and database for different feeds that involved reading flat files and database and
  • Populating xml files and database from the downstream application. Defect reporting, analysis and Estimate for testing
  • Phase and planning their tests. Preparation of KT documents.
  • Attending Technical review, Test Planning and Defect Review meetings
  • Preparing the test Reports, logs and provide it to Project Manager, Development Manager, and QA Manager

Confidential

Sr.Test Engineer

Responsibilities:

  • Analysis and Review of Business Requirements in the specification documents and Technical Design documents
  • Preparation of Test Schedule, Test Plan, Test Script and Test cases
  • Identification of data anomalies by doing thorough Data profiling Identification of data quality issues and working on designs to address them
  • Setting up Test data for complete test coverage
  • Validation and testing of ETL Functional testing, Integration testing, System testing, Regression testing
  • Testing the Data warehouse/DataMart data against the business logic requirement and mapping documentation of Test Results (Test report matrix)
  • Test estimation for testing requests Adoption of QA Best practices Creating Testing Status Reports, test summary reports
  • Providing support during User Acceptance Testing (UAT)
  • Used hive to validate huge data files for Merchandising financial data, Retail Management data & Retail price
  • Data from third party oracle and loading into Hadoop Distributed file systems(HDFS) and validating
  • Hadoop data validation (reconciliation) against flat files for correctness of the data in Hive
  • Worked on DB Visualizers supports Hadoop ( connection string to Hadoop Clusters)
  • Have Knowledge on Hadoop Distributed File system, Map Reduce, File Browser and Job Browser
  • Understanding of Hadoop architecture

Confidential

Test Engineer

Responsibilities:

  • Identify the Scope of testing and approach.
  • Understanding the project requirements from System Requirement Specification (SRS), LLD and ER Design Documents
  • Analysis of Business requirement for creation of Test Scenario for Test Cases Preparation
  • Data validation, Data integrity, Business logic for Staging to Main databases, Data logs and event logs Verification for Data Migration/transformation From Source to Target
  • Worked on SSIS and SSRS
  • Test Planning, Test Case design/review, SQL Query Scripting & Execution
  • Creating requirement traceability matrix, test estimation
  • Creating builds & requirements in TestLink,(Test Case Design, review, execution and regression on Netezza)
  • Defect tracking using SharePoint Portal/Test Link/Bugzilla
  • Client/onsite co-coordination, communication & reporting, DSR/WSR preparation

Confidential

Test Engineer

Responsibilities:

  • Identify the Scope of testing and approach.
  • Understanding the project requirements from System Requirement Specification (SRS), LLD and ER Design Documents
  • Analysis of Business requirement for creation of Test Scenario for Test Cases Preparation
  • Test Planning, Test Case design/review & Execution
  • Worked on SSIS and SSRS
  • Creating requirement traceability matrix, test estimation
  • Creating builds & requirements in TestLink(test case design, review, execution, retesting and regression)
  • Defect tracking using SharePoint Portal/Test Link/Bugzilla
  • Client/onsite co-coordination, communication & reporting, DSR/WSR preparation

Hire Now