Occupation:Datawarehouse Designer |
Location:Kendall Park, NJ |
Education Level:Master |
Will Relocate:YES |
Description
Determines Customers Business Requirements and establish a strategy / road map for DW/ETL solutions. * Provide ETL Implementations from inception to final implementation to meet Clients deliverable and deadlines. * Executed Client Assessments, Designs, Specifications, Data Mapping and Test plans/scripts. * Performance tuning and Optimization techniques. * Extensively worked on Informatica tools Repository manager, Designer, Work-flow manager, Work-flow monitor. * Hands on databases like Oracle 11i/10g/9, MS SQL server 2005/2008, DB2, Teradata. * Use of Database tools such as SQL*Plus, Toad, SQL Navigator, SSIS . * Experience in usage of Operating Systems such as UNIX, WINDOWS XP/NT/2000/98/95. * Hands on languages such as C, SQL, PL/SQL, XML. * Created mappings using the transformations like Source qualifier, SQL, Aggregator, Expression, look-up, Router, Filter, Update Strategy, Joiner, Stored procedure and etc. transformations. Client Engagements Details Tiffany & Co., Inc. Duration: Jun 2017 -Till Date Informatica Lead Developer The Tiffany and Co has wide variety and rarity of colored gemstones make these distinctive sectors a rich and fascinating field. Some colored gemstones were discovered for the first time in recent decades, while others form a cultural tradition in communities where they have been mined for generations. * Created mappings to actively load data from various sources like DB2, Flat Files, XML, Oracle databases into Schemas like MIPDC, MIPS, JDEE1, COUPA, TRDM for RF China & NAPAC project. * Worked on Tiffany prestigious project to load data into POS server from various source system which includes accommodation of prices from many countries. * Created active reports for the users when Enhancements and Adhoc requested. * Worked with business closely in getting requirements and thoroughly understanding requirements and created a design data flow. * Preparing all SDLC documents which includes IDM, IFS, IQOQ, Unit testing document, IDD and then load the same in Documentum and Share Point. * Performed various smoke tests with business in Test and UAT environment. * Worked on providing data related to Inventory balances, Reconciliation, Purchase orders, Invoices, Units on replenishments for Retail Stores * Involves in maintenance issues, analyzing data discrepancies, enhancements and providing resolution for technical issues. Environment: Informatica Power Center 10.2, SQL Server 8.0, Oracle 11g, Toad 11g, Visio ALM Version 11 Unix Script.