We provide IT Staff Augmentation Services!

Big Data Qe Resume

Dallas, TX

EXPERIENCE SUMMARY:

  • 12+ years of experience into software projects and played versatile roles constituting of Big Data QE/ ETL Test Lead/Test Analyst/Data Analyst/SQL Developer.
  • 2 + years of experience in Big Data Validation and expertise in Hadoop Eco System, HDFS,Map Reduce,Hive,Hbase and Apache Pig
  • 6+ years of experience in Data warehousing / ETL testing /BI Testing within environments of Oracle, SQLServer, Teradata, Informatica 9.x/8.x,SQL Developer, Toad, Cognos, OBIEE reports and SSRS.
  • 3+ years of experience as Test Lead and expertise in planning, estimates, data setup, design, execution and status reporting.
  • Data Extraction, Data Manipulation, Data Loading using Hive and Pig Tools and intermediate Java programming with Map Reduce frameworks .
  • Automation Testing using QTP and QC,DVO and Excel Macros
  • Expertise in Requirement Analysis, Data Analysis, Data Profiling, Data Cleansing, Data Verification and Data Validation.
  • Proficient in Data warehouse architecture, Data models, schemas and in - line with Agile(Scrum), SAFe model and traditional SDLC models(Waterfall and Iterative)
  • Top-notch in designing complex SQL queries in RDBMS like Oracle,Teradata,SQL Server incorporating Joins,subqueries, functions, set operators, analytical functions.
  • Excellent in designing complex database objects like stored procedures, functions, packages, cursors and Triggers using SQL and PLSQL
  • Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and mappings using Informatica Designer
  • Experienced in Unix commands, Shell scripting, FTP and file management in various UNIX environments
  • Experience in Scheduling tools as Informatica Workflow Monitor,Autosys,DAC, UC4 and Control M
  • Intricate in working with utilities like Teradata Fast load, Oracle SQL Loader and tools like Toad, CDB, QTP,QC/ALM,SQL Developer, Case Studio, Rational Rose, Erwin,Winscp,Putty
  • Well versed into different testing that includes Black Box, Smoke, Functional, System Integration, User Acceptance,Cubes Validation, Cognos/OBIEE Reports, Performance and End to End Testing.
  • Effective communicator with strong analytical abilities combined with skills to plan, implement and presentation of projects.

TECHNICAL SKILLS:

Hadoop: Cloudera, HDFS,Map Reduce,Hive,Pig,HBASE

Data Warehousing: Informatica9.x/8.x,SSIS 2005,2008 R2

Databases: Oracle 11g/10g/9i/8i, Teradata, DB2,SQL SERVER

GUI Tools: SQL Developer, Toad

Reporting Tools: Cognos,OBIEE,SSRS 2005

Languages:: C, C++, Java, VB Script, SQL, PL SQL

Functional Testing Tools:: Quick Test Professional 9.5, ALM

Operating Systems: Microsoft Windows 95/98/XP/2000/2003, MAC.

Web Technologies: HTML, DHTML, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Big Data QE

Responsibilities:

  • Involved in Data Extraction, Data Manipulation, Data Loading and validated the Data Accuracy of reports
  • Tested the files moved from local file system to HDFS to verify the missing data
  • Involved in setting up the testing environments and prepare test data for testing flows to validate and prove positive and negative cases
  • Created Hive queries which helped analysts in identifying trends by comparing current data with historical finance metrics.
  • Configured SQL database to store Hive metadata and loaded data into Hadoop File System (HDFS).
  • Validated the data loaded in Hive Partitioned tables and tested the transformations in Pig
  • Validated the data imported into HDFS .
  • Validated the Map reduce, Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
  • Design SQL queries /test cases for multiple user stories in each team and reviewed them with team during working sessions.
  • Identifying data dependency across Finance systems and requested Data Refresh from PROD to TEST environment
  • Test Execution of Control M jobs, Stored procedures and validated test scenarios
  • Validated data across Datwarehouse and Reporting instances as per Data Architect request for TDR Transactions
  • Involved in working sessions and assisted business analyst to identify UAT test cases .
  • Identified issues in Control M jobs, Informatica Workflows and notified the dev team as part of white box testing
  • Worked in compliance with QA process for each user story and updated QA activities in tools such as ALM, Rally
  • Provided Signoff for multiple user stories across teams with complete test coverage
  • Provided demo to business users for critical, user stories and received approval .
  • Helped QA team and understanding User stories and designing SQL’s

Environment: Hive,Pig,HDFS, Informatica PowerCenter9.x, SQL SERVER 2014, CONTROL M, ALM,RALLY

