Harika Reddy

Experience

1. Sr Informatica Developer

   WEX

   Sep 2020 — Present

   Worked as an Informatica/Data Warehouse Developer and was involved in business analysis, requirements gathering, transforming business requirements and creating source to target mapping and transformation documents. As a Data Warehousing team member, involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using Informatica, PL/SQL and Unix Shell scripts. Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.Developed reusable transformations, mapplets, sessions, worklets to make Informatica code very modular and to reuse as required. Developed complex mappings using Informatica Power Center 9.5 to load the data from various sources like flat files, SQL Server, Oracle into the target Oracle Data Warehouse. Worked on POC to integrate Amazon S3 with Informatica Intelligent Cloud Services (IICS) for processing multiple Parquet files, csv files to SnowflakeInvolved in Data Extraction, Staging, Transformation and Loading and worked with Oracle Application Integration.Experience with Snowflake integration using IICS as source.Experience with IICS AWS S3 integration as the target source.Worked on IICS Data Integration between SharePoint, Salesforce and Snowflake using Data Synchronization,Mapping Tasks and Task flows.Involved in performance optimization of IICS jobs.Migrating PowerCenter mappings to IICS