Job descriptionOver 9+ Years of Experience in IT and Data warehousing, ETL (Extract, Transform and Load)Experience in Informatica (Power center / Power Mart / Power Exchange).Experience in SQL Server with CUBEExtensively experience on ETL Informatica Transformations using Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator and created complex mappings.Experience in implementing the entire life cycle of the projectExperience in Unix Shell Scripts for automation of the ETL process.Should be able to provide the end to end architecture of the ETL process for loading staging / landing zone and audit control process.Experience in creating detailed technical design documents, including the Source to target mapping docs.Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins, and hash indexes in Oracle / Teradata and Postgre SQL databases.Expertise in Data modeling techniques like Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.Experienced in the Performance of Mapping Optimizations in Informatica.