SUMMARY:

• 11 years of work experience in IT in the roles of ETL Test Lead / Sr. Software Test Engineer of Client - Server Technology, Web applications, and Data warehousing/ Business Intelligence.
• Expertise in Manual Testing, Automation Testing, Hadoop Testing, ETL Testing, DW Testing, Database Testing and Web services Testing.
• Expertise in Automation Testing using tools Selenium, HP UFT/QTP and Silk.
• Expertise in ETL testing by using the tools Informatica, SSIS, Data stage and Abnitio.
• Expertise in validating the data by writing SQL queries and using Informatica DVO and iCDEQ
• Expertise in data modeling tools Erwin and ODMT
• Expertise in Report testing using the tools OBIEE, Micro strategy, Cognos, Qlikview, SSRS and Tableau.
• Expertise in VB and Java scripting.
• Expertise in testing applications built on .Net and Java technologies.
• Experience in designing and implementing the automation frame works of Keyword, Data, Hybrid and Modular driven.
• Expertise in performance testing using Load runner
• Experience in implementing SDLC methodologies including waterfall, v-model and agile methodology.
• Expertise with Black box Test design Techniques like Boundary value analysis, Equivalence partitioning, Decision Table Testing, State transition Testing and Error guessing techniques, Smoke, Functional, Regression, Beta testing, Database and Integration testing.
• In depth understanding/knowledge of Hadoop Architecture and various components such as HDFS, JobTracker, Task Tracker, Name Node, Data Node. Experience on data imports and exports from relational database to Hadoop and vice versa.
• Experience on debugging and testing MapReduce code.
• Experience on testing data processing in Big data technologies of HDFS, Hbase, Pig, Hive OOZIE & Spark.
• Experience on NOSQL Databases of Hbase and Mango DB
• Experience in working with Multiple Relational Databases Teradata, Oracle, SQL Server, DB2, MS Access, XML and Flat Files.
• Expertise in designing and developing test strategy, test plan, test cases and generating test reports, defect reports.
• Expertise in Problem solving and Bug Reports using Defect Tracking Tools like Quality Center/ALM, JIRA, and Rational Clear Quest.
• Possess business knowledge on Finance, Energy, Insurance, Industrial Products, Biometric, Healthcare and Retail.
• Experience with GAP Analysis to analysis enterprise data.
• Expertise in performing the e2e testing, preparing the positive and negative test scenarios.
• Experience on Testing web application servers Apache Tomcat and MS IIS
• In depth understanding the functionality of AWS and Netflix OSS

TECHNICAL SKILLS:

Big Data: Hadoop, Map Reduce, Hive, HBase, Sqoop, Pig, Zookeeper, Flume and Spark

Testing Tools: QTP, VSTS, Selenium, QC, Clear Quest and Jira

ETL Tools: Informatica, Data stage and SSIS

Database: Teradata, Oracle, SQL Server and DB2

OS: UNIX, Windows

Programming: Core Java, C#, VB and Scala

Reporting Tools: Qlikview, Spotfire, Tableau, Cognos and SSRS

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Warehouse Tester/ETL Test Lead

Responsibilities:

• Preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Analyzing transformation rules, rating the complexities and preparing the estimations.
• Understanding the data nature from different OLTP systems and testing the insertion processes for HDFS Using Informatica 9.6 and Sqoop.
• Testing the data models in Hive, Pig and Hbase.
• Creating and debugging the UDF’s written in Java and integrating with Hive.
• Validation of Hive, Hbase schemas in cluster environment.
• Verified standalone non-mapreduce Java jobs that run on a Hadoop cluster to ensure that all the work must be platform portable across clusters
• Working with data management team and BA team for managing the test data creation from various source systems and escalating any issues to Management.
• Writing the SQL queries for backend testing and validated database, comparing the Data.
• Verified the transformation rules, data comparison from source to target by using iCEDQ tool.
• Validated the displayed on the Cognos reports with the business rules and formulas.
• Validated the cube reports of the Cognos with the Data warehouse data.
• Handling the team and assigning testing responsibilities and follow up till test completion and reporting the status to Project Manager. Responsible for updating the weekly reports.
• Strong experience creating concise and clear reports for distribution and presentation to senior management on a weekly basis. Experience monitoring and tracking implementation plans.
• Expertise testing the application on data driven testing to test the application functionality on UI.
• Written test cases for positive and negative test scenarios.
• Performed smoke, functional, integration, E2E and regression testing.
• Reported the defect in QC and interacted with the Development team to resolving the issues.

Environment: /Tools: Informatica, Hadoop, MapReduce, Hive, HBase, Sqoop, Pig, Zookeeper, Qlikview, ETL Cognos.

Confidential,Houston TX

Sr. Data Warehouse /ETL Test Lead

Responsibilities:

• Preparing detailed test plan, test scripts and test cases by understanding the business logic and user requirements.
• Analyzing transformation rules, rating the complexities and preparing the estimations.
• Preparing and executing E2E, Integration, functional, smoke test cases. Writing SQL queries for data validation.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation.
• Improving specification and design documents through active review and feedback with developers.
• Integration of data across various sources in an ETL process, versioning, manual correction of tables, address correction.
• Monitoring execution of workflows, preparing the root cause analysis report by analyzing the data and logs if any failure.
• Validated the business rules and data by using the Informatica DVO.
• Handling the team and assigning testing responsibilities and follow up till test completion and reporting the status to Project Manager. Responsible for updating the weekly reports.
• Preparing the Requirement traceability matrix in Quality Center and sending to project manager.
• Involving the defect triage meetings to discuss on defect complexity and priorities.

