About Me

8+ Years Professional experience in Data Warehousing ETL Technologies using Informatica power center Client tools – Designer, Work Flow Manager and Work Flow Monitor. Proficient in the Design and Development of process required Extracting, Transfor...Work Flow Monitor. Proficient in the Design and Development of process required Extracting, Transform, and Load data and Data warehousing modeling. Good understanding of source to target data mapping and Business rules associated with the ETL processes. Extensively Used Amazon Redshift, imported tables using plugin provided by Informatica 10 and loaded to Amazon Redshift Database. Implementing, Migration, testing and promoting all active integrations those that are running on Power Center (Data Integration) into Informatica Intelligent Cloud Services. Optimized the ETL process using Performance Tunings methods. Having Good Knowledge in copying data from S3 bucket to Redshift using Copy command. Having Knowledge on Complete Architecture of Amazon S3 and Amazon Redshift. Knowledge of different schemas (Star & Snowflake) to fit reporting, query and business analysis requirements. Used different sources and targets like Oracle, Flat Files, Sql Server, Amazon S3, Redshift, Paraccel Worked on UNIX Shell Scripting and Amazon S3 Command line. Developed a good understanding of existing business requirements & also questioned requirements when needed. Exposure to Sales/Marketing, Banking, Insurance, Finance, and Health Care projects. Worked on Key-Range, Round-Robin, Pass-through and Hash Auto-Keys partitions at Power Center session level. Used PMCMD command to automate the Power Center sessions and workflows through UNIX. Good understanding of all the Software development lifecycle methods like Waterfall, Agile, V Model, Iterative models. Knowledge integrating multiple cloud applications (like Salesforce, NetSuite) using IICS. Understanding of REST API guidelines to access and pass information to Informatica Cloud Organization. Experienced in creating publishing Processes in Informatica Cloud Real Time (ICRT). Used Service Connectors like JDBC, REST, File. Experienced in monitoring and debugging published processes from ICRT process control. Have done real time integration between salesforce and database using IICS. Performed integration between Cvent and Salesforce using IICS. Real time integration between Amazon S3, File system and Informatica cloud batch integration. Performed Informatica task dependency using ICRT. Consumed Informatica cloud APIs in ICRT to fetch the details and store in the Rest APIs. ATTRACTS Ability to analyze the root cause of problems swiftly and provide a prompt solution. Excellent team player with indispensable problem solving and creative ability and mainly have the ability to make myself irreplaceable (if needed), in a quick time period.