Informatica Powercenter Development

• 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.

Have 10+ years of experience in Informaitca Powercenter,Oracle,Pl/sql Have delivered multiple datawarehousing projects successfully and received clients appreciation

Good morning. The requirement is not that clear. if its clear i can explain the possibilities and the estimation for the work. i assure that the same can be closed before estimated time.

I got 3 years of experience in the Informatica tool right from migration to data analysis using Powercenter, IDQ, MDM. I'm looking for this project to understand the mapping logic for reducing the load on the server.

Hi, I have more than 9 years of experience into ETL and DWBI using informatica, oracle, SQL server, snowflake cloud data warehousing and more.. do let me know if you want to have a quick discussion. Thanks and Regards. Vishnu Vardhan

I have 14 years experience in datawarehousing and ETL projects and worked on multiple technologies like Datastage teradata also have informatica knowledge.

5.5 years in development of informatica power center development Relevant Skills and Experience 5.5 years in informatica powercenter development

I have extensive 5 years experience in working with ETL and DWBI (Informatica 9.X/10.X, Oracle 12g, Unix shell scripting). I have created,unit tested and scheduled workflows for simple and complex business requirements. Have worked with variety of sources and targets. Have optimized complex mappings, workflows and Source Qualifier queries. Have worked in partitioning of the mappings. I have also handled Informatica developer and Datastage in my projects.

Enthusiastic and dedicated professional with an experience of close to 11 years in Informatica and datawarehousing concepts. Have worked in various domain. Do have knowledge of Finanace and Telecomm. Have extensively worked with Database ( Oracle, Netezza) and Flatfile . Jist of my profile • Having a good experience in data analysis. Worked as business analyst to understand the business, and develop the solutions for Forecasting area. • Analyzing forecast performance over time and implementing model adjustments and refreshes when necessary • Exposed to Data modelling in business intelligence environment • Good knowledge on SQL queries. • Good understanding of PL /SQL • Worked on writing the PL/SQl procedures and functions. • Good understanding of Star and Snowflake Schemas • Knowledge of business application, business dataflow and data relation. • Good understanding in DW concepts, Informatica ETL tool and basics of Tableau reporting tool • Have an exposure to Phython. • Worked extensively in SQL server 2005 • Good exposure with Oracle 10g • Good exposure with unix scripting • Good exposure with Netezza database •

Diligent and productive ETL code developer. Worked on data extraction, Transformation and loading data from Salesforce, Oracle, SQL Server and Flat files using IICS and powercenter

• Experience in Analysis, Design, Development, Implementation of Data Warehousing using Informatica Powercenter. • Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets. Involved in Unit testing, System testing to check whether the data loads into target are accurate. • Developed database objects like Stored Procedures, Functions and Packages using SQL and PL/SQL.

Worked on informatica power center 10 in a reputed MNC TCS

I have 7+ years of experience in informatica power center , SQL, Unix scripting. I have worked in various domains such as banking and insurance.

I have 13 yrs of experience in IT industry. Working on ETL informatica power center, datastage support, SQL server, Oracle 11g , 12 c, db2 Unix, and mainframes. Invil