Rathan Tej Korrapati

6.7 years of experience in ETL Testing/DWH Testing, Database testing, Functional testing. Expertise in working on different ETL tools like Informatica, Control M, AbIntio, PostgreSQL, DataStage, SSIS. Expertise in working testing ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.x Expertise in working on different schemas like Star Schema, Snowflake Schema and Fact Constellation Schema for validating the fact and dimensional tables and their structures. Worked on different databases like MS SQL Server, MySQL, IBM DB2, MongoDB, Oracle for validating the stored procedures functions, triggers, cursors, tables, views, synonyms, sequences and writing complex queries to validate the data. Extensively used Informatica PowerCenter client modules Informatica Designer, Workflow manager and Workflow monitor for Testing and monitoring workflows, worklets, sessions, mappings and mapplets. Experience in using Informatica Developer Client (IDQ) for analyzing and validating the quality of data that is loaded to the target table. Worked on various reporting tools like Tableau, Cognos, Power BI, SSRS, Qlik and MicroStrategy for validating the data in the reports against the data in the database. Worked on scheduling tools like Control M and Tivoli for validating the schedules and properties of the jobs. Worked on different Project Management Methodologies like Waterfall, Agile with scrum, Safe and Kanban process. Experienced in analyzing and validating complex Stored Procedures, Functions, Triggers, and cursors for data being populated to the target table. Experience in working on Microsoft SSAS for analyzing and validating complex Cubes with complex Facts and Dimensions for validating the different types of aggregations and measures. Experience in working with different test management tools like HP QC/ALM, Jira, Bugzilla and TFS for writing and executing test cases, uploading test results and logging defects. Experience in using UNIX commands (PUTTY) for creating, editing, copying, moving files, changing permissions, creating and removing directories. Experience in using Beyond Compare for comparing folders and different types of files and listing out the differences between the different versions of files and folders. Experience in using WINSCP for transferring the files from one server to another server and creating and deleting files and directories. Experience in using TEAM FOUNDATION SERVER (TFS) for creating tasks and logging hours for maintaining track of user stories across the project for different teams. Good knowledge in using internal tools created by client for Cleansing/Scrubbing the source data to bring the data for processing. Good knowledge in using internal tools for validating the different types of source files against the data loaded to the tables. Worked with different types of code promotion tools to check the implementation of different versions of codes for validating. Got trained in ICEDQ for automating the different types of validations that are regularly performed in ETL Testing. Good knowledge of OOPS concepts in Core Java and Load Runner used for performance testing. Good knowledge of IICS concepts like Integration cloud, Data quality & Governance cloud, Master data management cloud, Data security cloud. Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Experience in creating Test Strategy, Test Plan, Requirement Traceability Matrix, Defect summary Document and test summary documents. Experience in analyzing and validating PowerShell and Shell Scripts used in control jobs for validating and loading the data. Experience in Validating the API for JSON and XML and running the end-to-end flows for validating the data flow from API to Datawarehouse. Experience in training the associates in SQL and ETL testing will provide sessions on different ETL tools used. Highly organized, detailed oriented, able to plan, prioritize work and meet deadlines. Excellent communication, interpersonal, managerial skills and good presentation and technical skills.