About Me
I have overall 8+ years of experience in Denodo, Snowflake,Azure Databricks and Informatica Power center
... Show MoreSkills
Development Tools
Others
Positions
Portfolio Projects
Company
PPL Corporation(Enhancement and Production Support)
Description
· 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.
Show More Show LessCompany
Invetment Banking (Ameriprise)
Role
DevOps Engineer
Description
· 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.
Show More Show LessTools
UNIX SHELL SCRIPTINGCompany
Wellpoint
Description
§ 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 .
Show More Show LessTools
UNIX SHELL SCRIPTINGCompany
Market Basket
Description
· 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.
Show More Show LessTools
UNIX SHELL SCRIPTINGCompany
Petsmart-Pet Retail
Role
Backend Developer