I am working as a Denodo developer and Snowflake Developer

· Teamed with business analysts to deduce the business requirements to produce effective technology solutions.

· Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.

· Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.

· Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.

· Participated in the development and implementation of the MDM decommissioning project using InformaticaPowerCenter that reduced the cost and time of implementation and development.

· Worked on data cleansing using the cleanse functions in Informatica MDM.

· Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to the data mart.

· Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server

· Extracted data from Sales department to flat files and load the data to the target database

· Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.

· Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.

· Requirement gathering for small development from business users.

· Daily monitoring of ETL Jobs .

· Making enhancements and resolving the batch failures.

· Investigating the issues and fixing the failures.

· Creating service now tickets.

· IBM Infosphere jobs monitoring and fixing the replication issues.

· Running and monitoring the jobs through Tivoli and Cherwell.

· Creation of IDRCDC replication subscriptions.

· Good understanding of Technical Design Document.

· Worked on Informatica Power Center tools like Source Analyzer, Warehouse Designer to import the source and target database schemas. Mapping Designer, Workflow Manger and Workflow Monitor.

· Used transformations like Aggregators, Sorter, lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, Sequence Generator

· Used mapping parameters and variables.

· Created sessions & workflows to ensure the data to be loaded into the specific tables of DWH.

· Configured various tasks in the workflows for the dependency by using Command, Event wait, timer and Email task.

· Involved in unit testing and Performance tuning.

· Optimizing the mappings by changing the logic to reduce run time.

§ Responsible for requirement gathering from different Business users as well as application users

§ Involved in detail analysis of the structure of input/output tables, and the required source to target mapping file.

§ Using Informatica Designer, developed mappings, which populated the data into the target.

§ Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.

§ Understanding business requirement for data acquisition and loading to target .