Good knowledge in ETL that involves converting the Informatica Mappings to SQL queries to extract the data from various data sources and apply the transformation rules to load data to the target database. Worked in MySQL, Oracle, DB2 using tools Toad for Oracle, SQL Server and Toad Data point.
Experienced in statistical methods to analyze data and generate useful business reports. Working with business counterparts for delivery excellence. Data Mining, Data Segregation and Data mock up for all possible scenarios.
Part of Automation using Selenium in Eclipse IDE for a Bank client. It involves the handling of Programs and Projects creation across the entire Bank and tracking the status of each Risk, Issues, Program Objective, TBO, Resources across the bank based on the progress and the charge code assignment.
Requirements gathering and discussion with the Clients/Onsite to understand the Business Logic. Preparation of High level Test scenarios covering all Business and Functional requirements.
Involved in Cloud Migration project which is a platform migration from Netezza to EXADATA(Oracle) using ETL. Automated scripts to join data between cross database's using excel macros.
Developed a module in Ariba Application using Python.
Involved in Report generation pulled from HP QC ALM using data virtualization tool Tableau through Automated excel VB macros.