Prabhu M

Total 5 years of Experience in IT industry and Perform ETL testing, Manual Testing and Database testing with skills of Oracle SQL, UNIX, JIRA and ETL concepts.
• Expertise in Extraction Transformation and Loading Data from various sources into Data warehouse
• Proficient in SQL queries and SSIS Validations had worked with database objects using Group function, Analytical function, Joins, Set operators and Sub Query.
• Having knowledge in UNIX navigating like Vi editor, Grep, Sed, Find, Awk commands.
• Experienced in writing test cases, executing test cases and reporting defects by using of defect tracking tool with proper severity and priority
• I have worked into various ETL schema architecture like Fact and Dimension tables and star and snowflake schemas
• Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Having good knowledge on Agile Methodology and waterfall
• Clear understanding of business requirements, validate mapping sheet and ability to work as a team.
• Knowledge and experience with Business Intelligence (BI) data warehousing environment.

I have used Oracle SQL and UNIX to validate various data environments. In my Project I have created Test scenario document and test case document and also, I have validated ETL mapping document and I have created Test case actions based on that. Have hands on in SQL Query Writing, and able to build SQL Queries using of Subqueries, Joins, analytical functions and group functions. I have knowledge in UNIX commands like grep, Sed, find, awk to validate source as files. I have worked into various ETL schema architecture like Fact table, dimension tables and Star schema and snowflake schemas. I have performed data quality validations which includes Row count checks, Sample data validations and entire data validations. I have used SQL Query techniques to validate the various database environments. Have worked with SSIS team for migration and used SQL Developer to connect the databases. We are using JIRA as ticketing tool and we are following AGILE SCRUM methodology. Based on the RSD document we will prepare the test case document. By using of the mapping document we will create test scenario document. For Each scenario we will create the test cases - Here for one scenario we have to create multiple test cases. Here we will check the data structure validation and column name data type and data length validations. And we will understand the business rule and we will apply the business rule in the source SQL and we will do the minus operation. For each test case I will create test scripts, it contains the complete technical coding like SQL and UNIX scripts. Then I will execute the test scripts in the source and target environment, I will fill our test results. By using of the traceability matrix document, I will ensure all the requirements are coming under the validation or not. If everything is going fine then I will work for the test closure reports and sign off activities. 

Apr 2012 – 2016 B.E - Mechanical Engineering
Kurinji College Of Engg & Tech, Trichy