Summary
Overview
Work History
Education
Skills
Languages
Timeline
Projects
Projects

Basavaraju Y.N.

ETL test Engineer

Summary

Seeking a challenging position in a progressive organization, where my skills and experience would be explored and utilized towards success and development of the organization and myself.

Overall 6.2 years of IT experience, with 4.9 years of experience in ETL DWH/Database Testing with Automation. Having Experience on Selenium Automation Testing using Cucumber and Karate Frameworks with Java Programming. Strong understanding of SDLC and STLC. Good exposure on Data warehouse concepts like Star schema, Snow-flake schema, Fact table and Dimension table etc. Experience with Talend and Informatica Power Center ETL tool. Prepared Test Cases for the Validating the data and test data for ETL process. Hands on experience in writing complex SQL Queries. Experience in Bug Reporting, conducting Bug review meetings. Extensively used Workflow manager, Workflow monitor in Informatica ETL tool. Experienced in dealing with clients to collecting and understanding the Business requirements, product demonstrations and providing product support. Prepared testing documents like Test Strategy, Test Summary documents. Experience in Test Management and Issue tracking Tools Jira, Zypher scale. Highly analytical with strong critical-thinking, problem-solving abilities.

Overview

7
7
years of professional experience

Work History

12.2021 - Current

08.2017 - 12.2021

Education

MCA -

BITM, Ballari, Karnataka
01.2011
Aggregate: 72.18%

BCA - undefined

National College, Bellary, Karnataka
01.2008
Aggregate: 70.15%

Skills

  • SQL Developer
  • DBeaver
  • Talend
  • Informatica
  • Beyond Compare
  • Selenium
  • Jira
  • Windows XP
  • 7
  • 10
  • 11
  • UNIX
  • SQL Server
  • MySQL
  • Oracle 12g
  • Teradata
  • GreenPlum
  • PostgreSQL
  • AS-400
  • AWS-S3
  • AWS-Athena
  • Kafka
  • IntelliJ
  • Eclipse
  • NetBeans
  • Excel
  • Power BI
  • Zypher Scale
  • Confluence
  • Bit Bucket
  • Java
  • Python
  • HTML
  • CSS
  • JavaScript

Languages

English
Upper intermediate (B2)

Timeline

-
12.2021 - Current
-
08.2017 - 12.2021
BITM - MCA,
National College - BCA,

Projects

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.

Projects

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.
Basavaraju Y.N.ETL test Engineer