Confidential, San Ramon CA

Sr Test Analyst

Responsibilities:

  • Responsible for validating data associated to work-stream 2, 3, 4 for R8 Changes .
  • Design SQL queries for existing / new application for FL, HE schedules based on source system
  • Successful automation of data from all schedules and all sources in one dashboard for Federal submission.
  • Actively involved in test planning, test design, test execution, defect retesting, defect closure for work streams and performed functional /regression testing.
  • Involved in peer review of logic and generated technical mapping document for successful automation for all ETLs consolidated into one single data repository.
  • Involved in finding the existing defects in the system, interacted with BA’s and raised CR
  • Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and other testing team.
  • Involved in implementation of submission and resubmission logic using XML format interface into Excel.
  • Performed Data analysis and provided solutions commonly used for development and automation testing.
  • Involved in data mining and assisted in creating and presenting informational reports for management based on SQL data
  • Used data analysis techniques to validate FED Edit checks and identify low quality missing data in the existing EDW

Environment: Informatica PowerCenter9.x, Oracle11g, Toad,Flat Files, UNIX, ALM,OBIEE

Confidential, San Ramon CA

Sr Test Analyst

Responsibilities:

  • Understanding the functional specifications in detail and preparing gap analysis sheet for any clarifications with business analyst team.
  • Worked individually on modules of Account, Weather, System load and Data request.4
  • Performed test analysis of the sourced data and suggested Data model changes
  • Involved in preparing Test plan for all the modules and got it reviewed.
  • Participated in design review meetings for the Account, Weather and System Load modules
  • Prepared test scenarios positive, negative, technical and business scenarios and delivered walkthrough with design and business teams
  • Prepared test data and incorporated the test data as required into the source system for validating the insert/update logic based on technical specifications
  • Update the test data in source system, ran the workflows and tested the changes .Also performed the rollback operations for data changed in source system
  • Involved in Test Execution and defects retesting and uploaded test results into Quality Center
  • Involved in testing data with various combinations as Table to Table, Flat file to Table
  • Validated the data across File to Table using Fastload utility in Teradata
  • Involved in Running the workflows scheduling jobs using UC4 and proactively communicated with dev teams on the success of data load
  • Involved in validating the data using Informatica DVO as part of Regression testing.
  • Used unix commands in placing files between servers using Putty.
  • Added parameter file using Winscp and validated the email notification based on the workflows status
  • Represented test activities in GO-NO GO meetings for the production deployment with the UAT and business users

Environment: Informatica PowerCenter9.x, Oracle11g, Teradata, SQL Server 2008,SQL Developer,SQL Assitant, UC4, Flat Files, UNIX, ALM,Infomatica DVO, Fast Load

Confidential, Woodland Hills CA

ETL Test Lead

Responsibilities:

  • Understanding the business and functional requirements and preparing gap analysis sheet for any clarifications with business analyst team.
  • Performed Data profiling by identifying the data dependency in the Heart Source System and capture the data flow between Claims SA, Payment SA, Reserve SA and Claim unit SA
  • Designed the Test Strategy document and got it reviewed with the customers and business teams .
  • Incorporated the V-model of software testing and performed the test activities in all the phases of SDLC
  • Provided test estimates for the test cycles and designed the test approaches for the Historical and Incremental data
  • Designed Glass to Glass testing approach for the source Siebel application and the target OBIEE reports
  • Load the test data into the target tables by executing the DAC plan as per the historical and incremental test cycle schedules.
  • Interacted with senior peers/SME to learn more about the data and Reported the daily test execution status with the senior management and the customers.
  • Reviewed the documentation related to different teams that includes Data Dictionary,ETL STTM’s, OBIEE LLD’s, Test Scenarios from Source to Stage and Stage to CDM and CDM to OBIEE
  • Performed different phases of testing include SIT, UAT, PROD and different types of testing include Functional data validation at ETL and OBIEE, Glass to Glass testing, Performance testing

Environment: Informatica PowerCenter9.x, Oracle11g, OBIEE,TOAD,Erwin, Flat Files, UNIX, DAC, Siebel, ALM,SQLLOADER

Confidential, San Antonio, TX

ETL Test Lead

