• Worked on Texas Welfare system and performed productions support requests (PSR).• Develop complex ETL mappings using Informatica Power Center and sessions using Informatica workflow manager.• Dealt with huge data and resolved issues of slowness and tackled performance issues while loading as well as retrieving.• Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.• Worked as a module lead and managed roles and responsibilities for testing, defect fixing, applying performance tuning methodologies and migrating ETL components to DIT (Development Independent Testing), SIT (System Independent/Integration Testing), UAT (User Acceptance Testing) and production environment.

• Used SQL Loader to load data from flat files received from various facilities every day.• Created and modified various UNIX shell scripts according to the changing needs of the project.• Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL and PL/SQL.• Experience in Dynamic SQL, Collections, and Exception Handling.• Created shell scripts and scheduled them using Crontab.• Reported bugs and tracked defects using Jira.• Worked with the ETL developers to get data from various data sources (SQL Server, flat files and XML) and loaded the data into target data sources after performing required transformations.• Worked with Transformations, Mappings, Mapplets, Workflows, Worklets and debugger to find bottleneck in mappings. • Partitioned large tables using range partition technique.• Experience with performance tuning of Oracle database using Explain Plan and Hints to perform cost-based optimization.• Experience in Dynamic SQL, Collections, and Exception Handling.• Created shell scripts and scheduled them using Crontab.• Created stored procedures, functions and packages to move data from the staging tables to the data mart.• Reported bugs and tracked defects using Jira.• Test, debug and take measures for query optimization.• Develop a workflow tool to manage internal processes using JSP/Servlet and JavaScript/JQuery