Test Cases Data
Resume:
Dilip
*******@*****.***
Professional Summary:
* ***** ** ** ********** in Quality Assurance for ETL, Business Intelligence, Data Warehousing, Web based, Client/Server applications using Manual and Automated testing tools.
Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
Extensive experience in requirements gathering and analysis, design, development, testing and validation in Data centric projects (data bases, data warehousing and business intelligence space).
Extensive experience with test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
Extensive experience in ETL and BI testing for many data extractions and data migration projects.
Well versed with SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix
Experience in working Agile Methodology (Scrum) and used JIRA, VSTS.
Experience in complex Manual and Automation Testing of GUI and functional aspects of the client-server and web based applications in all phases of SDLC
Experience in Functional, Regression, GUI, Usability, Integration, Exploratory, Smoke, Backend, Adhoc, Load, Performance, Black Box and White Box Testing
Experience in IDQ, DVO Testing.
Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
All testing engagements completed within project timelines and consistently met live-date project deadlines.
Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
Strong in Web application testing and understand architecture in terms of functionality.
Good experience in Authoring and Reviewing test cases.
Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
Developed inline view queries and complex SQL queries and improved the query performance for the same.
Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
Skill Summary:
Database:
Oracle, MySQL,Teradata
Change Mgt Tools:
Test Director 8.0, Quality Center, Rational Clear Quest
Data Warehouse Tools:
Informatica(Informatica PC,MDM,IDQ), Talend(DQ, DI, MDM, Talend with BIG DATA, DP)
Functional Test Tools:
WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0
Languages:
PL/SQL, Shell Scripting, Core Java
Office Tools:
MS Office Suite, MS Project, Microsoft Share Point
Operating System:
UNIX, LINUX, Windows, MS-DOS
Tools:
TOAD 9.2, Win SQL, SQL Developer
Web Technologies:
XML, HTML, JavaScript, VBScript
Professional Experience
Aug 2016 – March 2017
Client : Johnson Controls,
Milwaukee, WI
Role : ETL/Talend
Project: GRDM- EXT
JCI is looking to design, develop and implement a (BE) Global Reference Model. The model will be designed based on high-level BE business requirements collected during the Scoping effort which interviewed representative stakeholders from across BE.
Environment: Hive, Beeline, big data, Talend (ETL Tool), Jira
Roles and Responsibilities:
Designing the Test Scenarios as per the business requirements and Mapping documents.
Profiling the data using Talend (DQ) land sql.
Implemented SCD I, II to the extracts based on the business requirement and client expectations.
Testing Validation rules as per the requirement in different cases.
Acquired knowledge in complex sql scenarios.
Worked on pulling data from multiple sources for all possible test cases.
Data Ingestion : Too many source systems worked on complex system
Acquired good knowledge in terms of subject area (customer, product, inventory etc and relation to the business.
Involved in end to end testing and in different stages of the project.
Designed an approach for the team in functional testing.
Understand the transformation rules and create test cases based on the business requirement.
Worked closely with the development in fixing the defects (Regression testing) and find the root cause of the issue.
Major challenges during the project:
Data Governance,data inconsistency, Model changes, data quality
Lack of metadata strategy 30 + source systems and 5+ functional areas
Feb 2016- July2016
Client Comcast, Westchester, PN
Role: ETL/QA/ Informatica Tester
Responsibilities:
Prepared Test Plan from the Business Requirements and Functional Specification.
Performed Functional tests for multiple source tables and dealt with integration project.
Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
Performed tests on Data Quality Checks in IDQ environment and DVO Testing.
Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
Developed test scripts using QTP for Functionality and Regression Testing.
Supporting UAT team in defect analysis and providing data refresh and keeping track of all the jobs and workflows run on time .(number of mappers-map reduce)
Worked on TOAD and SQL Developer,involved in fusion of data from different sources and executed complex queries as part of functional testing
Involved in coordinating and preparing Validation Test Plans, Test Methodology and Test cases as per Functional and Business requirement for System/Functional Test Specification and Unit/Integration Test specification set by the SOP's, Best practices, policies, and procedures of the company.
Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
Extracted data from Oracle and upload to Teradata tables using Teradata.
Generated testing reports and metrics, trend graphs according to the test plan.
Performed the data validation and datatypes mismatch
Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
Coordinated all the defects and root cause for the defects, to ensure quality of the data (ALM).
Used UC4 tool for Scheduling different jobs and created data dependency checks for proper migration of data.
Tested data migration to ensure that integrity of data was not compromised.
Created test data for all ETL mapping rules to test the functionality of the Informatica Jobs
Tested the ETL process as per the business logic before and after data validations.
Tested the messages published by ETL tool and data loaded into various databases
Testing of records with logical delete using flags.
Environment: Informatica, MS SQL Server 2008, DVO,IDQ, UNIX, Teradata, Teradata SQL Assistant, Oracle 10g, TOAD, QTP,Windows 2007,Quality Center/ALM 11, T-SQL, SQL, Teradata Studio, TOAD,UC4.
Global Logic Technologies LTD Dec 2010- Jan2014
Client Google, Hyderabad
Role: Quality Analyst(Meta QA
Responsibilities:
•Testing the GIS city block application under live environment.
•Performing the load testing on the application by making extreme edits on Production GIS data
•Logging the bugs under Bugzilla.
•Provide statistical data collection and quality administration.
Monitoring the performance of the Magrathean servers and Edit servers
Which uses the GIS App.
This project has been implemented on USA, UK, Europe, Germany, Mexico, Canada etc. The project plan includes the implementation of same for 72 countries.
PROJECTS PROFILE:
Project Title #1 Ground Truth
Client Google India Pvt Ltd
Technologies Bitable Database
Testing Tools City block, Bugzilla, HP-QTP 10.0
Education: Master’s in Computer Science 2014 Jan – 2015 Dec
Contact this candidate