Tirth G.

Experience

1. Etl Informatica Developer

   UPMC

   Jan 2022 — Present · Pittsburgh, PA, US

   Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements. Experienced in doing performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating the with tuning methods. Worked with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model. Involved in enhancements and maintenance activities of the Enterprise Data Warehouse. Communicated with business customers to discuss the issues and requirements. Modified UNIX scripts to run informatica workflow. Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression,Update Strategy, Transaction Control and Sequence Generator. Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables Development of A2A Integration processes using Informatica Cloud Real Time (ICRT). Implemented Change Data Capture (CDC) for handling delta loads. Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment. Oracle, DB2, My SQL, Flat Files and XML Files. Used Informatica file watch events to pole the FTP sites for the external files. Worked on building Service Connectors, application connection and process objects that are used for the development of ICRT/IICS processes. Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load into Teradata Warehouse. Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata SQL. Experience in Designing and developing data integrations using Informatica Cloud (IICS). Production Support has been done to resolve the ongoing issues and troubleshoot the problems.