Lead Data Engineer holding more than 16 years of experience with extensive knowledge on several data warehouse tools like dbt cloud, Informatica Power center, Netezza, DataStage, Hadoop, Unix along with strong insurance domain knowledge.• Over 15 Years of extensive experience with Informatica Powercenter 10.2/9.5/9.1/8.6/8.1 Tools (Server and Client tools like (Repository Manager, Designer, Workflow manager, Workflow Monitor).• Over a year of experience working with Snowflake database.• Close to 10 years of working experience on Netezza Database and also worked on NZSQL/NZLOAD utilities.• Over an Year of experience working with IBM Infosight’s Hadoop ecosystem like Hive, Sqoop(Thoosa), Charon, BIGSQL, Athena.• Strong Knowledge in UNIX Scripting. Developed various reusable tools, frameworks which are used at enterprise level and are easily customized according to the business demands.• Interacted extensively with clients to gather requirements, prepare functional requirements and perform analysis and design to meet end user requirements. • Demonstrated and have work experience on both Agile and waterfall methodologies.• Strong experience on Workflow Manager Tools – Task Developer, Workflow & Worklet Designer.• Experience in creation of sessions, batches using Informatica workflow manager to run with the logic embedded in the mappings.• Developed complex and efficient mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, SQL etc• Developed Slowly Changing Dimension Mappings of type I, type II (version, flag and time stamp) and type III.• Sound Knowledge in Parameterizing Concept of Session Variables in Informatica• Experience in tuning mappings, identifying and resolving performance in various levels like sources, targets, mappings, and sessions.• Having command on troubleshooting with the help of error logs generated by Informatica server.• Strong Analytical skills.