Technology Analyst
Current• Having 5+ Years of experience as an ETL Informatica Developer and IICS Developer.• Having experience in Design, Development, Analysis and Implementation of Data warehousing Technology by using ETL tool Informatica IICS and Power Centre.• Having experience working with informatica IICS tool effectively using it for data integration and data migration from multiple source system in SQL data warehouse.• Profound knowledge on Data warehouse concepts like Data warehouse, Star schema, Data Marts, Dimension and Fact tables. • Developed Informatica Mappings and Reusable Transformations to facilitate the timely Loading of Data of a star/Snowflake schema.• Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into the target database.• Developed the Informatica Mappings by the usage of Aggregator, SQL overrides usage in Look-ups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router• Good Knowledge in developing SQL with relational databases like Oracle.• Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica intelligent cloud services.• Extensive implementation of various transformations like Filter, Lookup, Expression, Source Qualifier, Aggregator, Sorter, Router, Update Strategy etc. in IICS.• Extensively used mapping Parameters, Mapping Variables• Ensured loading multiple targets in the same mapping by Target Load Order• Identified and tracked and implemented methodologies like Slowly Changing Dimensions using Update Strategy.
