KENNETH ANTONY JOSEPH

Informatica Product Support Specialist with 18 years of experience at HTC Global Services, focusing on troubleshooting and optimizing data movement processes. Expertise in Informatica Powercenter, PWX, and Mainframe, with a proven track record of leading offshore teams to improve operational efficiency. Recognized for strategic problem-solving abilities and consistently delivering projects on time without escalations. Strong leadership in offshore coordination, production support, and migration projects, aiming to manage projects and utilize analytical skills in a dynamic enterprise environment.

• English
• Tamil

• Father's Name: A. Joseph Britto
• Date of Birth: 11/28/82
• Gender: Male
• Nationality: Indian

• Led the team in technical aspects and coordinated team lead activities, including weekly stand-up meetings, onboarding and training new team members, and addressing issues related to regular support tickets.
• Extensive expertise in Informatica PowerCenter development, administration, and BI/DW solutions, including designing and enhancing ETL processes from diverse data sources such as data warehouses (star schema, snowflake schema), dimensions, facts, OLTP, and OLAP systems.
• Proficient in managing the Informatica Admin Console for setting up and maintaining folders, folder access, user privileges, connection configurations, OSP profile setups, node recycling, log analysis, and lock management.
• Skilled in developing and modifying Linux shell scripts to automate ETL processes and securely transfer files (FTP) from hosts to ETL servers.
• Experience in Java web page development and testing.
• Proficient in writing SQL queries and stored procedures across multiple relational databases (DB2, Oracle, SQL Server, and PostgreSQL), including performance tuning for optimal efficiency.
• Experienced in Perl scripting and Linux scripting for automation and support tasks.
• Strong problem-solving skills and ability to collaborate effectively in a team environment.
• Expertise in Mainframe technologies including COBOL, DB2, VSAM, JCL, and MVS.
• Experienced in creating and managing business rules using RulePoint for PMPO (Proactive Monitoring for PowerCenter - Informatica).
• Developed autoflow code and handled issuance activities at BLDISS.
• Proficient in developing COBOL programs embedded with SQL and JCL procedures, creating Parmlib members, and preparing Run JCLs for testing purposes.
• Skilled in generating reports using SAS.
• Proficient in Informatica installation, configuration, user management, and security, including:
  Creating and managing users, roles, and privileges.
  Ensuring secure access through LDAP/Active Directory integration.
• Experienced in monitoring and performance tuning of Informatica:
  Monitoring workflows via Admin Console and other tools.
  Tuning sessions and workflows for optimal performance.
  Monitoring and optimizing PowerExchange CDC performance.
• Knowledgeable in backup and recovery:
  Managing repository backups and implementing disaster recovery strategies.
• Experienced in patch management and upgrades:
  Applying patches, performing version upgrades, and validating compatibility between PowerCenter, PowerExchange, and source/target systems.
• Skilled in troubleshooting and support:
  Analyzing and resolving server, session, and service errors.
  Collaborating with Informatica Support for resolving critical issues.
• Focused on maintaining a scalable, secure, and high-performing Informatica PowerCenter environment to support business processing requirements.