Sudheer T.

About Sudheer T.

Around 13+ years of experience in ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica Power Center, Power Exchange CDC, Informatica Intelligent Cloud Services (IICS). • Created various mappings using transformations like Aggregator, Source Qualifier, and Connected/Unconnected lookup, Update Strategy, Joiner, Filter and Router Transformations.• Integration of various data sources like Oracle, SQL Server, Flat Files, into Data Warehouse and also experienced in Data Cleansing and Data Analysis.• Very good experience in the Informatica Intelligent Cloud Services (IICS).• Very good experience in upgrading the Informatica 9.6.1 to 10.1.1.• Very good experience in upgrading Informatica 10.1 to 10.5• Actively involved in the preparation of ETL coding standards and checklists, code reviews, working with business users on UAT test scenarios• Design, develop and customize mappings/workflows for incremental load using Informatica BDM• Created Informatica BDM parameter sets & parameter files for daily & delta loads• Involved in developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.• Performance Tuning for targets, mappings and sessions, Task Automation using UNIX Shell Scripts, Job scheduling and Communicating with Server using pmcmd.• Provided data matching, data cleansing, exception handling, reporting and monitoring features to the data warehouse.• Informatica Power Exchange for loading/retrieving data from Oracle and MS SQL server system.• Installing and configuring the Informatica PowerExchange servers on Windows and UNIX for Oracle and MS Sql server.• Collecting and analyzing user’s requirements for new reports in Data Warehouse• Experience, spread across Cloud Strategy/Solutions/Architecture, DevOps, Operations & Infrastructure, Mobile, storage & web Technology.Operational and information technology functions include business analysis, requirement gathering, software development and support, internet technologies, systems architecture and integration.Cloud Platforms, Container Orchestration Engine - Kubernetes, Infrastructure/Configuration Automation, SOA, ITIL, Logging and monitoring solutions, Digital pipelines, Networks, Load Balancing, Security & Systems.• Provide 24 x 7 on-call rotational support including troubleshooting and issue resolution on priority• Documented the best practices for development and administration

Experience

1. Lead Technical Consultant

   Conduent

   Nov 2018 — Present

Education

• Bharathidasan University

  Master's degree, Computer Science

  2001 — 2003

• MPC college fo Art and Science Thanjavur

  Master's degree, Computer Science

  2001 — 2003