EBI Finance, DELL USA, Tera Data, Oracle SQL Developer, Informatica, Cognos, Winscp, ALM, Equal Automated Tool, ETL Testing, Functional Testing, DELL is an US multinational computer technology company that develops, sells, repairs, and supports computers and related products and services. Named after its founder, Michael Dell, the company is one of the largest technological corporations in the world, employing more than 145,000 people in the U.S. and around the world (Annual report 2018). Dell willing to maintain data integration and enhance the Dell data flow architecture more user friendly., Involved in understanding the Business Requirements and functional specifications. Design and Development of QA documentation like Test scenarios and Test Cases from business and functional requirements. Reviewing the requirement and finding out the gaps in the requirement and raising clarifications. Identified the requirements and arranged peer reviews, walk-through and sign off meetings. Performed SQL validation to verify the data extracts and record counts, Duplicates in the Tera Data Database, SQL Developer database to verify tables by writing complex SQL queries. Tested the Derived data element mapping from Source to Target (Multiple layer). Written test cases for checking the populated data correctly into dimension and Fact tables. Worked on Talend ETL tool to run the jobs, monitor the jobs and to check the Session log. Extensively worked on Jira (Zephyr) to upload the Test cases. Prepared testing documents like Test Strategy, Test Summary documents. Performed functional testing for all the Mappings and Sessions. EBA, NetApp. USA, Oracle SQL Developer, HP ALM, Beyond Compare, SAP Hana, ETL Test Engineer, NetApp, Inc. is a hybrid cloud data service company headquartered in Sunnyvale, California. It has ranked in the Fortune 500 since 2012. Founded in 1992 with an IPO in 1995, NetApp offers hybrid cloud data services that simplify management of applications and data across cloud and on-premises environments to accelerate digital transformation. NetApp, Inc. willing to maintain data integration and enhance the NetApp, Inc. Data flow architecture more user friendly., Involved in understanding the requirements and functional specifications of the applications. Design and Development of QA documentation like Test scenarios and Test Cases from business and functional requirements. Reviewing the requirement and finding out the gaps in the requirement and raising clarifications. Identified the requirements and arranged peer reviews, walk through and sign off meetings. Performed functional Testing. Performed SQL validation to verify the data extracts and record counts in the SQL Developer database to verify tables by writing complex SQL queries. Tested the Derived data element mapping from Source to Target. Written test cases for checking the populated data correctly into fact and dimension tables. Used Oracle SQL Developer to access source and Target. Responsible for different Data mapping activities from Source systems to DWH. Extensively worked on ALM to upload the Test cases. Extensively worked on Requirement, Test Plan, Test lab, Defect tab in ALM. Performed functional testing for all the Mappings and Sessions. Membership Operational Data Store (Membership ODS), Anthem Inc. USA, Oracle SQL Developer, Informatica PowerCenter Data Validation Option(DVO), Informatica Power Center, Jira, Share Point, ETL Testing, Anthem, Inc. is one of the largest health benefits companies in the United States. Through its affiliated health plans, Anthem companies deliver a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services and I other departments Headquartered in Indianapolis, Indiana, Anthem, Inc. is an independent licensee of the Blue Cross and Blue Shield Association serving members in California, Colorado. Anthem willing to create data integration framework and processes for the Anthem Billing & Membership ODS (Operational Data Store)., Involved in understanding the requirements and functional specifications of the applications. Design and Development of QA documentation like Test scenarios and Test Cases from business and functional requirements. Reviewing the requirement and finding out the gaps in the requirement and raising clarifications. Identified the requirements and arranged peer reviews, walk through and sign off meetings. Worked on Informatica Data Validation Option (Informatica DVO Tool) to validate Source and Target data. Tested transformation functions and record formats for various input data files. Written test cases for checking the populated data correctly into fact and dimension tables. Used Oracle SQL Developer to access source and Target. Responsible for different Data mapping activities from Source systems to DWH.