Summary
Overview
Work History
Education
Skills
Certification
New Technology
Roles And Responsibilities
Major Activities
Projects
Timeline
Generic

MOHITH KATARI REDDY

Bengaluru

Summary

2.6 years of professional experience in the supporting Informatica Power Center (Workflow Manager, Workflow Monitor, Repository Manager, and Designer). Informatica Administrator with a strong background in platform support and proven expertise in the stability and optimal performance of Informatica environments. Professional with a solid background in Linux administration, experience in managing and optimizing Linux systems for enhanced performance and reliability, and implementing troubleshooting strategies. Professional with foundational experience in data warehousing. Adept at understanding and contributing to the development of data warehouse solutions. Experience in the deployment process and adaptive with the ability to grasp things quickly and possess excellent interpersonal, technical, and communication skills.

Overview

2
2
years of professional experience
1
1
Certification

Work History

System Engineer

Tata Consultancy Services
01.2022 - Current
  • Currently working in Tata Consultancy Services, Bangalore as a System Engineer from January 2022 to present.

Support Executive

Deutsche Bank
01.2022 - Current
  • Production support (24/7) for Implementing, Testing, and monitoring which includes Informatica Administration, Informatica Power Centre, and platform servers played a role as Infrastructure Admin Support.

Education

Bachelor of Engineering in Electronics and Communication Engineering -

Saveetha University
Chennai, India

Skills

  • Informatica Power Center: Power Center (Workflow Manager, Workflow Monitor, Repository Manager, Designer)
  • Monitoring Tool: Geneos Active Console
  • Ticketing Tool: Service Now (Incident Management, Service Request & Change Management)
  • Tools: PuTTY, SQL developer tool, Artifactory, bitbucket
  • Operating Systems: Linux & Windows
  • Language: SQL
  • Database: Oracle
  • Workflow Design
  • ETL development
  • SQL Programming
  • Data Quality Management

Certification

  • Microsoft Certified: Azure Administrator Associate
  • Agile Way of Working Foundation - Level 2

New Technology

  • Strat working on RHEL 7 servers’ migration.
  • Exporting packages from Bitbucket.

Roles And Responsibilities

  • Administered Informatica (10.5,10.2) production and UAT environments for PowerCenter.
  • Installed and configured Informatica 10.5 environments, successfully migrating existing code from Informatica 10.2 systems.
  • Implemented security measures and user Access controls to safeguard sensitive data in compliance with organizational policies.
  • Actively participated in maintenance tasks, including the application of Patches, hotfixes, and performance tuning, to optimize the efficiency of the system.
  • Worked closely with teams across different functions to understand business requirements and implement data integration solutions accordingly.
  • Generated and analyzed workflow logs, session logs, and error logs to diagnose and address performance or functional issues.
  • Participated in on-call rotation to address urgent issues outside regular business hours.
  • Worked in a support capacity to address production incidents related to workflow failures.
  • Collaborated with development teams to create and configure Repository objects, including Folders, Mappings, and sessions.
  • Worked closely with application users to troubleshoot and resolve issues related to Repository Connectivity.
  • Utilized Informatica Designer to create, modify, and enhance Mappings, Transformations, and workflows.
  • Promoted and deployed PowerCenter code along with shell and batch scripts across environments to assist in development projects and code fixes.
  • Troubleshooting important Production issues like Performance degradation, out-of-memory, Hung Thread, High CPU Utilization, and File system Management.
  • Configure the SSH (Secure Shell) server on both the source and target servers to recognize and accept the provided public keys.
  • Scheduled and monitored recurring jobs in Informatica and enterprise scheduling tools (playbooks) to automate and streamline data integration processes.
  • Maintained regular communications with external stakeholders, addressing queries, providing support, and contributing to overall system uptime improvement.

Major Activities

  • Installed and configured Informatica 10.5 environments and migrated existing code from Informatica 10.2 systems
  • Disaster Recovery activity in all regions.
  • Rebooting the servers in all regions as a part of the yearend process
  • TLS enablement for secure configuration with domain from Informatica tool
  • SSL certificate installation on servers
  • Database switchover via SSP
  • SSH Key configured for Linux servers
  • Netprobe installation on Linux servers to Connect Geneos gateway for Monitoring
  • Upgraded exiting Oracle client from clt12.1.0.2 to ctl19.4.0.0 on domain servers
  • Java SDK Upgrade “1.8.0_211” to “1.8.0_371”

Projects

Deutsche Bank, January 2022 - Present, Support Executive, Deutsche Bank is a leading global investment bank with a strong and profitable private client franchise. A leader in Germany and Europe, the Bank is continuously growing in North America, Asia, and key emerging markets. With over 78,000 employees in over 70 countries worldwide, Deutsche Bank offers unparalleled financial services worldwide. The Bank competes to be the leading global provider of financial solutions for demanding clients creating exceptional value for its shareholders and people.

Timeline

System Engineer

Tata Consultancy Services
01.2022 - Current

Support Executive

Deutsche Bank
01.2022 - Current

Bachelor of Engineering in Electronics and Communication Engineering -

Saveetha University
MOHITH KATARI REDDY