Yes Telecom Netherlands is a telecommunication service provider and positioned as a mobile virtual network operator (MVNO). The company is engaged in rendering prepaid & postpaid mobile services including SIM contacts, low cost calls, high quality international mobile services using GSM technology, and standard activation services. Furthermore, the company operates and maintains more than 300 business partners across the country for rendering their full range of services including top-ups, International phone cards, and related accessories etc. Apart from this, Yes Telecom is fostering a number of further steps in the service territory for extending its services and product portfolio, such as catering benefits to loyal customers, and offering services and products with considerable added value for the targeted group. The company is headquartered at Leiden, the Netherlands.RESPONSIBILITIES:Involved in Designing the mappings between sources and targets and tuned them for betterPerformance.Created and monitored the workflows using Workflow Manager and Workflow Monitor and the log.Modified mappings to obtain correct results from the transformation.Worked on Informatica tools - Source Analyzer, Warehouse Designer, , and Workflow Manager.Transformations like Source qualifier, Lookup (connected and unconnected), Aggregator, Expressions, Update, Filter, Joiner is mostly used.Worked with all types of caches.Worked with Admin activities.Creating and restoring the repository contents.Assigning privileges to the users.Involved in code migration.Involved in UNIT testing of the code.Extensively worked with Production support.Handled Tickets raised by the users and ensured to close them in the given SLA.Project #2Project Name : BANKING AND FINANCE SERVICES.Client : OLD NATIONAL BANK, EVANSVILLE (INDIANA).Duration : NOV 2013 to JAN 2015.Role : ETL DEVELOPER

Old National Bank is a multi-state Financial Services company Headquartered in Evansville, Indiana. As the largest Independent banking company Based in Indiana, It is providing to customers with a comprehensive range of financial Products and services, including Commercial and Retail Banking, Credit Card Services, Electronic Banking, Trust and Asset Management, Brokerage and Insurance Services.Main objective of this project is we are providing a system with all the information regarding Transactions of entire banks all over the country. We will get the daily transaction data from all branches at the end of the day. We have to validate the transactions and implement the business logic based on the transactions type or transaction code. We have to load all historical data into DWH and once finished historical data. We have to load Delta Loads.RESPONSIBILITIES:Extensively used unconnected Lookups, Filter, Router, Aggregator, Expression, Update strategy.Tuned existing mappings, targets, sources, and sessions to improve the performance.Used mapping parameters on different mappings and sessions, based on various business requirements.Involved with fixed width flat files Source systems.Developed mappings that incorporated logic needed to handle inserts and updates to the existing targets. To keep track of historical data slowly changing dimensions are implemented.Extensively worked with enhancements.Created reusable code and called in different mappings.Worked with mapping parameters, variables and session parameters.Worked with slowly changing dimensions.Involved in Unit testing.Involved in Performance tuning.Involved in code migration.Handled support environment.Project #3Project Name : Retail Sales Warehouse

Hi this is Lava kumar I have 4 years of experience into data warehousing. My complete experience lies with informatica.my role and responsibilities are:Creating mappings, sessions, workflows as per business Requirement. and also implementing error handling strategies, after completing that we used to do test the mapping with all type of test scenarios, code reviewing , code migration.and support said also maintain the application..

Working as an ETL Developer in Mind tree private Limited From Nov 2013 to till date.; Project #1Project Name : TELECOMMUNICATIONS.