• 4 years 3 months of experience in insurance domain in agile methodology as an ETL developer for large scale data warehouses using Informatica- Power Center, Power exchange, informatica DVO,Oracle, MS SQL server,Azure SQL server, Netezza, Unix shell scripting, Autosys
• Created mappings, mapplets, workflows,worklets,tasks -session,command,email,decision,event,assignment in Power Center
• 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 sources and target objects (Flat Files, Relational Tables, XML & XSD files,Json files, JMS Queues and COBOL files).
• 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,SQL Server. Worked with DDL, DML, TCL, DTL statements. Worked with Single row/Aggregate/Analytical functions. Also, Worked with joins, set operators and sub queries.
• Familiar with Unix shell scripting needed for Data warehousing projects.
Plz check my profile for more info.