With over 12 years in IT, my expertise lies in Data Warehousing, specializing in Informatica PowerCenter/Informatica Cloud (IICS). Skilled in strategizing, designing, and developing ETL architectures for Data Warehouses, utilizing a wide range of tools. ● Extensive experience throughout the Software Development Life Cycle (SDLC), involving thedesign and execution of complete ETL projects, utilizing Informatica PowerCenter and IICSservices, to proficiently manage and reshape substantial data volumes.● Extensively worked with Informatica to create pipelines for extracting data from operational sourcesystems or datasets to staging tables and then Data Warehouse tables.● Strong understanding of data modeling concepts and experience in designing and developing datawarehouse solutions, to ensure accurate and efficient data storage and retrieval.● Proficiency in crafting Low-Level Design documents, such as S2TM, SSA, ADD, and DDL structures,while aligning with the BRD and High-Level Design document for reference.● Skilled in analyzing and interpreting complex data sets, identifying trends and patterns, andpresenting insights to stakeholders to facilitate data-driven decision-making.● Familiarity with identifying bottlenecks and performance issues in Informatica and analyzingExplain Plans in RDBMS.● Have worked on Development projects, Migration projects (PowerCenter code to IICS/GCP), ETL and Database decommission projects.● Certified in IICS data integration and GCP data engineering, demonstrating a commitment to staying up-to-date with the latest industry trends and technologies.● Demonstrated ability to work independently or as part of a team, with excellent communication,interpersonal, and problem-solving skills. Additionally, I actively contributed to Agile projects.● Delivered Functional and Technical training sessions within the team.Key Skills- ETL, Informatica Cloud (IICS), Informatica PowerCenter, BigQuery, Data Modelling