• 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), Unix shell scripting, Autosys, Rally, HP Alm 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, JMS Queues and Power exchange).• Experienced in Error handling, Troubleshooting using various log files and problem fixing in Informatica.• Proficient in writing SQL Queries in Oracle, DB2 Server. Worked with DDL,DML,TCL,DTL statements. Worked with Single row/Aggregate/Analytical functions. Also, Worked with joins, set operators and [login to view URL] with basic UNIX commands needed for Data warehousing projects. Good knowledge in Data Warehousing and Business Intelligence concepts.
Plz check my profile too for more info.