We provide IT Staff Augmentation Services!

Senior Qa/lead (consultant) Resume

Stamford, CT

SUMMARY

  • 7+ years of experience in Software Quality Assurance and Testing of Data Warehousing and ETL Testing.
  • Define QA processes, guide team towards detailed test plans and clear executions with emphasis on working closely with development and product teams
  • Worked on Waterfall and Agile methodologies.
  • Expertise in Business Requirement gathering through workshops and walkthroughs, and main concentration in Business Process Flow.
  • In depth technical noledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, DB2, Oracle, Netezza and ETL.
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working noledge of testing methodologies, disciplines, tasks, resources and scheduling.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
  • Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate - wide-ETL solution using ETL tools like Ab initio.
  • Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Ab Initio using Oracle, DB2, SQL Server and UNIX.
  • Worked on mainframe MVS system using TSO.
  • Testing experiences in Hadoop/Hive/Pig and JAVA component.
  • Experienced on working with Big Data and Hadoop File System (HDFS).
  • Hands on experience in working with Ecosystems like Hive and pig.
  • Knowledge of Hadoop and Hive’s analytical functions.
  • Efficient in testing hive and pig scripts.
  • Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
  • Expert in review and analyze requirements, use cases, technical specifications and database designs.
  • Expert in Develop Test Plans, Test Designs, Specifications, Test Cases and Scenarios.
  • Experienced in DW projects ETL testing against DW testing using Ab Initio.
  • Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
  • Knowledge of and ability to apply a wide range of software test engineering concepts: testing principals (Testing Methodology) and concepts, building a test environment, tracking defects in HP Quality Center (ALM)
  • Strong technical Knowledge of UNIX Utilities
  • Worked on profiling the data for understanding the data in source and mapping document.
  • Ability to manage multiple project in testing by managing team, automate process and delivered all task.
  • Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
  • Involved in UAT by supporting Testing and implement QA Process.
  • Extensively Used ALM, Rational Clear Quest for Test Case and defect tracking management.
  • Expert in working with various cross geo teams across the world with various time zones.
  • Excellent interpersonal and communication skills with good learning curve in short span of time.
  • Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules
  • Functioned as the Onsite / Offshore coordinator and Team Lead and worked as SME.
  • Worked on AWS and familiar with amazon S3 bucket

TECHNICAL SKILLS

Database: ORACLE, SQL Server, DB2, Netezza, OLTP, OLAP

Big Data: Hadoop/Hive/pig

ETL Tools: Ab Initio 2.14-3.1.7, Informatica

Testing Tools: Rational Clear Quest, HP Quality Center (ALM), Automation, Ab Initio TDM, TF, Xpress>It, Query>It

Client Side Skills: SQL, PL/SQL, UNIX shell scripting, Java, HTML, XML, JavaScript, C, C++

Tools: Toad, Erwin 4.1, Rational Rose, MS Project, MS Visio, Autosys, JIRA, BI tool, Sql Server Management Studio, control center.

Operating Systems: Windows XP/ 2000 Professional /98/NT, UNIX/Solaris, Red Hat Linux, IBM AIX, MVS

BI Tools: Microstrategy 9.x, Cognos 10.x

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Senior QA/Lead (Consultant)

Responsibilities:

  • Define QA processes, guide team towards detailed test plans and clear executions with emphasis on working closely with development and product teams
  • Supported testing of multiple projects with multiple time lines and provided QA services with quality on time execution.
  • Manage work of QA consultants and vendors.
  • Ensure 100% test coverage across modules/platforms, Review existing test cases & test plans. Technically Participate in every stage of feature development from design and brainstorming through feature implementation & testing
  • Participates in periodic walkthroughs of teams accomplished objectives. Complete post implementation review assignments for learning & process improvement
  • Lead the QE team in developing and implementing best practices Prepared.
  • Facilitated the UAT testing involving multiple teams and help team on managing the effort.
  • Review Test Approach, test design and provide the feedback.
  • Track the QA progress in multiple projects and send the status to the upper management and highlights any risk

Environment: Informatica, Netezza, Jira, Confluence, AWS, Business Object, SAS, Unica, Adobe, Atana, Oracle, SQL server, Redshift, Cognos, IBM dashDB, AWS, S3, Snowball

