• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure and Sequence Generator transformations.

• Modified, managed existing partitioned tables and wrote stored procedure to manage newly partitioned tabled.

• Automated Table partitioning using Informatica.

• Implemented Datastaging to perform Incremental Loading and develop IUD Maps.

• Extracted Flat Files (Fixed or CSV) from shared mount port and automated the load process using UNIX Scripting in post-session command task in Informatica Workflow Manager.

• Implemented Informatica CDC by creating new registration using Power Exchange to capture live data.

• Implemented SQL Server CDC by creating new views and subscribers to capture live data within SQL Server Database.

• Implemeted DateControl logic in Informatica to fetch incremental data

• Created and maintained the shell scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.

• Actively involved in on-call support and helped resolve production issues by fixing bugs.

• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.

• Developed Informatica mappings to load the data into oracle database.

• Created the Data Flow Diagrams to check the dependency.

• Scheduling the sessions to extract the data into warehouse database on Business requirements.

• Experienced in creating and implementing changes requests.

Environment: Informatica 10.2/9.6.1, Oracle 12c/11g, SQL server 2016/2012, T-SQL, PL/SQL, Toad,Anthill,Autosys,ServiceNow, Unix, Tortoise SVN, Flat files.