Akash Katagi

Having 3+ years of experience in Software Testing which includes ETL/DWH Testing

Having 2 years of experience in Application Support

Having 1+ Years of experience in Functional Testing

Good knowledge on Data warehouse concepts like Star schema, Snowflake schema, fact table, dimension table etc.

Worked on data migration from SSIS to Talend tool and database from SSMS to SNOWFLAKE.

Hands on experience in writing advance SQL Queries.

Having good knowledge on Database Testing defect analysis, functional testing, STLC, SDLC modeling, Agile methodology.

Hand on experience on Quality Center and Jira.

Extensively used Workflow manager, Workflow monitor in Informatica ETL tool.

Experience and knowledge in the Data Warehousing using Data Extraction, Data Transformation and Data Loading ( ETL ).

Good knowledge in Slowly Changing Dimensions (SCD), knowledge of different Schemas.

An exceptional performer with the ability to work in teams as well as excellent communication, analytical, relationship management and problem-solving skills.

Project #4 : Charles Schwab Client : USA

Tool : Informatica Power Center 9.6, Jira, SQL Server, Quality Center

Role : ETL Test Engineer

Description: This project is developed for Charles Schwab an investment Brokerage provider in USA. This project deals with the company's customer, policies, Claims. In Data warehousing project, data is collected from different locations and convert, extract and cleanse, process and transforming it and loading in to the target databases. We can have the information regarding the number of new customers joined, the percentage of growth of customers and also gives the dropout ratio of customers, polices that are making good business.

Responsibilities:

• Involved in functional study of the application.

• Running the Jobs/Workflow for ETL process.

• Prepared and ran SQL queries to verify Dimensional and Fact tables.

• Verifying the data in target database after ETL process.

• Performed column data mapping between source & target database.

• Prepared test data for testing.

• Verifying the data which is loaded into target database.

• Interactions with BA & Dev teams to resolve the issues.

• Reporting daily testing status report.

• Developed, Reviewed & Executed Test Scripts and Designed test data.

• Identified Test Scripts for Regression testing.

• Defect Analyzing and Reporting in QC

Project #3 : Hartford fund account Client : USA

Environment : SSIS, SSMS, SnowFlake, Jira

Role : Software Test Engineer

Description: Hartford fund account is a mutual funds company in USA and deals with the customer account details which includes Accno, active date, company name, amount etc.

This project is a data migration project, we are migrating data from SSIS to snowflake database Talend etl tool.

Responsibilities:

• Understanding various Business requirements

• Validating the source and DB object validation

• Staging validation

• Business logic validation and load strategy

• Verifying the data in target database after ETL process

• Verifying the data which is loaded into target database

• Interactions with BA & Dev teams to resolve the issues

• Reporting daily testing status report

• Defect Analyzing and Reporting in QC

Project #2 : Healthcare-Retail-Enrollment Client : HCSC, ILLINOIS, USA

Role : Programmer analyst

Description: The project involves the analysis, design, support and maintenance of prototype for an healthcare. Policy maintenance system to maintain the database of products of HCSC, united states of America, this project will be executed using onsite-offshore model.

The objective during this service phase is to maintain the application availability to the business users, provide break fixes to production issues within the service level defined and agreed upon.

Responsibilities:

• Worked closely with confidential clients to establish problem specifications and system designs.

• Preparing the daily, Weekly and Monthly health check reports for all the applications

• Checking all the Mainframe Jobs Triggered automatically as per the schedule in production environment

• Resolving the error by checking the logs

• Reporting the code related errors to the concerned team by raising the incidents on Service now

Project #1 : Food Delivery Enrollment Client : India

Role : Engineer Trainee

Description: Swiggy is an Indian online food ordering and delivery company. Founded in 2014, Swiggy is headquartered in Bangalore and operates in more than 580 Indian cities, as of July 2023. Besides food delivery, the platform also provides quick commerce services under the name Swiggy Instamart, and same-day package deliveries with Swiggy Genie.