·         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 .

·         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.

I am working as a Denodo developer and Snowflake Developer