Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Educationprofile
Timeline
Generic

Ananda Shatty

Bengaluru

Summary

To pursue a career in IT Industry, using my skills and abilities to grow professionally and become an asset for the organization.

Overall, 8 years 2 months of experience in Software IT industry as Software QA Engineer Extensive work experience in Regulatory Data Testing on AWS cloud using Qubole, S3, SQL Developer, Toad, CyberArk, JIRA Cloud, Git Lab, X-RAY, Putty & WinSCP Extensive work experience in ETL Testing in Oracle and Informatica. Hands on experience in writing and executing SQL Queries. Hands on experience in Qlik Sense reporting tool to test BI reports. Extensive work experience in Sanity testing, Functional testing, Integration testing, System testing, GUI testing, some experience about database testing, Regression testing according to the testing plan activities. Experience in Financial Regularity and Health care domains. Involved in the Designing, Preparing, Execution and Maintenance of the test cases. Involved in the preparation of Functional and Sanity Test cases. Participated in all phases of project lifecycle, including, understanding the requirement from Tier-3 System Engineers/End-Users, Requirement Analysis, System Testing, User Acceptance Testing (UAT) Environments, Support and Documentation. Used the Qubole analyser, Automic, PL SQL and JIRA Cloud CI/CD pipeline Deployment tools to run jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse system. Well versed with all the stages of SDLC (Software Development Life Cycle), STLC (Software Test Life Cycle) and Defect life cycle. Analysis of business requirements and change request Specifications by interacting with users, Coordinate with on site and offshore teams on project status calls and discussions. Ensuring timely completion and delivery of project to the client, extending production support of multiple applications. An effective communicator with strong analytical, logical thinking & problem-solving abilities. Commitment to co-operative teamwork and involved in delivering high quality product to client. Good communication and interpersonal, ability to learn quickly and work within tight deadlines Experience in working with JIRA Cloud and X-Ray.

Overview

9
9
years of professional experience

Work History

QA Developer

IG INFOTECH(INDIA) Pvt. Ltd.
06.2021 - Current
  • Company Overview: IG will develop the technology, platforms, products, and exchanges and opening a wider range of trading and investment opportunities to the people around the different countries
  • Prepared detailed QA documentation like test plan, test scenarios using JIRA stories and X-Ray
  • Performed end-to-end testing by coordinating with other team members of the IG
  • Involved in the various AGILE meetings to get the clarification on story requirements
  • Involved in the python automation tool features enhancement and added multiple features to smoothen the testing activities
  • Involved in the entire testing/development phases like requirement gathering, code design, TC preparation, grooming, testing and BAT user acceptance
  • Involved in multiple testing phases like file loader, table data loader, data golden gating, data streaming through kafka persistor, data transformation into multiple target schemas and report generation, Prepared SQL queries to verify the data and functionality
  • Communicated with developer through all phases of testing to prioritize the bug resolution
  • Running the Jobs/Processes for ETL process to perform functional testing
  • Performed DDL checks on Column Mapping between source and target databases
  • Designed and maintained the test cases on X-RAY test management tool
  • Involved in multiple testing types like Integration, system, requirement and performance
  • IG will develop the technology, platforms, products, and exchanges and opening a wider range of trading and investment opportunities to the people around the different countries

ETL Tester - Senior QA Engineer

IMS HEALTH ANALYTICS SERVICES Pvt. Ltd.
11.2018 - 05.2021
  • Company Overview: IMS One is data factory that loads different data from various sources of HCO and HCP
  • IMS One consolidates data from different source systems, performs the ETL activities such as querying the source table/file, performing the required transformation logic (trimming/converting), applies MDM over data and then provides the required reports to clients
  • Understanding Users requirements all the business rules in the requirement document
  • Writing Test cases
  • Sanity check
  • DDL check
  • Functionality test (validating transformation, remaining business rules, retesting, regression testing and production issue test)
  • Performance test
  • SCD check
  • Source parquet files validation in S3
  • Data load into stage by Spark code then staged data validation
  • Data load from Stage to Reltio by informatica then Reltio data validation
  • Data extraction from Reltio to Hive then Hive data validation
  • SCD check for all the Dimensions file
  • IMS One is data factory that loads different data from various sources of HCO and HCP
  • IMS One consolidates data from different source systems, performs the ETL activities such as querying the source table/file, performing the required transformation logic (trimming/converting), applies MDM over data and then provides the required reports to clients

QA Specialist

Infosys Limited
05.2018 - 11.2018
  • Asset management, broadly defined, refers to any system that monitors and maintains things of value to an entity or group or ethnic groups
  • Asset management is a systematic process of deploying, operating, maintaining, upgrading, and disposing of assets cost-effectively
  • Finance Department is responsible to maintain Master Data related to Products, Suppliers and Manufacturers, Employee, and their level of authority information
  • The goal of the project is to develop strong database technology that will extract and transform the data collected and load into DWH
  • For decision in each level with proper data

Tester

HCS Technologies Pvt. Ltd.
08.2015 - 05.2018
  • Involved in System Testing and Running the jobs for ETL process as when needed
  • Verifying the ETL data in target database and data validations between source & target tables
  • Interactions with BA & Development teams to resolve the issues

Education

B.E - ISE

JSS Academy of Technical Education
01.2015

Diploma -

Govt, Polytechnic College
01.2011

Skills

  • ETL Testing
  • Database Testing
  • Big Data testing
  • Informatica PC 95
  • PL-SQL ETL Framework
  • Power BI
  • SQL
  • PL-SQL
  • Unix Commands
  • Basics of python
  • Oracle 11g
  • AWS Cloud
  • Spark
  • Scala
  • GIT Lab
  • Windows
  • Unix
  • TOAD
  • Qubole
  • AWS S3
  • SQL Developer
  • Qubole Analyzer
  • Automic
  • PL-SQL Deployment tool
  • Oracle
  • IMSONE Data Warehouse
  • JIRA Cloud
  • X-RAY
  • Functional testing
  • Manual testing
  • JIRA management
  • User acceptance testing
  • Git version control
  • Regression testing
  • Integration testing
  • Test case management

Languages

English
Kannada
Hindi

Personal Information

Date of Birth: 10/18/92

Educationprofile

  • B.E (ISE), JSS Academy of Technical Education (VTU University), Bengaluru, 2015
  • Diploma, Govt, Polytechnic College (DTE University), Raichur, 2011

Timeline

QA Developer

IG INFOTECH(INDIA) Pvt. Ltd.
06.2021 - Current

ETL Tester - Senior QA Engineer

IMS HEALTH ANALYTICS SERVICES Pvt. Ltd.
11.2018 - 05.2021

QA Specialist

Infosys Limited
05.2018 - 11.2018

Tester

HCS Technologies Pvt. Ltd.
08.2015 - 05.2018

Diploma -

Govt, Polytechnic College

B.E - ISE

JSS Academy of Technical Education

Similar Profiles

CREATE PROFILE
Ananda Shatty