Confidential, Wilton, CT

Senior ETL QA (Consultant)

Responsibilities:

  • Tested the ETL mappings and other ETL Processes (Data Warehouse Testing)
  • Clearly communicated and documented test results and defect resolutions during all phases of testing.
  • Simulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Performed Testing, Data Integrity Testing and end to end testing
  • Worked on creating the test data with obfuscating/masking/shuffling of data using Test Data Management (TDM)
  • Automate the regression testing using Ab initio TF.
  • Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
  • Involved in testing of source for data completeness from different data sources like Oracle/SQL Server.
  • Worked with appropriate business and technology leads to determine the acceptable range for test results and performance.
  • Tested the ETL process for both before data validation and after data validation process.
  • Tested the messages published by ETL tool and data loaded into various databases
  • Worked on profiling the data for understanding the data in source and mapping document.
  • Tested database & UNIX Scripts needed to meet the system requirements.
  • Tested the file landed in Hadoop HDFS.
  • Optimized SQL queries for better performance during testing.
  • Worked on various Ab initio application as part of testing
  • Reported bugs and tracked defects using HP ALM
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Written several UNIX scripts for invoking data reconciliation.
  • Involved in extensive data validation using SQL queries and back-end testing
  • Used SQL for Querying the SQL server database in UNIX environment
  • Created and scheduled the job in control center and set up dependencies
  • Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: ETL (Ab initio GDE 3.252), SQL Server, Hadoop, HP ALM, UNIX, Express >It, TDM, TF, Query>It, Rally, Control Center, AWS, EMR

Confidential, Foster City, CA

Senior QA/DWH ETL Lead (Consultant)

Responsibilities:

  • Support and resolve day to day business queries related to many GMR & BI Confidential applications.
  • Working with the business community to identify user requirements.
  • Document requirements and assist in clarifying discrepancies in requirements.
  • Review and approve data models and business metadata definitions.
  • Played the role of Lead concurrently for different project.
  • Does the coordination activities like tracking tasks and resources, activities, requirement gathering, review of technical design documents and their timely delivery.
  • Importing and exporting data into HDFS and Hive using Sqoop
  • Experienced in defining job flows
  • Experienced in managing and reviewing Hadoop log files
  • Supported Map Reduce Programs those are running on the cluster
  • Experience in running Hadoop streaming jobs to process terabytes of xml format data
  • Involved in loading data from UNIX file system to HDFS.
  • Installed and configured Hive and also written Hive UDFs.
  • Loaded large sets of structured, semi structured data coming from UNIX, NoSQL and variety of portfolios into HBASE by creating the HBASE table.
  • Extended myself in learning and understanding the concepts of Hadoop with a quick pace.
  • Worked on analyzing Hadoop cluster and different Big Data analytic tools including Pig, Hbase database and SQOOP.
  • Requirements and clarified with Business Analyst.
  • Reviewed High Level and Lows level Design docs and clarified design solutions with Developers
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
  • Developed the ETL and BI testing strategy
  • Extensively executed SQL queries in order to view successful transactions of data
  • Wrote SQL queries to validate source data versus data in the data warehouse
  • Identified duplicate records in target tables.
  • Running the AbInitio Graphs in UNIX & MVS Environment
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Involved in all walk through for test designs, data designs and code reviews.
  • Developed Test Plan, Test cases & Test Scenarios for new features.
  • Updated existing Regression Test cases for impacted features due to new features.
  • Tested the Application in UNIX Environment
  • Tested the Data load process by running the AbInitio Graphs.
  • Identified the Test Environment for Database Testing.
  • Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
  • Writing the test scripts for manual testing.
  • Preparation of various test documents for ETL process in Quality Center.
  • Understand the database development for dis project.
  • Execute the database Test cases according to release.
  • Analyze the results and log the defects in bug tracking tool
  • Retested resolved bugs on each build release
  • Communicate with Developers and DBA

Environment: Abinitio 3.x, UNIX, DB2, Clear Quest, BMC Remedy, HP ALM 11.0, Hadoop (Hive), Pig, MVS, JIRA, Map Reduce, HDFS, XML, Flat files, Toad for DB2, Mainframes, Trillium

Hire Now