Venu Chinthamalla Email & Phone Number

Summary:• 13+ years of experience with all phases of SDLC including Analysis, Design, Development of Data warehousing / Data Integration Projects for Insurance, telecom and Banking Company. • Excellent Experience of Informatica Power Center ETL tool 10X and 9X Versions for developing mappings/Mapplets and create sessions/tasks, workflows for integrating the data.• Very Good Experience with IDMC / informatica intelligent cloud services.• Experience with Azure snowflake.• Excellent knowledge on Azure or Informatica snowflake migration projects • Experience with creating High-level design documents, low-level Design documents, ETL mapping documents based on business requirements• Expertise in developing complex mappings/mapplets/sessions/workflows with IDMC/IICS and Informatica transformations.• Very good knowledge of creating NIFI SQLs to create files which will be used to load in snowflake DB.• Experience in creating SnowSQL scripts to load data from files to snowflake DB.• Worked on Unix/Linux operating systems and experienced in writing shell scripting & PLSQL Scripting.• Extensively worked with various Relational and non-relational sources and target systems including SQLServer, Oracle, PLSQL, Flat files, XML files, snowflake and SalesForce.Com (SFDC) etc.• Experience to create scripts to create jobs using MAESTRO, Control- M, Autosys scheduling tools.• Expertise in identifying bottlenecks and optimizing performance with Informatica mappings, sessions, and workflows. • Excellent knowledge of performance tuning of queries.• Expertise in troubleshooting and analyzing issues/errors and resolving issues.• Well Aware of Agile Scrum Methodology• Expertise in all phases of Project/Software Development Life Cycle phases (SDLC) from Requirements gathering/Analysis/Development & Unit testing/QA Support to Production Deployment. Knowledge transition to Support teams in various projects implemented.• Perform code reviews and execute the unit test cases as per the UTP.• Expertise in using Pushdown Optimization (PDO) technique for performance optimization.• Knowledge Transition to Production Support team for code changes which are migrating to Prod Environment and resolution to issues.• Good experience with Production Support activities, incidents, Service requests, Problem tickets, change tickets, DR activities, Maintenance activities with Service Now and Remedy.• Providing extended support during the production warranty period after the implementation and fix if any issues occur.