Responsibilities:

  • Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
  • Designing the test plan for validating the data across the layers of data warehouse architecture
  • Manage end to end testing work for the DW distribution portfolio and lead the project team of 10 resources to assign module/activity/tasks/deliverables
  • Prepare the test environment setup and initiate the appropriate requests for the readiness of the environment.
  • Preparing Test Scripts in QTP as per the framework and running the test scripts and capturing the test results.
  • Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated locations. Tested the data loaded on daily and weekly basis from source to Stage
  • Identify the test estimates and prepare test plan covering the complete testing process
  • Reviewing the test cases and ensuring the test coverage is achieved.
  • Loading the extract file data into different stages of FSDIM DW database tables through informatica workflows using Autosys for defining, scheduling and monitoring jobs.
  • Guided team in Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing.
  • Executed and managed test cases and reported bugs in Quality Center if we have any issues in data comparison or workflow failures.
  • Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis .
  • Created Integrated summary data from multiple tables to represent the business perspective of the top management executives

Environment: SSIS 2005, Cross Database Comparator, Quick Test Professional,SQL Server, TOAD, SQL Developer, Flat Files, UNIX, Autosys, ALM

Confidential

ETL Tester

Responsibilities:

  • Involve in Understanding the Functional Requirements and business requirements.
  • Designed test scripts from source to stage. Source is XML file and sql are designed based on XMLtable and performed data validation.
  • Creating Test Scenarios and Test Scripts to validate source and Target data.
  • Test Scenarios include end to end test coverage from Quotes to Policies as per the business requirement.
  • Involved in Test Case Design with respect to Test Plan.
  • Executing the test scripts including prerequisites, detailed instructions and anticipated results.
  • Interacting with the development team to solve the problems encountered in the test scenario run.
  • Analyzing the root cause of the failed Test Case and provide the corresponding data samples to client
  • Tracking the defects using RTC tool and reported the defect status to multiple teams in the project.
  • Attend the Status Calls and Updating the Work Status and ensured the test timelines are as per schedule.
  • Used Cross database comparator tool for validating the data across heterogeneous databases
  • Involved in Cubes Testing and Involved in Cognos Reports testing.
  • Converting the SQL into SAS jobs based on the logic and Creating Sas jobs for the similar attributes using multiple approaches.
  • Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management
  • Involved in Performance Statistics calculation and Involved in Dash board Preparations.
  • Involved in Test execution and updated the defect status in QC .
  • Involved in Test Reporting on daily/ weekly basis through company prescribed format.

Environment: Informatica PowerCenter9.x, Cross Database Comparator, Teradata, TOAD, SQL Developer, Flat Files, UNIX, RTC, ALM, Cognos Reports

Confidential

Automation Tester

Responsibilities:

  • Involved in studying functional specifications and Mercado specifications.
  • Prepared Test plan, test scenarios, test cases as per the specifications.
  • Involved in designing test cases and adding the Mercado related test cases.
  • Configured rules,MZ’s in CMC and checking application functionality.
  • Involved in Mapping of Size and Color in ML admin
  • Executed test cases and raised issues in bug tracking tool Jira.
  • Actively communicated with dev team in handling issues during test execution.
  • Involved in testing Bazaar voice inline ratings functionality and capturing screenshots in cross browsers.
  • Involved in Cross browser testing in IE6,IE7,Safari 2.x and Firefox 2.x browsers
  • Responsible in development and maintenance of regression suite using QTP in QC.
  • Involved in developing libraries, recovery scenarios and test scripts using QTP.
  • Handled Object Repository management for every new release.
  • Responsible in executing test suites through Quality Center Lab and analyze test results
  • Managed 3 members of testing team as well played a Lead Role
  • Participating in project meeting and discussion meeting/ conference calls with onsite teams.
  • Involved in validating the data as part of database testing by writing sql’s and executing them.

Environment: Oracle 8.0, Java, Servlets, PL/SQL, Windows NT/98, SQL*Loader, QTP, QC

Confidential

Functional Tester

Responsibilities:

  • Involved in Functional study of the Application and Responsible for Preparation and execution of full suite of Test cases and Involved in preparation of Test plan document.
  • Designed High level Test Scenarios and Test Cases and Responsible for Functional and Regression testing.
  • Involved in Retesting of the test cases based on the builds.
  • Designed test cases using Black Box testing techniques and prepare Requirement Traceability Matrix.
  • Involved in Writing the Stored Procedures and executing the stored procedures
  • Co-ordinate with development team in resolving critical bugs.
  • Involved in Automated Testing of the System using QTP
  • Involved in Reviewing the Scripts for the Application and executing the Scripts with QTP.
  • Utilized the best practices for the creation of Test Status Report and Weekly Status Report.

Environment: Oracle 8.0, Java, Servlets, PL/SQL, Windows NT/98, SQL*Loader, QTP, QC

Hire Now