• Enough IT experience in insurance domain in agile methodology as an ETL developer for large scale data warehouses using Informatica Power Center 9.X/10.X, Informatica power exchange, Oracle 12C R1 (SQL),DB2, Netezza, Unix shell scripting, Autosys, Guidewire etc
• Created mappings, mapplets, sessions , command tasks and Workflows in Informatica power center version 9.6.1 and 10.1.0. Also, scheduled workflows based on load frequencies. Implemented concurrent workflow option.
• Worked with various transformations like Source Qualifier, XML source Qualifier, Expression, Joiner, Filter, Router, Aggregator, Union, Lookup, UnConnected Lookup, Normalizer, Sorter, Update Strategy, Sequence Generator, XML Generator, XML Parser, Http transformation etc.
• Hands on experience in working on large volume data integration projects across disparate data source and target objects (Flat Files, Relational Tables, XML & XSD files,Json files, JMS Queues and Power exchange).
• Experienced at Creating effective Test data and development through Unit test cases to ensure successful execution of the data & used mails for notifying the alerts in case of job failure.
• Experienced in Error handling, Troubleshooting using various log files and problem fixing in Informatica.
• Proficient in writing SQL Queries in Oracle, DB2,Netezza Server. Worked with DDL,DML,TCL,DTL statements. Worked with Single row/Aggregate/Analytical functions. Also, Worked with joins, set operators and subqueries.