Rupesh Katkar

About Rupesh Katkar

I am a senior Informatica and AWS Administrator & Architect with a very strong professional background in Data warehouse domain. More than 18 years of industry experience in working in data warehousing projects in financial/retails domain. I have extensive knowledge of ITIL processes used in change,problem and incident management.• Excellent knowledge of Informatica\'s product suite including PowerCenter,Data Services, Metadata Manager and Data quality tools• Experience in software Installations, upgrades, applying patches, fixes and maintaining production and non-production environments. • Strong analytical, technical skills in architecture and administration using ETL applications with overall product knowledge• Hands on experience on tools like AutoSys, tidal, CA7 Scheduler • Expertise in setting up best practices, designing the platform architecture and maintaining the UNIX based Informatica systems. • Establishing the best practices and standards, automation and code review in Informatica ETL environment.• Strong knowledge on UNIX operating side along with shell scripting Certifications (Technical/Domain)• Informatica Data Integration 9.x Administrator• Informatica Certified Professional – Cloud Data Integration Developer• Informatica Certified Professional – Cloud Application Integration Developer• ITIL(Information Technology Infrastructure Library) – Foundation Certificate• AWS Certified Solution Architect – Associate• AWS Certified SysOps Administrator - Associate

Experience

1. Informatica Administrator & Architect

   MUFG

   May 2015 — Present

   Lead Administrator and Architect working with onshore/offshore team•Project Technical Lead for Informatica Upgrade 9.X to 10.X.•Working as a DWH platform engineer in Data Governance and Application Support Team managing data integration platforms like Informatica Powercenter,Data Quality,data validation tool(DVO),and Informatica Cloud Services(ICS)•Managing domain, nodes, licensing server, services and security of platforms•Installation & Configuration of Informatica PowerCenter 9.X/10.X.•On-call support for 24*7 on rotation basis•Responsible for setting up end to end application Infrastructure, including creation of users, security groups, security configuration, application folders and id’s, setting up.profiles, parameters, environment variables etc. •Involved in migrating of informatica & UNIX components across environments and to Production using Informatica’s deployment groups, Folder Copy, xml and repository restore.•Developing several reusable scripts which include Informatica service Monitoring, Backups, Generic workflow script, server monitoring scripts. User & connection creation, permission assignment•Design, architect and develop UNIX security for data warehouse platform,• Developing IICS mapping using flat file, SQL Server and Oracle as sources and Target•Using synchronization tasks for syncing data from Salesforce to CRM applications•Configuration of Mass Ingestion and Data Replication tasks for backup and offline reporting•Using application integration, processes and guides to integrate with other enterprise applications.•Creating APIs, service connectors and app connection for application integration.•Invoking IICS tasks using REST API and File listener events•Developing windows batch and UNIX shell scripts for the ETL purposes•Configuration of RunAJob utility to trigger IICS jobs via enterprise scheduler.•Migration of IICS assets across environment using Import/Export•Participating in POC exercises involving IICS

Education

• Pune Institute of Computer Technology

  Bachelor's degree(Computer Science and Engineering), Computer Science

  2001 — 2005