Environment: & Tools: Informatica, ETL, Micro strategy, SQL Server and ALM

Confidential,Seattle WA

Data warehouse /ETL Test Engineer

• Responsible for Creation of Test Plan and Test Estimations.
• Understanding the Business Requirements or Transformation Rules.
• Creation of Test Cases i.e. SQL Queries as per the Transformation Rules to evaluate the data.
• Execution of Source and Target Test Cases (SQL Queries) to test the workflows and to ensure the data Is Transfer as per the requirements is not.
• Performing the Daily, Backfill, Sanity(Duplicate checks, Null checks) Testing
• Performing the Root Cause Analysis Report if any failure occurs.
• Monitoring the data flows (workflows) in Informatica workflow monitor, if any failure occurs or if any records are rejects providing the initial analysis report
• Creating the Report Testing and Cube Test Cases (SQL Queries) as per the Business Rules
• Generating the Reports in the Cognos Reporting Toole.
• Execution of Report Test Cases and comparing Results with the Reporting Results to evaluate the data.
• Involved in Team Management activities and communicating with the clients.
• Environment & Tools: Informatica, Micro strategy, DB2, CQ, ETL

Confidential,Houston TX

Sr. ETL Tester/ QA Engineer

• Designing and Implementing the Automation frame work Approach.
• Responsible for design of test plan, test scenario and test cases.
• Identify the scope of automated testing and test cases eligible for automation.
• Develop, integrate and maintain Automation Test Suite.
• Responsible for maintain the inc declarations and changes.
• Documentation of technical aspects of Test Automation.
• Responsible for the preparing the automation builds.
• Execution of automated test suite on regular basis to perform the regression testing of the application
• Analysis of automation test results and bug reporting Issues using QC.
• Effectively communicate issues in a written format, providing clear and concise information necessary to reproduce and explain the problem to developers to resolve issues.

Environment: & Tools: Selenium Test, JIRA

Confidential,NY

Sr. ETL Tester/ QA Engineer

• Created Test Plans as per Functional and Business requirement.
• Responsible for performing Smoke testing, Integration testing, and system testing, Database Testing and user acceptance testing.
• Designed and executed test cases and verified actual results against expected results.
• Creation and restoring of the Database.
• Retrieved data from Database by writing SQL queries to check the correctness of data and to verify that data is coming from a correct table.
• Frequent status checks meetings with the Team.
• Prepare and deliver weekly status reports.
• Prepared test data for positive and negative test scenarios for functional testing
• Participated in the bug reviews and client meetings.
• Involved in regression testing after each build release of the application.
• Followed up development team for defect resolution.

Environment: & Tools: QTP, Oracle, JIRA, Tomcat Server, Hibernate 2.0/3.0, spring, JSF, Servlets 2.5, XML, JavaScript, HTML, CVS, Log4J

Confidential,NJ

Sr. QA Engineer

• Created Test Plans as per Functional and Business requirement.
• Responsible for performing Smoke testing, Integration testing, and system testing and user acceptance testing.
• Designed and executed test cases and verified actual results against expected results.
• Performed both manual and automated testing of the Application.
• Creation and Restoring of the Database.
• Retrieved data from Database by writing SQL queries to check the correctness of data and to
• Verify that data is coming from a correct table.
• Frequent status checks meetings with the Team.
• Prepare and deliver weekly status reports.
• Prepared test data for positive and negative test scenarios for functional testing
• Participated in the bug reviews and client meetings.
• Involved in regression testing after each build release of the application.

Environment: & Tools: Windows 2003, Ajax, .Net 2.0 and SQL Server, Load runner

Confidential

Sr. QA Engineer

• Created Test Plans as per Functional and Business requirement.
• Responsible for performing Smoke testing, Integration testing, and system testing. Participating user acceptance testing.
• Designed and executed test cases and verified actual results against expected results.
• Performed both manual and automated testing of the Application.
• Retrieved data from Database by writing SQL queries to check the correctness of data and to Verify that data is coming from a correct table.
• Frequent status checks meetings with the Team.
• Prepare and deliver weekly status reports.
• Prepared test data for positive and negative test scenarios for functional testing
• Participated in the bug reviews and client meetings.
• Involved in regression testing after each build release of the application.
• Followed up development team for defect resolution.

Environment: & Tools: .Net, SharePoint, SQL Server, VSTS, TFS

Confidential

QA Engineer

• Identify the scope of automated testing and test cases eligible for automation
• Develop, integrate and maintain Automation Test Suite
• Designing and adding recovery scenarios to the automation framework for break-free execution of Automated Test Suite
• Attend the regular client call and discuss weekly status with client

Environment: & Tools: VB.Net, ASP.NET, SQL Server 2000, SQL Reporting Services

Confidential

QA Engineer

• Designed Test cases for New Enhancements to test the application based on the test requirements
• Creation of Test Machines on 14 localizations
• Deploying the build and doing the smoke testing
• Performed Smoke Testing, System Testing, Installation Testing, Functional Testing
• Created Different Scenarios and Tested the Performance of PMS.
• Reported the Incidents (Defects) Effetely Using Sydney Helpdesk

Environment: & Tools: ASP.Net, MS Server 2000, Microsoft Operating Systems (Six Localized installations), Norton Ghost Utility, VMware, Sydney Helpdesk