With over 8 years of expertise and a strong background in designing, implementing, and testing data integration solutions. Extensive ETL experience using Informatica PowerCenter for data extraction, transformation, and loading. Skilled in handling complex transformations such as update strategies, routers, XML, and normalizers. Expertise in Slowly Changing Dimensions (SCD), Change Data Capture (CDC), and Dimensional Data Modeling. Proficient in SQL with the ability to write complex queries using analytical functions, views, and triggers. Hands-on experience in performance tuning at various levels including SQL override, sources, targets, transformations, and sessions. Well-versed in using Lookup caches (Static, Dynamic, Persistent) and debugging Informatica mappings. Familiar with automation scheduling tools such as Stonebranch Universal Automation Center and Autosys for ETL job automation and file processing through Unix Shell Scripting. Consistently delivers high-quality results by meticulously crafting data mapping, design, and unit test documents. Strong analytical mindset and excellent communication skills. Thrives in Agile (SCRUM) methodology and excels at collaborating with teams. Detail-oriented with exceptional project management skills. Proactive approach to identifying and addressing issues while optimizing processes and supporting team objectives. Expertise in data mining, warehousing, and analytics. Quality-driven and hardworking with excellent communication skills contributing to successful project management.
AWS Partner: Technical Accredited