Data Engineer
CurrentSAP Replication Server (SRS) Admin• Configuration, maintenance and troubleshooting of SAP Replication Server & SRS Rep Agent.• Replication setup between MSSQL & Oracle to HANA• Replication setup between Oracle to Oracle• Support during Source OS and Database migration activity• Day-To-Day customer request• Table inclusion and exclusion from replication• Column inclusion and exclusion from replication• Column length & data type change of Table materialization•… Show more SAP Replication Server (SRS) Admin• Configuration, maintenance and troubleshooting of SAP Replication Server & SRS Rep Agent.• Replication setup between MSSQL & Oracle to HANA• Replication setup between Oracle to Oracle• Support during Source OS and Database migration activity• Day-To-Day customer request• Table inclusion and exclusion from replication• Column inclusion and exclusion from replication• Column length & data type change of Table materialization• Support During activitiesSAP Landscape Transformation (SLT)• Table inclusion and exclusion from replication• Column inclusion and exclusion from replication• Starting Replication of Newly added Table• Support During Activities• Extensively involved in Data Extraction, Transformations, Loading (ETL Process) from Source toTarget system using Informatica.• Worked extensively with Designer tools like Source Analyzer, Target Designer, TransformationDeveloper and Mapping Designer.• Created the mappings using almost all the transformations like Source qualifier, Expression,Filter, Aggregator, Joiner, lookup, Router transformations etc• Worked closely with business analysts and gathered functional requirements. Designed technicaldesign documents for ETL process.• Experienced in using parameter files, mapping parameters, mapping variables and sessionvariables. • Experience in the performance tuning and optimizations of mappings in production. •Experience of conversion from ‘OWB’ to ‘Informatica’ mappings.• Have worked from start to finish on development projects, grasping the understanding of entireETL development life cycle.• Responsible for requirement definition and analysis in support of Data Warehousing efforts. Monitoring Airflow jobs in production and Monitoring Azkaban Workflow and Job Show less