• Over 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 CUBE
• Extensively 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 project
• Experience 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/Teradat...